Mac users who work with local or remote databases
Quay
Browse, edit, and query local or remote databases from your Mac. Quay is a native Mac database client for macOS 13 and later. It connects to local database files and to remote servers, directly or through an SSH tunnel, and works with 25 databases.
A QUANTYRA LABS PRODUCTLocal files and remote servers in one app
Open SQLite and DuckDB files on your Mac or connect to servers somewhere else, directly or through an SSH tunnel, with TLS where the engine supports it. Keep several databases open at once and switch between them from the window and database menus.
SSH tunnels for network engines
SSH local port forwarding works for network engines, including the PostgreSQL family, the MySQL family, SQL Server, Redis, MongoDB, Cassandra, and Elasticsearch. SQLite and DuckDB files can’t use SSH.
Safe modes on every connection
Each connection gets one of five modes: silent, warn on every query, warn on changes, password before every query, or password before changes. You decide how much friction stands between you and a change.
Secrets stay in the macOS keychain
Database passwords, SQLite passphrases, SSH passwords, and LLM API keys live in the macOS keychain under local.quay.database.
Write Query from plain language
Describe what you want, attach structure with @table or @table->column, and the SQL lands in the editor. It runs on your own Claude or Grok key, and it won’t send anything until you’ve saved a key and typed a description.
One price, yours for good
One $40 payment gets you a lifetime license, with no subscription.
Supported databases
Quay works with 25 databases.
Full support (14). Browse, query, and edit rows in SQLite, DuckDB, PostgreSQL, CockroachDB, Greenplum, Vertica, Amazon Redshift, MySQL, MariaDB, SingleStore, Redis, Valkey, libSQL / Turso, and Cloudflare D1.
Connect and query (11). Row editing is coming for SQL Server, Azure SQL, ClickHouse, MongoDB, Cassandra, ScyllaDB, Snowflake, BigQuery, DynamoDB, Elasticsearch, and OpenSearch.
More in the app
Query editor. SQL highlighting, table and column completion, formatting, history, and favorites. You can also split the editor.
Table work. Multi-row filters, inline edits, and add and delete. SQLite rows are addressed by rowid, PostgreSQL rows by primary key.
The first window. A saved-connection list where each connection has a name, status color, tag, and safe mode. Open one for a schema sidebar of tables, views, indexes, and functions, plus query tabs and a result grid.
Safe by design. Removing a connection does not delete the database file.
Who it’s for
Mac users who work with local or remote databases.
Version 0.1.1 is for anyone who needs to look at a database, change rows, and write SQL from a Mac, whether the server sits on that Mac or somewhere else.
About the name
In ordinary English, a quay is the dock where a ship comes alongside to load and unload. Quay is the place on your Mac where you pull up to a database, local or remote, and work with what’s stored there.
What this helps you do
- Browse local or remote databases, edit rows, and write SQL, all from your Mac
- Keep several databases open and switch among them
- Choose whether a query or a change stays silent, warns you, or asks for a password
Built to help you
- Saved connections with a name, status color, tag, and safe mode
- Schema sidebar for tables, views, indexes, and functions
- SQL highlighting, completion, formatting, history, and favorites
- Table paging, filters, and cell edits
- Write Query from a plain-language request
A few answers
About Quay
What is Quay?
Quay is Quantyra Labs’ native macOS database client for macOS 13 and later. It works with 25 databases, from local SQLite and DuckDB files to remote Postgres, MySQL, Redis, and cloud warehouses.
Which databases does Quay open?
Full support, with browsing, querying, and row editing: SQLite, DuckDB, PostgreSQL, CockroachDB, Greenplum, Vertica, Amazon Redshift, MySQL, MariaDB, SingleStore, Redis, Valkey, libSQL / Turso, and Cloudflare D1. Connect and query, with row editing coming: SQL Server, Azure SQL, ClickHouse, MongoDB, Cassandra, ScyllaDB, Snowflake, BigQuery, DynamoDB, Elasticsearch, and OpenSearch.
Can Quay connect to a remote server?
Yes. It connects directly or through an SSH tunnel, with TLS where the engine supports it. SQLite and DuckDB files can't use SSH.
How much does Quay cost?
One $40 payment gets you a lifetime license, with no subscription.
Where does Quay keep secrets?
In the macOS keychain under local.quay.database. That covers database passwords, SQLite passphrases, SSH passwords, and LLM API keys.
Does removing a connection delete the database?
No. Removing a connection does not delete the database file.
How does Write Query work?
Type a plain-language request and use @table or @table->column to attach structure. The SQL lands in the editor. It uses your own Claude or Grok key and won't send a request without a saved key and a description.
Where do I download Quay?
Download Quay 0.1.1 for Mac from this page. It runs on macOS 13 and later. Open the file and move Quay into the Applications folder.