[PaulHoule]

Database administrator tools like pgadmin4. Postgres has maybe 30 kinds of artifact that are in a dropdown tree (e.g. stored procs, collations, etc.) but most of the time all I care about is tables but I have to ignore and click past so many things just to find the table I'm looking for.

I am always harassed about queries I didn't "save" but there isn't a model for saving queries that works with the way I do software development (e.g. I don't have a git repository full of SQL queries thought I might want to keep SQL queries in files in the same repo as my Java/Python/whatever and bring them in as resources)

Products like this don't respect the fact that I am thinking about how a few tables and/or a few rows fit together. I don't want to see a hairball graph of my whole database (e.g. SAP printed out their SQL tables UML style and it filled half the wall of a gymnasium) but I do want to see a piece of it I care about as a graph

All the time I want to see a few queries, rows and result sets at the same time but tools like this don't make that easy.

If I do

   select * from some_table

and get one row the columns are stacked horizontally so I can't see them all at once and have to scroll. I'd like to see one row stacked vertically so I can see it all at once and not have to scroll, scroll, scroll.

For extra credit I want a tool that works with document db's (JSON tables in postgres, arangodb, couchdb, etc.) and SPARQL databases.

[poetincode]

Thanks a lot for sharing! I haven't used pgadmin4 but have used DBeaver and IntelliJ's integrated query console in a lightweight sense. So, pardon my ignorance on what's built or not already, but two-way git integration in 2024 sounds like a must-have, and also something like a "Cmd + k" search for fast access to a particular table, or a particular saved query, or a sectional UML diagram, or displaying results in an adaptive layout (row-first vs column-first).

I too agree that this should be the centerpiece design element: "All the time I want to see a few queries, rows and result sets at the same time but tools like this don't make that easy."