SQLite Expert Help¶

Welcome to the SQLite Expert user manual. SQLite Expert is a powerful visual tool for creating, administering, and exploring SQLite 3 databases.

Use the navigation on the left to browse, the search box at the top to find a topic quickly, or start from one of the sections below.

Contents¶

Introduction — what SQLite Expert is, what's new, licensing, and installation.
Using SQLite3 databases — creating, opening, maintaining, and backing up databases.
Editing tables — the visual table designer: columns, keys, indexes, constraints, and triggers.
Editing virtual tables — full-text search and other module-backed tables.
Editing views — saved queries you can reuse like tables.
Using SQL scripts — the SQL editor, parameters, and code completion.
Viewing and editing data — browse and edit rows in the grid.
Using the SQL Query Builder — build queries visually.
Importing and exporting data — Excel, text, JSON, XML, SQL, and the Data Transfer Wizard.
Using transactions — group changes safely with commit, rollback, and savepoints.
Data types — how SQLite's types map to SQLite Expert.
Extending SQLite Expert using scripting — automate tasks with Lua or Pascal.
Changing options — configure the program to suit you.
Getting help — support, the web, and sending feedback.
Known issues — SQLite limitations and workarounds.