Re:Postgres.new: In-browser Postgres with an AI interface
by kolbe on Monday August 12, 2024 @01:03PM
(#41226725)
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.
[ Parent
| on HN ]
Re:Postgres.new: In-browser Postgres with an AI interface
by breadwinner on Monday August 12, 2024 @02:57PM
(#41228046)
If you want to use an LLM to type queries in English, Visual DB can do it: https://visualdb.com/
Re:Postgres.new: In-browser Postgres with an AI interface
by Kiro on Monday August 12, 2024 @02:22PM
(#41227656)
I 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.
Re:Postgres.new: In-browser Postgres with an AI interface
by gregnr on Monday August 12, 2024 @01:38PM
(#41227158)
Another 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.
Re:Postgres.new: In-browser Postgres with an AI interface
by kolbe on Monday August 12, 2024 @02:00PM
(#41227422)
Mine 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
Re:Postgres.new: In-browser Postgres with an AI interface
by TechDebtDevin on Monday August 12, 2024 @01:29PM
(#41227069)
I'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.
Re:Postgres.new: In-browser Postgres with an AI interface
by Kiro on Monday August 12, 2024 @02:23PM
(#41227669)
I presume you've done your competitor analysis because it's a really crowded space.
Re:Postgres.new: In-browser Postgres with an AI interface
by thruway516 on Monday August 12, 2024 @04:13PM
(#41228790)
Apparently 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...
Re:Postgres.new: In-browser Postgres with an AI interface
by TechDebtDevin on Monday August 12, 2024 @02:49PM
(#41227949)
Well 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.
Re:Postgres.new: In-browser Postgres with an AI interface
by Kiro on Tuesday August 13, 2024 @12:57AM
(#41232399)
I 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?