Ask HN: RFS: Modern SQL/db editor

[jkcorrea]

tldr: someone PLEASE build a modern SQL editor. I would pay upwards of $20/seat/mo for a good one. strong suspicion many others would too.

-- The problem/rant

I've grown increasingly frustrated with how archaic the modern story for basic database adminning has become. So many aspects of the developer experience have improved dramatically in recent years, but it feels like database tooling is one massive vertical hasn't received much the same TLC.

Do people just not use SQL editors that often? I find myself constantly cmd-tabbing to Postico to check/modify some rows either during development or to resolve prod issues. But the second I need a more advanced/relational filter it's either a lot of painful clicks away or just impossible to do through the table UI and now I have to write a query from scratch.

If it's a commonly recurring task you can save the query, but now I have hundreds of these saved queries all with slightly different names to the point where it's less taxing to just write a new query then hunt down & slightly modify an old one.

Collaboration is non-existant. I'm forced to share these queries via slack or committing to a `misc/*.sql` folder in our repo which feels awkward.

Tools I've tried include Postico, DBeaver, TablePlus, Beekeeper Studio, PopSQL, and various VSCode extensions. I don't need features around DB Ops, I use Neon/Supabase/etc and just hope I never have to think about DB ops. I almost don't care about SDL tasks either, I mainly do that through my ORM (s/o Drizzle)

-- My request

Here's a braindump of features I frequently desire. I would pay for a tool that did even ONE of these, but I think all are very possible and would 100x the value of an editor to me:

    - Intuitive filtering UI. You know my `id` column is a text, why is the default filter operation `>`. I almost never want that for string cols. Let me type "yesterday at 3pm" in a timestamp filter. Let me fuzzy search my entire DB (obv this is hard for large dbs)
    - Relational filters. I should be able to filter by properties on relations. I'm often only given a username when solving a prod issue, and now finding their records in other tables becomes a 2-step process of finding the user's ID then using that in a filter on the table I care about
    - Embedding & formatted columns. I have various reports as custom queries/views that I export as CSVs weekly to give to teammates. I wish I could just embed this view as an iframe in our internal dashboard. If you're feeling generous, allow me to format the columns like Airtable or even make charts based on the view. This could easily become a massive business in its own right.
    - SQL language server/intellisense (h/t https://github.com/supabase-community/postgres_lsp). Need I say more?
    - AI autocompletion & generation (a la Cursor). My current workflow is to cmd+tab to my ORM definition file, ask cursor to come up with a PSQL query for X table for Y problem, then cmd+tab back to Postico to run it.
    - Notebooks. I want to create playbooks to share with my team. Post-mortems, "here's how  I debug XYZ production issue", etc.
    - Omnisearch. Let me CMD+K and fuzzy/semantic search across my saved queries, tables, etc.

I'll be honest, been sitting on this idea for over a year and have tried and failed multiple times to build it myself (skill issue). Throwing this out there in hopes that a more cracked engineer is interested in taking a stab at it. I would immediately pay upwards of $20/mo for even a partial solution and probably more for some of the team related features.

Email in bio if you're interested in taking this up and want to chat more

[yen223]

For collab: check out either Metabase or Apache Superset. I've used Metabase in the past for sharing SQL queries as snippets or as graphs, and I miss it sometimes.

I am currently working on a mobile-first Postgres client. I am convinced that you are right about (desktop) database clients not being as powerful as they should be. Postgres in particular makes a lot of schema information available, but very few database clients make full use of it.

[jkcorrea]

Oh yes I've been trialing Metabase but didnt know about Superset, thank you!

This category of tools definitely scratches a big part of the itch here. But you still end up needing a db client for a long tail of other tasks. So now your db knowledge is spread across 3+ tools: shared queries/charts in Metabase, personal queries in Postico, schema defs and SQL files in your code repo, Notion, etc.

I think you've got an opportunity to consolidate all that into 1 tool in the same way Postman did for APIs

> Postgres in particular makes a lot of schema information available, but very few database clients make full use of it. Completely agree. Also just the industry consolidation around the pg ecosystem in general will lend itself to better tooling potential (e.g. Supabase's LSP project).

> I am currently working on a mobile-first Postgres client. Great that you're working on something new here! If I may ask - why mobile-first? That's not something I've particularly needed tbh (sample size of 1 of course)

[saltcod]

Thanks Jake — these are great.

Couple of quick questions:

— "AI autocompletion & generation...." sort of like what https://postgres.new/ does, but built into the Dashboard? - "Notebooks..." — like a Jupyter notebook kind of thing? We already have SQL Snippets you can share with team members, but you're probably talking about the combination of text and SQL? — cmdk — we've just released a big revision of our menu last week, we should definitely add snippets and tables/views etc. Great idea.

Love to hear anything else you've got in Supabase feedback!

[jkcorrea]

First off, love everything Supabase is doing. Keep it up. A few blunt things off-the-bat:

1) pg.new is neat, but honestly I don't see why I'd use it when I can do the same thing directly inside my drizzle schema dir using Cursor's Composer UI, which has full context on my project. I know not many are using Cursor right now, but it's hard to fathom these kind of features don't become part-and-parcel of code editors soon..

2) I actually find it painful to have to login to Supabase on the web to manage the database. I never use the table editor, snippets, etc. I want a native app I can CMD+Tab to.

Don't mean to be rude, just objective so you can feel my pain as a user.

In terms of the Notebooks, yeah I meant like Jupyter Notebooks. I've experimented with having a shared Notion or markdown files committed to repos in order to

A) save & search for snippets of SQL for the team/future me

B) document the "why" along with each step in a playbook.

The issues with this are

1) its detached from our normal workflow and quickly becomes outdated relative to our schema/business needs

2) to run the queries you have to copypaste back into a SQL tool

3) queries are hardcoded for certain values. If I have a report I run daily, every day I have to go in and manually update the `row.timestamp BETWEEN 'YYYY-MM-DD' AND 'YYYY-MM-DD'`, or if its a customer support workflow I have to replace the customer's ID everywhere. I'd rather have variables at the top I can reference throughout the queries, either as a code block like in Jupyter NB, or maybe some variable UI a la Insomnia/Postman

[petilon]

The reports feature of Visual DB seems to have most of what you are looking for: https://visualdb.com/

It has sophisticated filters and you can share reports with your team (as opposed to exporting CSVs).

[twoquestions]

Have you looked at DataSpell? I haven't used it myself but it looks like it fits at least some of what you need.

https://www.jetbrains.com/dataspell/

[aswerty]

I pay for Jet Brains IDEs but I still use DBeaver over DataGrip. I haven't played around with DataSpell, but does not bode well. Their strength seems to be in programming environments more so than data management tools.

Happy to be schooled though.

[jkcorrea]

looks interesting I'll check it out, thank you!

[kiwicopple]

great list Jake - we're working on a few of these already (and will have an update on the LSP next month)

[jkcorrea]

excited to see what you guys roll out! Supabase is always pushing the DX in this space into the future, so thank you

[slipwalker]

since i have a full jetbrains subscription ( for many years ) i use the DataGrip db client, and it serves me very well... before that ( looong before ) i used AquaDataStudio, and it was very nice too although not cheap at all.