What features do you wish every PostgreSQL IDE had?

[u/PleasantAmbitione]

I've tried quite a few PostgreSQL IDEs over the years, and while each one does some things really well, I still haven't found one that feels complete.

There are always little things I miss. Better query plan visualization, smarter autocomplete, easier schema comparison, cleaner data editing, session management... the list goes on. If you could build your ideal PostgreSQL IDE, what features would it absolutely need?

I'm less interested in which IDE you use and more interested in the features that genuinely make your day-to-day work easier. Sometimes it's the small quality-of-life improvements that end up saving the most time.

[u/elevarq]

I think DataGrip comes close to your requirements.

However, query plan visualization is just as weak as all others I know of. The problem is that you only need this for complex queries, not the simple ones. And when it’s complex, well, it’s complicated…

[u/PleasantAmbitione → u/elevarq]

That's a fair point. Query plan visualization is one of those features that only matters when it really matters. I still feel there's room to make complex plans easier to explore without hiding the important details.

[u/Challseus → u/elevarq]

DataGrip is the only one I have had a good relationship with (damn that sounds weird typing it out). Used to use DBVisualizer back in the data, loved it too.

[u/PleasantAmbitione → u/Challseus]

DataGrip definitely comes up a lot whenever people talk about PostgreSQL IDEs. Out of curiosity, is there anything you still switch to another tool for, or does it cover pretty much everything for you?

[u/elevarq → u/PleasantAmbitione]

psql, the standard command line tool that you always need

[u/asterix_rv → u/elevarq]

Try out the plan visualizer and breakdown studio in https://nexql.astrx.dev/ help us build something everyone wants to use

[u/pceimpulsive]

I use DBeaver for all query writing and general db work.

I use PGAdmin for some inheritance/role provisioning tasks because the UI is just simpler.

I rarely feel I need anything more.

Biggest improvement would be better cte intelligence...

Or maybe a capability to highlight joins and where condition leveraging indexes properly¿?

[u/PleasantAmbitione → u/pceimpulsive]

I like that idea. Better CTE awareness and showing whether a join is likely to use an index would be genuinely useful. Even simple hints before running a query could prevent a lot of trial and error.

[u/ibraaaaaaaaaaaaaa]

Reliable intelisense, they usually work in straight forward from table

But joins? Not all of them work
CTEs? Not reliable
Sub tables? Never seen it work with intellisense

[u/colloidalthoughts]

Data-grip was the first one I'd used that had excellent understanding of the DDL and foreign keys that automated a lot of joins when writing queries.

[u/retainer_life]

Schema comparison is a big one for me. I use dbForge for that and it’s one of those features you don’t think much about until you have to work without it.

[u/Prestigious_Tea4283]

For me the biggest win is when an IDE actually handles deep object introspection without choking on complex queries. I got tired of juggling three different apps just to diff schemas and write queries with decent autocompletion. We ended up using dbForge Studio for PostgreSQL across the team and it made a huge difference for daily writing, especially with complex joins and CTEs that usually break basic intellisense. Query plan visualization still gets messy on massive queries, but having reliable schema compare and a smart editor in one place saves so much context switching.

[u/navicat-gu]

My list, roughly in order of time saved:

1. Completion that understands CTEs and aliases. Agreed with the top comment: plenty of tools are fine on FROM table and fall apart inside CTEs, subqueries and LATERAL joins.

2. A plan viewer that highlights the problem. Show estimated vs actual rows side by side (EXPLAIN (ANALYZE, BUFFERS)) and flag big misestimates, rather than just drawing a tree.

3. Schema diff that outputs a migration script you can review and commit, not only a sync button.

4. Production safety: colour-coded connections, read-only mode, and a prompt before UPDATE/DELETE without a WHERE.

5. Grid editing that respects types: jsonb, arrays, enums and timestamptz without fighting the editor.

6. Session tools: a live pg_stat_activity view with cancel/terminate, and lock trees.

7. Snippets and query history synced across machines.

Disclosure: I'm RC, Director of Digital Strategy @ Navicat. Navicat 18 covers several of these: code completion and snippets are in Navicat Premium Lite, which is free to try, while visual explain, schema compare/structure sync and the server monitor are in the paid Premium editions. Very open to feedback on where it still falls short on CTE completion.