Show HN: Dbctx – Compile a PostgreSQL database into compact, queryable context

Dbctx, a new open-source tool, compiles a PostgreSQL database into a compact, queryable context file (.dtx) that helps LLMs generate accurate SQL queries by including expected value sets and JSONB paths. The tool, available as a CLI, library, and UI in a single Go binary, filters schema to only relevant tables for a given natural language query, improving LLM response quality.

Hi HN, I've been finding increasing need for helping our users chat with the underlying application data in postgresql directly using LLMs, visualize results and so on. A major obstacle to this is -- traditional sql schema doesn't contain enough information for an LLM to easily query things in one shot. For example, traditional schema doesn't say what is the expected/allowed value set in a state field, or what are the paths available embedded in a jsonb field. Also -- given a user query -- only a small fraction of the whole schema is relevant for an LLM to construct SQL queries. So filtering parts of schema relevant to construct a prompt is important. dbctx solves all these by inspecting a postgresql database and turning the results into an sqlite backed ".dtx" file. You can pass your natural language query to dtx, and get relevant tables in a compressed schema format along with field/json intelligence embedded in it. This leads to much better responses from the LLM from the getgo. I have a CLI, library and tiny UI embedded in a single go binary. Do give it a go, and any feedback welcome. Comments URL: https://news.ycombinator.com/item?id=49258397 https://news.ycombinator.com/item?id=49258397 Points: 3 Comments: 0