Skip to main content

​
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 with file path field

SQLite connection form

​
Common Locations

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

​
Connection URL

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.