Design and data, queries and scripts — a complete environment for SQLite 3 databases, at any size, with full SQL always within reach.
Add and restructure columns, foreign keys, indexes, constraints, and triggers — without losing the data already in your tables, and including STRICT tables and generated columns. Most edits now apply directly with ALTER TABLE rather than rebuilding the table, so your DDL keeps its own formatting. Every change runs inside a transaction that rolls back cleanly if anything fails.
Assemble complex queries — including sub-queries and unions — by dragging tables and building WHERE/HAVING criteria visually, then turn any query into a view. Professional Edition.
See the whole database as an entity-relationship diagram: a box per table, view and virtual table, and a line between the columns each foreign key joins, marked with the cardinality SQLite Expert works out from the keys. Arrange it automatically or place the tables yourself and keep the layout, then save it as a picture, export it to PDF, or print it. Professional Edition.
Syntax highlighting, SQL formatting, script parameters, and multi-statement scripts you can save and reload. Completion is read from the database you are connected to, so it offers your tables and columns, the functions the engine has — including any an extension adds — and the pragmas that library supports.
Edit rows in place with filtering, a text editor, a hex editor for BLOBs, an image editor for BMP, JPEG, PNG, GIF and ICO, and a JSON editor that reads both JSON text and JSONB.
Export a grid to Excel, ODS, CSV/TSV, XML, HTML, JSON or an SQL script — and read data back in from JSON, XML, HTML pages, spreadsheets, text files, SQL scripts and ADO sources, into a new table or an existing one, choosing how the new table’s columns are declared — STRICT included. Plus transfer data directly between SQLite databases. Professional Edition.
Rows stream from the file as you scroll, so working set follows the window on screen and not the size of the database. An 11 GB file of 31 million rows opens in under three seconds on our test machine, shows its first page of data half a second later, and browses in about 145 MB of memory.
Create databases and inspect or change their parameters. Check integrity, foreign keys, schema references, and every index against the table it indexes. Vacuum in place or into a new file, reindex, analyze and optimize, reclaim free pages, and checkpoint the write-ahead log.
Repair copies out everything SQLite can still read from a damaged database. When the damage runs deeper than SQL can reach, Recover reads the file page by page and can sweep orphaned pages into a lost-and-found table. Professional Edition.
See how two databases differ in schema and in data, then generate the script that brings one in line with the other. Professional Edition.
Read any query's plan before you run it, and keep the planner's statistics honest with Analyze and Optimize.
Browse a catalog of well-known SQLite extensions, load one in a click, and choose which extensions load automatically for a given database.
The ICU extension for Unicode-aware collations and case handling, and support for encrypted databases. Professional Edition.
Automate repetitive work with built-in scripting and the included example scripts. Professional Edition.
A STRICT table refuses values that do not match its columns’ declared types instead of converting them — so the question is as much about the data already in the table as about the types. The wizard reads it first and reports, column by column, the type each one would take and how many rows would be refused, kept under a different type, or come back changed. Nothing is altered until the last step, which shows the SQL before it runs.
Map SQLite's flexible typing onto 40 predefined data types — or define custom types that fit your schema.
The free Personal Edition covers everyday SQLite work. The Professional Edition adds the Query Builder, the schema diagram, the full import/export range, encryption, reporting, and scripting.
| Capability | Personal | Professional |
|---|---|---|
| Visual table & view designers (restructure without data loss) | ✓ | ✓ |
| SQL editor — highlighting, completion, formatting, parameters | ✓ | ✓ |
| Data grid with image, BLOB, and text editors | ✓ | ✓ |
| 40 predefined data types + custom types | ✓ | ✓ |
| Light & dark skins | ✓ | ✓ |
| Transactions, attached databases, extensions | ✓ | ✓ |
| Virtual tables — FTS3, FTS4, FTS5, RTREE | ✓ | ✓ |
| STRICT tables and generated columns | ✓ | ✓ |
| Multi-gigabyte databases — rows stream as you scroll | ✓ | ✓ |
| Checks — integrity, foreign keys, schema references, index consistency | ✓ | ✓ |
| Maintenance — vacuum, vacuum into, reindex, analyze, optimize, incremental vacuum, WAL checkpoint | ✓ | ✓ |
| Query plan viewer | ✓ | ✓ |
| Extension catalog with per-database auto-load | ✓ | ✓ |
| JSON editor for cell values (JSON text and JSONB) | ✓ | ✓ |
| Repair and Recover damaged databases | — | ✓ |
| Visual Query Builder | — | ✓ |
| Schema diagram, with print and PDF export | — | ✓ |
| Import & export — JSON, XML, HTML, Excel/ODS spreadsheets, CSV/TSV, SQL, ADO, and between SQLite databases | — | ✓ |
| Encrypted databases | — | ✓ |
| ICU Unicode extension | — | ✓ |
| Reporting — print, PDF | — | ✓ |
| Schema tab — a text report of the whole database | — | ✓ |
| Compare two databases — schema and data, with a migration script | — | ✓ |
| Online backup | — | ✓ |
| Lua & Pascal scripting | — | ✓ |