A chat-with-your-database app lets people ask questions in plain English and gets answers by having a language model write and run database queries.
In plain words
The model first looks at which tables exist and reads the layout of the ones that matter. It then writes a SQL query, checks it for common mistakes, runs it, fixes errors the database reports, and turns the result into an answer. Because a model is running queries on real data, the database account should be limited to only what the app truly needs.
A quick example
Imagine a shop's sales database. A manager types "Which five products sold most last month?" The app finds the orders table, writes a query that groups and counts sales, runs it with a read-only account, and replies with the list.
Where you'll meet it
- Letting non-programmers explore business data.
- Internal analytics tools and dashboards.
Related
Sources
- DocsBuild a SQL agent, LangChain docs · read 29 Sept 2026
- DocsFunction calling, OpenAI API docs · read 29 Sept 2026
Checked by WhatIsAI against the sources above · 29 Sept 2026. Spotted an error? Report it.