<div align="center">
<pre>
██████╗ ██████╗ ██╗ ██████╗ ██╗ ██╗
██╔══██╗██╔══██╗ ██║██╔═══██╗╚██╗ ██╔╝
██║ ██║██████╔╝ ██║██║ ██║ ╚████╔╝
██║ ██║██╔══██╗██ ██║██║ ██║ ╚██╔╝
██████╔╝██████╔╝╚█████╔╝╚██████╔╝ ██║
╚═════╝ ╚═════╝ ╚════╝ ╚═════╝ ╚═╝
</pre>
</div>
The AI-first PostgreSQL client for the Mac. Ask questions about your data in plain language and get answers backed
by real queries, or have the SQL written for you, with your own Anthropic or OpenAI key. Then browse schemas, edit
data safely, write SQL and export, all in a fast, keyboard-friendly SwiftUI app. More database engines can be added
as drivers.
<p align="center">
<img src="demo.gif" alt="DBJoy tour: color-coded connections, browsing the products table, the AI assistant answering which countries bring in the most revenue, the assistant writing a top-customers query that runs in a tab, the ER diagram, comparing the staging and production schemas with the generated migration SQL, and Claude Code's queries in Settings → MCP" width="880">
</p>
Install
Download the latest DBJoy-<version>.dmg from Releases, open it, and
drag DBJoy to Applications. Builds are signed with a Developer ID and notarized by Apple.
- macOS 15 or later, Apple Silicon
- Self-contained: libpq, pg_dump (for backups) and psql (for copying databases) ship inside the app
Features
AI assistant
- Ask about your data in plain language (⌘J): the assistant looks up table structures, runs queries and answers
with the results, shown inline in the chat
- Ask it to write SQL and it opens the query in a new tab for you to review, run or save
- Chats are saved automatically per connection; reopen one to pick up where you left off, and organize them in
folders (drag a chat onto a folder, or use its context menu to rename, move or delete it)
- Bring your own Anthropic or OpenAI API key (Settings → AI Assistant); keys are stored in the mac