r/PostgreSQL
Natural language querying on top of PG for non tech users
- upvotes
- 0
- comments
- 17
Post
Highlighted: the lines this signal was extracted from
Building an app for the operations team that runs on Postgres. Business side wants to query in plain English without writing sql. Our table metadata is not rich. Tried a couple of options so far. Setup syncs our Postgres tables into Databricks and then using Genie agents to generates sql on the fly. Works well for straightforward questions but gets shaky on anything that needs multiple business logic that isn’t obvious from column names. Custom option using text2sql with Langchain, which gives better control but is a lot more to build and maintain. And we will eventually move all workloads to cloud. What’s better in practice? How to deal with the metadata gap? A colleague keeps talking about Metabase for this kind of self service. Is it worth considering?