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/Visualization (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/Visualization (1.0)/Schema Diagram

View a database schema diagram in QuackDB 1.0

See your database tables and how they relate in the QuackDB 1.0 schema diagram.

The Schema Diagram provides an interactive visualization of your database structure, powered by ReactFlow.

Features

Automatic Layout: Tables arranged using Dagre algorithm

Foreign Key Visualization: Lines connect related columns

Interactive: Drag tables, zoom with scroll, pan background

Search: Filter tables by name

Export: Save as PNG, SVG, or PDF

Position Memory: Saves your custom table positions

Visual Elements

Element	Meaning
🔑 Key icon	Primary key column
→ Arrow line	Foreign key relationship

Data Type Colors

Type	Color
INTEGER / INT	Blue
TEXT / VARCHAR	Green
REAL / FLOAT	Orange
BLOB	Purple
DATE / TIME	Teal
BOOLEAN	Pink

Tip: Click a table to highlight it and see its connections. The diagram has been tested with 50+ tables.

Need help?

Join our Discord community for support and discussions.

Join Discord