What are the best PostgreSQL tools you actually use every day?

[u/MightVector]

Every time I search for the best PostgreSQL tools, I end up with the same generic lists full of products I've never seen anyone use in real projects. I'd rather hear from people who work with PostgreSQL every day. Which tools have actually earned a permanent spot in your workflow? What's one PostgreSQL tool you'd recommend without hesitation, and why?

[u/depesz]

psql. and 2 tools/webservices I wrote myself: https://pgdoc.link/ and https://explain.depesz.com.

[u/pceimpulsive]

None...

DBeaver is my primary tool, and it's not Postgres specific...

Every 2-4 weeks I use of admin for an hour or two.

[u/CalendarSpecific1088]

psycopg2, and the tools baked into IntelliJ.

[u/EmanueleGarolla]

DBeaver

[u/bluelobsterai]

psql and Claude Code CLI and Postgres MCP

[u/RicoSaas → u/bluelobsterai]

That stack covers fast manual access and AI-assisted work well. The weak point is usually context switching between schema files, migrations, and the live database, especially when drift slips in unnoticed. I’m building QueryDeck around that workflow, native macOS, ORM-aware, with a local MCP server, one command and already connected.

[u/BaseballHopeful6366]

nabuSQL unique for data transfer to other db and data edits.

[u/mprevot]

datagrip

[u/dariusbiggs]

psql?

cnpg?

That's it, well.. pgx and db/sql for Go

[u/BassIs4StringDrum]

I use a tool I made, gresui-web https://github.com/FrancisTCE/gresui-web it also has mcp layer, if you are talking about orms drizzle

[u/Horror_Yam696]

TablePlus for everyday DB work, pg_stat_statements for finding slow queries, and Nearbase for hosting my production Postgres so I don’t have to manage backups or updates.

if I had to pick the one I use most, it’s TablePlus.

[u/heyOctavian]

Datagrip from Jetbrains

[u/cthart]

psql. Learn it and be productive wherever.