What is SQLite Expert?

SQLite Expert is a powerful visual tool for creating, administering, and exploring SQLite 3 databases. It brings database design, data editing, querying, and maintenance together in a single, clear graphical environment — so you can accomplish most tasks without writing a line of SQL, while keeping full SQL access whenever you need it.

What you can do with SQLite Expert:

• Design tables and views visually — add and restructure columns, foreign keys, indexes, constraints, and triggers without losing the data already in your tables, and copy them between tables through the clipboard.
• Build queries visually with the integrated Query Builder, and turn them into views.
• Run SQL scripts with syntax highlighting, code completion, and support for multiple statements in one script.
• View and edit data in a rich grid, including BLOB and image fields (BMP, JPG, PNG, GIF, ICO) with a built-in hex editor.
• Import and export data to and from SQL scripts, other SQLite databases, ADO data sources, text files (CSV/TSV), Excel, JSON, XML, HTML, and ODS.
• Create databases, inspect and change their parameters, check their integrity, and vacuum (compact) them.
• Attach and detach databases, and use transactions and savepoints.
• Access encrypted databases and the ICU extension (Professional Edition).
• Extend the program with Lua and Pascal scripting.
• Map SQLite's flexible types to 40 predefined and custom data types.

SQLite Expert comes in two editions: a free Personal Edition and a Professional Edition. This help file describes the Professional Edition; for a side-by-side list of what each edition includes, see the feature comparison.