Ask HN: RFS: Modern SQL/db editor

11 points

2 years ago

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

15 comments

- 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.