← All projectsIntermediate · About 8–12 hours
Natural-language to SQL assistant
Ask business questions in plain English and get a safe, explained SQL query and a chart.
Good for: Data analyst, Data scientist, AI engineer
What you will have at the endAn app that turns questions into read-only SQL on a sample database, shows the query, runs it and charts the result.
- Schema prompting
- Structured output
- SQL safety
- Evaluation on known questions
New to this? Do the toolkit setup first, then add these one at a time.
- 1
Sample data to query.
$ uv add duckdb
# or reuse the pgvector Postgres container
- 2
- 3
How to show it to an employer
1Demo GIF
2README with your safety rules and accuracy table
3Three failures and why they happen
Stretch goals
Self-correction: retry once with the database error
A semantic layer of metric definitions
Run it on Fabric or Databricks SQL
Questions this prepares you for
How do you stop generated SQL from doing damage?
How do you give the model the schema without blowing the context window?
How would you evaluate it?
Practise them in a mock interview