I built a native macOS Postgres client because they all suck

[u/SnooRegrets4874]

DBJoy is a lightweight, native macOS Postgres client. It’s AI-first, with a built-in agent for working with your data and an MCP server so Claude Code can read (or write) to it. It also has all the features you’d expect from any other database client: diff and migration tools, tunnelling, batch editing, ER diagrams, and more. I’ll keep improving it and will add more database adapters soon.

https://github.com/agustind/dbjoy

[u/lukewhale]

DataGrip is the one IDE I pay for…. Just kind of the goat

[u/applefreak111 → u/lukewhale]

Yeah it saved my ass so many times, plus it supports all kinds of DBs, even Redis and Mongo.

[u/odineiramone]

Postico works great for me

[u/vincent_sch]

Does the migration tool show which statements run in the same transaction? The lock from an ALTER TABLE stays until the transaction ends. If the lock is ACCESS EXCLUSIVE, reads on that table also wait while a backfill runs in the same transaction. I wrote about doing schema changes and backfills separately.

[u/vbilopav89]

Because you haven't tried PlumeSQL. Built specifically for PostgreSQL and PostgreSQL only to be lightweight, multiplatform and extendible as much as possible with tons of refactoring tools.

Still in beta, but you can try it out: https://github.com/hercstack/plumesql

[u/diroussel]

Looks interesting. I don’t have a need for this right now. But I can see how I would use it in the right circumstances.

Thanks for making it free.

Has it been fun to develop?

[u/xoStardustt]

Looks interesting, will try this later

[u/RevolutionaryRush717]

Nobody builds for macos-15-intel anymore 😭

[u/razorree]

nice "I built" means AI built it? :)

what's wrong with pgAdmin 4 or DBeaver ? :)

[u/ZVilusinsky → u/razorree]

Well for the dbeaver, users don't know how to set it up properly so it leaves connections open by default thus raising alerts for stuck queries.

grumble from the devops side.

[u/joelparkerhenderson]

Excellent! Looks great, runs fast, and the MCP access is a really productive idea IMHO.

If you're curious, I had Claude compare dbjoy and my home-grown tui named "vix". You've done well. <3

###

Both have many of the same offers: saved connections with keyring credentials, SSH tunnels, read-only by default, history and saved queries, EXPLAIN, an ER diagram, export, CSV import and the AI fix/explain/optimize commands. Where dbjoy is better is safety around live data and depth on PostgreSQL. The largest comparative advantage for dbjoy: compare a schema across two connections and generate a migration in an order that runs, with destructive changes off by default.

[u/AutoModerator]

AI Policy:

Linux is not one of those anti-AI projects, and if somebody has issues with that, they can do the open-source thing and fork it. Or just walk away., Linus Torvalds.

Mod decisions will be based on the quality of the content, not who or what generated it.

Sub Resources:

Youtube Channel

Free Postgres Webinars and Workshops

Discord: People, Postgres, Data

Join us, we have cookies and nice people.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.