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.

The GPT knows to look at early behavioral markers when I ask about activation, and helps me measure what's happening when I spot a retention cliff. It writes the SQL and formats results for our visualization tools.