Description
You have a .db file and want to see what is inside. The sqlite3 command line means remembering .tables and .schema, and the output is misaligned text; changing one row means hand-writing an UPDATE with a WHERE clause and no undo if you get it wrong. SQLite Expert turns that into an interface: every table listed in a tree on the left, double-click to page through data like a spreadsheet and edit cells in place, with a syntax-highlighted SQL editor and query planner on the right.
The awkward parts of SQLite become dialogs. Altering a table no longer means writing the create-temp-table, copy, drop, rename dance yourself, and indexes, triggers, views and foreign keys all have editors of their own. The Personal edition is free for both personal and commercial use.
Visual table design: add columns, change types, set primary and foreign keys, create indexes and triggers through dialogs, with the program generating and running the SQL — including SQLite's roundabout schema migrations.
Edit data in the grid: rows display like a spreadsheet, cells are editable in place and rows can be added or deleted, so a small correction does not need a hand-written statement.
SQL editor: syntax highlighting, completion and multiple result sets, able to run any statement and show the Explain Query Plan so you can see whether a query actually used an index.
Graphical query builder: drag out table relationships to generate a statement when you are not fluent in SQL, then keep editing the generated SQL by hand.
Import and export: wizards move data between CSV, SQL scripts and Excel, whether loading external data into a table or pulling query results out.
Database maintenance: VACUUM, integrity checks and index rebuilds are built in, alongside encryption, backup and repair.
Several databases at once: multiple database files can be attached and queried together in a single statement rather than switching windows.
Free Personal edition: the free build covers everyday browsing, editing, schema work and querying, in personal and commercial settings alike.
The awkward parts of SQLite become dialogs. Altering a table no longer means writing the create-temp-table, copy, drop, rename dance yourself, and indexes, triggers, views and foreign keys all have editors of their own. The Personal edition is free for both personal and commercial use.
Features
Visual table design: add columns, change types, set primary and foreign keys, create indexes and triggers through dialogs, with the program generating and running the SQL — including SQLite's roundabout schema migrations.
Edit data in the grid: rows display like a spreadsheet, cells are editable in place and rows can be added or deleted, so a small correction does not need a hand-written statement.
SQL editor: syntax highlighting, completion and multiple result sets, able to run any statement and show the Explain Query Plan so you can see whether a query actually used an index.
Graphical query builder: drag out table relationships to generate a statement when you are not fluent in SQL, then keep editing the generated SQL by hand.
Import and export: wizards move data between CSV, SQL scripts and Excel, whether loading external data into a table or pulling query results out.
Database maintenance: VACUUM, integrity checks and index rebuilds are built in, alongside encryption, backup and repair.
Several databases at once: multiple database files can be attached and queried together in a single statement rather than switching windows.
Free Personal edition: the free build covers everyday browsing, editing, schema work and querying, in personal and commercial settings alike.
