SQLite Desk Pro: Database Checks, Compare & Safe Editing for VS Code

Check your SQLite databases and compare versions without leaving VS Code.

SQLite Desk Pro is an add-on for the free SQLite Desk extension. It adds:

Pass/fail database checks

Write simple checks, like "no orders without a customer", and run them all with one click. You get a clean report showing what passed, what failed, and example rows for anything that failed. Paste it into a ticket or release checklist.

Compare two databases

See exactly what changed between two versions of a database: tables, columns, keys, indexes and more. Catch a bad migration before you ship it.

Safe editing

Edit cells, add or delete rows, and change tables. Nothing touches your file until you press Save, and a backup copy is made first (the last 3 are kept). It won't save if the file changed on disk while you were working, or if it finds the database's temporary side files (left while another app is writing to it).

Import and export

Bring in CSV or JSON files. Export tables to CSV, JSON or SQL, or the whole database at once.

Diagram of your tables

See how your tables connect, drawn automatically from your database.

No limits

See every row (the free version stops at 1,000), plus query history and a saved list of your databases.

Private and simple

No account, no login, no ads, no tracking, no internet needed. Nothing extra to install.

$12 one-time. All 1.x updates are free.

Good to know

• Requires the free SQLite Desk extension from the VS Code Marketplace.
• The whole database is loaded into memory: about 3 times the file size while viewing and about 4 times while editing, until you reload the VS Code window. Files over 100 MB ask before opening.
• Full-text search tables (FTS5) and map/geometry index tables (R*Tree) can't be queried, and the full SQL export recreates them empty. Older full-text tables (FTS3/FTS4), JSON and math functions work.
• Recent changes another app hasn't finished writing into the main file yet aren't shown.
• Views and a few special table types can't be edited in the grid; change those with a query instead.
• Tested on Linux. Mac and Windows aren't verified yet.

Support: zecroapp@gmail.com

© 2026 Zecro LLC. Governed by Washington State law.