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)/Connection Overview

How database connections work in QuackDB 1.0

What a connection is in QuackDB 1.0, the previous version, and the database types it can open.

QuackDB provides a unified interface for connecting to multiple database types. All connections are stored locally and passwords are encrypted using your system's secure credential storage.

Supported Databases

Database	Version	Connection Type
SQLite	3.x	Local file
PostgreSQL	12+	Network (SSL supported)
Supabase	PostgreSQL 15	Network (SSL required)
MySQL / MariaDB	5.7+ / 10.2+	Network (SSL supported)
SQL Server	2016+	Network
PGlite	PostgreSQL 16 compatible	In-browser

Connection Features

Unlimited Connections

Save and organize as many connections as you need

Secure Storage

Passwords encrypted using OS keychain

Quick Connect

Access recent connections from the home screen

Connection Testing

Test connections before saving

Privacy: All connection data is stored locally on your machine. No data is ever sent to external servers.

Need help?

Join our Discord community for support and discussions.

Join Discord