4 ms·
Basic question. Is there a service out there where I can easily link my database to an LLM to do this exact same type of analysis, except on one of my own Postg
by kolbe 2y ago
Basic question. Is there a service out there where I can easily link my database to an LLM to do this exact same type of analysis, except on one of my own Postgres DBs instead of one backed by PGlite? My org has several non-technical people who would greatly benefit from being able to interact with our DB via an LLM, rather than SQL 101 queries. The PostgreSQL Explorer extension on VS Code helps some, but doesn't quite make it as seamless at this.
- TechDebtDevin 2y agoI'm in the middle of building something like this but it's not ready yet. You'll just provide an openAI/anthropic api key and connection details to the db/schema. I intend for it to work a lot like postgres.new but with regular postgres instances.
- Kiro 2y agoI presume you've done your competitor analysis because it's a really crowded space. https://news.ycombinator.com/item?id=41227656 https://news.ycombinator.com/item?id=41227656
- TechDebtDevin 2y agoWell this is the second time Supabase has had a product announcement very similar to mine. My implentation is more focused on data analysis and visualization via a natural language interface.However, the straighforward database operations that postgres.new tries to tackle are included.
- Kiro 2y agoI was mainly referring to the plethora of other services doing exactly that: analysis and visualization via natural language. Supabase is different since they are doing it locally in the browser but just regular text-to-SQL is one of the most common applications of LLMs. How will you differentiate yourself from the rest of the "chat with your database" services?
- thruway516 2y agoApparently it's already so common, it's become a pedagogical task for learning to code with Llms : https://aws.amazon.com/blogs/machine-learning/build-a-robust-text-to-sql-solution-generating-complex-queries-self-correcting-and-querying-diverse-data-sources/ https://aws.amazon.com/blogs/machine-learning/build-a-robust...
- gregnr 2y agoAnother possibility might be to export the database (or a subset of it) to be loaded in a more ephemeral environment like PGlite so that you don't have to worry about non technical users running inefficient/unindexed queries taking down the prod DB.
- kolbe 2y agoMine has been a little bit more along the lines of helping them understand how everything is linked. They can't really even understand the power of JOIN, which greatly reduces the power of what I set up. Basically, I'm sort of stuck in a place where I built something that's too powerful for them to use, and I can see an LLM finally bridging that gap
- Kiro 2y agoI don't know enough to endorse a specific one but there are probably hundreds of services doing text-to-SQL using LLMs. "Chat with your database" is one of the most popular products in the space.
- breadwinner 2y agoIf you want to use an LLM to type queries in English, Visual DB can do it: https://visualdb.com/ https://visualdb.com/