Skip to content

SQLite GUI and database browser ​

Open a SQLite file in SqlKit to browse its tables and views or run SQL against it. The app is open source and runs on macOS, Windows, and Linux.

Open a SQLite file ​

  1. Download and install SqlKit, then open Connections → Add New Connection.
  2. Choose SQLite, give the connection a name, and use Open… to select an existing database file. To create a database, use New… to pick a file path.
  3. Save the connection, then choose Connect. In Queries, expand the object tree and double-click a table to view its data.

List tables and views in the file ​

sql
SELECT type, name
FROM sqlite_schema
WHERE type IN ('table', 'view')
ORDER BY type, name;

Run the query in Queries. If an existing database looks empty, check the file path in the connection. If you created a file at a different path, it starts with no user tables.

For SQLite, the local file path takes the place of a server address and TCP port. For a SQLCipher-encrypted file, choose SQLCipher and supply its encryption key. See the SQL editor guide to save SQL or export rows to CSV or JSON.