sqlclient · macOS
Open a SQLite file on Mac
Open SQLite databases on Mac, browse tables, run SQL, and edit data. SQLite remains free in sqlclient.
A SQLite database is a file. You do not need a server, port, or database account. In sqlclient, choose SQLite, select an existing file in the file picker, and start working with its tables.
Run your first query in three steps
- Download sqlclient and open the app on your Mac.
- Add a connection using the SQLite engine. Select your existing database file. Use New file to create a database; opening a misspelled path does not silently create an empty database.
- Open the SQL editor and run this query to list the tables in your file:
SELECT name
FROM sqlite_master
WHERE type = 'table'
ORDER BY name;
You can then browse tables, filter and sort rows, edit values, and export results. SQLite querying, schema work, editing, and export remain free. The 30-day trial for server engines starts without a purchase or payment details.
If the file will not open
Check that the file is still at the selected location and that your user account can read it. In the App Store build, the file picker grants access; choose the file again after moving it. For a live database, prefer a local disk over a network share or a folder being synchronized by several computers, because SQLite relies on file locking.
See the SQLite documentation for file permissions and further details.