QuackDB: a native SQL client for Mac

QuackDB is a native Mac database client that brings SQLite, PostgreSQL, MySQL, SQL Server and Supabase into one workspace, with a SQL editor, a data grid and a schema diagram.

SQL editor for Mac

Write a query, run it and read the results on the same screen. QuackDB remembers the queries you have run, lets you save the ones worth keeping and formats SQL so it stays readable.

Data grid and SQL file viewer

Open a SQLite file (.db, .sqlite, .sqlite3) or a table on a server, filter and sort it, and edit values in place. Import and export CSV, TXT, JSON or SQL.

Commit and undo changes

Edits are collected as pending changes that you review and commit with a message. Each commit is recorded in the change history, and a committed change can be undone from there.

Schema diagram

See how tables connect, drawn from the foreign keys already in your database, and open a table or add a column from the diagram.

Get QuackDB

The native version, QuackDB for Mac, is now available on the Mac App Store, where plans are managed with your Apple Account. QuackDB 1.0, the previous version for Mac, is free to download now.

See how to get QuackDB · Previous version, free

Docs/Database Connections (1.0)

These guides describe QuackDB 1.0, the previous version. Screens and some features differ in the new native Mac version, which has its own guides.

Go to the new guides Get the previous version

Navigate Documentation

Docs/Database Connections (1.0)/SQLite

Open a SQLite database file in QuackDB 1.0

Connect QuackDB 1.0 to a local SQLite database file on your Mac.

SQLite databases are stored as single files on your computer. QuackDB uses native C++ bindings (better-sqlite3) for maximum performance.

Supported File Extensions

.db.sqlite.sqlite3

Connection Options

Option	Description
Path	Path to your database file
Read-only	Open in read-only mode (optional)

Supported Features

WAL mode for concurrent access

In-memory databases

FTS (Full-Text Search)

JSON1 extension

Attached databases

R-Tree indexes

Note: SQLite supports only one write operation at a time. QuackDB uses WAL mode to improve concurrent read performance.

Need help?

Join our Discord community for support and discussions.

Join Discord