SQLite

Open and query SQLite database files directly, no server needed

SQLite Databases

SQLite is a file-based database engine. The whole database is one file on your Mac. The driver ships with TablePro, nothing to install.

Quick Setup

Click New Connection, select SQLite, browse for the database file, and click Save & Connect. No host, port, or credentials.

Point the path at a file that does not exist and TablePro creates the database on connect.

TablePro registers as a handler for .db, .db3, .s3db, .sl3, .sqlite, .sqlite3, and .sqlitedb files, so double-clicking one in Finder opens it directly.

SQLite connection form

Common Locations

Source	Path
Safari history	~/Library/Safari/History.db
Photos	~/Pictures/Photos Library.photoslibrary/database/Photos.sqlite
Messages	~/Library/Messages/chat.db
Rails	./db/development.sqlite3
Django	./db.sqlite3
iOS Simulator	~/Library/Developer/CoreSimulator/...

System databases may be locked. Quit their parent app before opening.

Connection URL

sqlite:///path/to/database.db

See Connection URL Reference for all parameters.

Features

• The sidebar lists tables and views. Internal sqlite_* tables are hidden.
• Table info shows columns, constraints, indexes, foreign keys, and DDL.
• Triggers can be viewed and edited.
• External changes to the file are picked up by a file watcher, no manual refresh needed.

Troubleshooting

Locked database: Close other apps using the file, or check for WAL files (database.sqlite-wal, database.sqlite-shm) left by a crashed process.

Can’t open: Verify the path exists and you have read permission on the file.