SQLite

A SQLite browser that belongs on a Mac.

Drop a SQLite file on the window and it is a connection: browse its tables, run queries, edit rows in place. A file on your own Mac is a local database, so it is free.

Download for macOS See every feature

Free for the databases on your Mac. Pricing

SQLite

What SQLite gets.

The kinds of object that exist on an engine are the kinds the app shows. This is SQLite's row of the features table, and what stands behind it.

EngineEditable gridDesignersUsers & RolesDiagram
SQLite✓with table rebuilds✓tables, indexes, triggers—✓

A file is a connection

A SQLite file becomes a saved connection named after the file; opening it again selects that connection rather than making a second one. The app reads the first bytes before it trusts the name.

Guide: opening files

Changes SQLite cannot make in place

A type, default, key or foreign-key change follows the SQLite manual's recipe — new table, copy the rows, drop the old one, rename, restore indexes and triggers — in one transaction.

Guide: the table designer

A diagram from the real foreign keys

A key that points at a table without naming a column is resolved to that table's primary key, so the lines land where SQLite means them to.

Guide: the schema diagram

sqlite3, on the same file

A console tab is a real terminal running sqlite3 on the file. The prompt, history and pager are the client's own.

Guide: console tabs
Connect

Connect to SQLite.

Drop the file on the window or on the Dock icon, double-click it in Finder, or use File ▸ Open… (⌘O). Or click Add Connection under the sidebar, pick the SQLite tile, and click Choose… to pick a file or New… to create one. The Connection String field reads sqlite:// addresses and a bare path.

Connects to
A file on your Mac. No port, no SSL, no accounts.
Files
SQLite 3 database files, read with the SQLite library that comes with macOS.
Console
sqlite3 — brew install sqlite
Notes
A type, default, key or foreign-key change rebuilds the table in place, rows copied over in one transaction. See The table designer.

Guide: SQLite in the docs Guide: your first connection

Every engine

One app for the rest of your databases, too.

Every feature is built against one driver contract, so the grid, the designers and the assistant work the same whichever server you open next.

PostgreSQL MySQL MariaDB SQLite SQL Server Oracle IBM Db2 MongoDB Redis DuckDBand CSV files ClickHouse Databricks

Try it on your own database.

Free for the databases on your Mac, and never asking you to sign in.

Download DBClient

$brew install --cask az-code-lab/taps/dbclient