Skip to main content
SQLite works like the rest of FlexTable (browse and edit, query), with one difference: it is a file, not a server.

​
Open a database file

There is no host, port, or credentials. Choose SQLite as the connection type, pick your .db or .sqlite file, and save. See Connect to a database.

​
Types

SQLite uses dynamic typing, so a column can hold different value types. FlexTable shows the stored value as-is and edits it inline in the grid.

​
Structure

The Structure tab shows the table’s columns, indexes, and foreign keys, and relationships appear in the ER diagram.
SQLite is great for local development and inspecting an app’s database file directly.