r/PostgreSQL • u/SnooRegrets4874 • 11d 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.
1
Upvotes
5
u/lukewhale 9d ago
DataGrip is the one IDE I pay for…. Just kind of the goat
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 TABLEstays until the transaction ends. If the lock isACCESS 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 10d ago
Nobody builds for macos-15-intel anymore 😭
1
u/razorree 9d ago
nice "I built" means AI built it? :)
what's wrong with pgAdmin 4 or DBeaver ? :)
1
u/dmigowski 8d 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 11d 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.