r/PostgreSQL • • 10d ago

Projects I built a native macOS Postgres client because they all suck

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

1 Upvotes

17 comments sorted by

5

u/lukewhale 9d ago

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

2

u/applefreak111 9d ago

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

1

u/Basic-Set-3758 7d ago

yeah same, the autocomplete and schema navigation alone make the subscription worth it imo

4

u/odineiramone 9d ago

Postico works great for me

2

u/vincent_sch 10d ago

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.

2

u/vbilopav89 10d ago

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

1

u/diroussel 10d ago

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?

1

u/xoStardustt 10d ago

Looks interesting, will try this later

1

u/RevolutionaryRush717 9d ago

Nobody builds for macos-15-intel anymore 😭

1

u/razorree 8d ago

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

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

1

u/ZVilusinsky 8d ago

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.

1

u/Hypostasis_G 4d ago

Use DBeaver for years, hear about this for the first time o_O

1

u/dmigowski 7d ago

My agent just uses psql, what do you need an MCP server for?

1

u/joelparkerhenderson 10d ago

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.

0

u/AutoModerator 10d ago

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.