SQLite Expert 6 · Windows
Your workbench for SQLite databases.
Design tables, edit data, build queries, and run SQL — in one graphical environment that gives you the whole database without hiding the SQL underneath.
Design tables, edit data, build queries, and run SQL — in one graphical environment that gives you the whole database without hiding the SQL underneath.
Design and data, queries and scripts — each part built to work the way you do.
Restructure any table without losing its data. Every change runs inside a transaction that rolls back cleanly if anything fails.
Assemble queries by pointing and clicking across tables and joins, then turn any query into a reusable view.
See the whole database at once as an entity-relationship diagram, with a line between the columns every foreign key joins. Arrange it yourself and the layout comes back with the file. Professional Edition.
Syntax highlighting, code completion, and multi-statement scripts, with parsing that catches mistakes before they run.
Edit rows in place, including BLOB and image fields (BMP, JPG, PNG, GIF, ICO) with a built-in image viewer and hex editor.
SQL scripts, other SQLite databases, ADO sources, CSV/TSV, Excel, JSON, XML, HTML, and ODS — or copy tables by drag and drop.
ICU Unicode and encrypted databases in the Professional Edition, plus Lua and Pascal scripting to automate your work.
Rows stream from the file as you scroll, so memory 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.
Check integrity and index consistency, vacuum, analyze, checkpoint the write-ahead log — and when a database is damaged, repair it or recover what SQL can no longer reach.
Build joins and filters visually, then read back the generated SQL.
Columns, keys, indexes, constraints, and triggers — restructured without losing data.