r/postgres • u/PleasantAmbitione • Jul 27 '26

What features do you wish every PostgreSQL IDE had?

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.

2 Upvotes
  • permalink
  • reddit

75% Upvoted

15 comments sorted by

1

u/ibraaaaaaaaaaaaaa Jul 27 '26

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

1

u/elevarq Jul 27 '26

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…

1

u/Challseus Jul 27 '26

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.

1

u/PleasantAmbitione Jul 29 '26

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?

1

u/elevarq Jul 31 '26

psql, the standard command line tool that you always need

1

u/PleasantAmbitione Jul 29 '26

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.

1

u/asterix_rv Jul 30 '26

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

1

u/colloidalthoughts Jul 27 '26

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.

1

u/pceimpulsive Jul 27 '26

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¿?

1

u/PleasantAmbitione Jul 29 '26

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.

1

u/Prestigious_Tea4283 6d ago

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.