Building a Custom BI GPT

I taught a GPT to understand our data model and write one-shot SQL queries from natural language questions.
Custom GPTClickhouse SQLGrafana
What was built
A custom GPT that translates questions into SQL that follow exact conventions, include validation checks, and format data the way our visualization tools expect.
Rather than building another BI dashboard, this creates a conversational interface where I can ask business questions in natural language and get back precise SQL queries that work with our existing tools.
features_analysis.sql
>Return a query counting accounts that integrated each feature vs. those that churned within 30 days
⏵⏵ sql-gpt ready(click Execute to begin)
I taught the GPT our business logic and tracking stack, not just table schemas. Every query includes validation checks so I know the data is reliable.
When I ask about activation, it knows to look at early behavioral markers. When I spot a retention cliff, it helps me measure exactly what's happening. The GPT writes the SQL and formats results for our visualization tools.