Chion AI turns Postgres questions into answers with the SQL attached
Chion is an AI semantic layer for PostgreSQL. It profiles the tables your team queries into a per-column semantic record analysts edit in Studio, answers plain-English questions with a code-validated read-only SELECT shown beside the chart, and compiles the queries your team saves into SQL skills for Claude Code and Codex. Every question generates a new read-only SELECT, code-validated before it runs, built on a base query your team saved and reviewed in Studio, and printed under the chart.
'%3e%3c/path%3e%3cpath%20d='M20.616%2010.835a14.147%2014.147%200%2001-4.45-3.001%2014.111%2014.111%200%2001-3.678-6.452.503.503%200%2000-.975%200%2014.134%2014.134%200%2001-3.679%206.452%2014.155%2014.155%200%2001-4.45%203.001c-.65.28-1.318.505-2.002.678a.502.502%200%20000%20.975c.684.172%201.35.397%202.002.677a14.147%2014.147%200%20014.45%203.001%2014.112%2014.112%200%20013.679%206.453.502.502%200%2000.975%200c.172-.685.397-1.351.677-2.003a14.145%2014.145%200%20013.001-4.45%2014.113%2014.113%200%20016.453-3.678.503.503%200%20000-.975%2013.245%2013.245%200%2001-2.003-.678z'%20fill='url(%23lobe-icons-gemini-1-_R_0_)'%3e%3c/path%3e%3cpath%20d='M20.616%2010.835a14.147%2014.147%200%2001-4.45-3.001%2014.111%2014.111%200%2001-3.678-6.452.503.503%200%2000-.975%200%2014.134%2014.134%200%2001-3.679%206.452%2014.155%2014.155%200%2001-4.45%203.001c-.65.28-1.318.505-2.002.678a.502.502%200%20000%20.975c.684.172%201.35.397%202.002.677a14.147%2014.147%200%20014.45%203.001%2014.112%2014.112%200%20013.679%206.453.502.502%200%2000.975%200c.172-.685.397-1.351.677-2.003a14.145%2014.145%200%20013.001-4.45%2014.113%2014.113%200%20016.453-3.678.503.503%200%20000-.975%2013.245%2013.245%200%2001-2.003-.678z'%20fill='url(%23lobe-icons-gemini-2-_R_0_)'%3e%3c/path%3e%3cdefs%3e%3clinearGradient%20gradientUnits='userSpaceOnUse'%20id='lobe-icons-gemini-0-_R_0_'%20x1='7'%20x2='11'%20y1='15.5'%20y2='12'%3e%3cstop%20stop-color='%2308B962'%3e%3c/stop%3e%3cstop%20offset='1'%20stop-color='%2308B962'%20stop-opacity='0'%3e%3c/stop%3e%3c/linearGradient%3e%3clinearGradient%20gradientUnits='userSpaceOnUse'%20id='lobe-icons-gemini-1-_R_0_'%20x1='8'%20x2='11.5'%20y1='5.5'%20y2='11'%3e%3cstop%20stop-color='%23F94543'%3e%3c/stop%3e%3cstop%20offset='1'%20stop-color='%23F94543'%20stop-opacity='0'%3e%3c/stop%3e%3c/linearGradient%3e%3clinearGradient%20gradientUnits='userSpaceOnUse'%20id='lobe-icons-gemini-2-_R_0_'%20x1='3.5'%20x2='17.5'%20y1='13.5'%20y2='12'%3e%3cstop%20stop-color='%23FABC12'%3e%3c/stop%3e%3cstop%20offset='.46'%20stop-color='%23FABC12'%20stop-opacity='0'%3e%3c/stop%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e)
Your warehouse stays put. Chion reads it with read only credentials and never moves a row.
Your team asks Postgres in plain English and reads the SELECT behind the chart
The whole loop in one recording: connect Postgres read-only, compile the queries your team saved and reviewed in Studio into skills, ask a question, and read the SELECT under the chart.
Scoped per teamPortable across any LLMOwned by you
The broken analytics loop
Stale dashboards. Disconnected AI. Blocked analysts. Chion closes the loop, from question to chart.
Chion compiles the queries your team saves and reviews into a portable skill library. Run it in Chion Studio, Claude Code, or Codex, with the executed SELECT printed under the chart it produced.
Text-to-SQL tools hallucinate queries against your live database
Staledashboards.
DisconnectedAI.
Blockedanalysts.
Chion is your analytics team compiled from the queries you saved and reviewed: finance, ops, or growth, one role per export. Drop your agent and skills folder into Claude Code or Codex, or ask inside Chion, where each question gets a new SELECT built on a query your team saved and reviewed.
Close the loop: ask your database in plain English →
See how Chion compares: vs BI dashboards · vs text-to-SQL tools
Your saved and reviewed queries already exist.
Chion compiles them into a CHION.md skill bundle, one role per export. Domain-aware, table-scoped, ready for Claude Code or Codex.
Your tables never stream to the model.
The model only sees controlled summaries, counts, samples, and aggregations, not direct table access.
Read-only and encrypted by default.
SELECT-only credentials. AES-256 vault. Your data never moves.
Traceable SQL at every step.
The SELECT is code-validated before execution, then printed under the chart it produced.
Zero migration. Zero pipelines.
Connect to your database and query it where it lives.
Deploy on your terms.
Managed cloud today; dedicated infrastructure on the Enterprise roadmap. Same pipeline, same guarantees, wherever it runs.
Under the hood.
A multi-phase AI pipeline, not a wrapper around another LLM.
See the 13-step code-validated SQL pipeline from schema profiling to grounded narrative.
Connect & Auto Generate Claude Skills
Connects read-only and profiles every column. Queries your team saved and reviewed auto-distill into reusable Claude Skills, tagged by department and role.
PostgreSQLLLMUnderstand the Question
Parses plain-English through 7 discovery strategies. Resolves terms to real columns via vector search.
Reading your question…Searching your semantic catalog…Resolving terms…Generate & Validate SQL
Writes read-only SQL against a governed contract. Lint-checked, budget-enforced, and auto-repaired on failure.
Chart & Narrate
Renders interactive D3.js visualizations with a grounded narrative. Every number traces to the query that produced it.
SELECT region, SUM(revenue) FROM sales GROUP BY region
Read-only SELECT, row-capped, scoped to your role's RLS policies. Two code validators reject anything that is not a read-only SELECT before your database sees it.
We connect with the read-only role you give us. Your data stays in your database. The model receives your table and column names, the rows your query returned for the narrative, and sampled column values.
Encrypted credential vault
Credentials encrypted at rest. Decrypted in-memory only. Never logged.
Read-only by default
SELECT-only permissions. We will never modify or delete your data.
Row-level security honored
Your RLS policies are honored. Every query runs with your connection role's permissions.
Managed cloud today. Dedicated GPU compute and on-premise model hosting are Enterprise roadmap items discussed under contract.
How it works
Four steps from a question to your team's portable AI brain.
Connect Your Data
Point us at your PostgreSQL database. Host, database, username, and read-only credentials.
Semantic Layer
Automatic Discovery
We scan every table, column, and relationship the moment you connect. No manual setup; the system figures out your schema so you don't have to explain it.
Ask a question about your data…
Ask Your Data
Ask a question, get a chart. The SELECT that produced it is code-validated before execution and shown beneath the chart. You read exactly what hit your database.
Generate your real file from Studio. A query you saved and reviewed becomes a skill. Learn more →
Promote a Query, Get a Skill
A query your team reviews and promotes becomes a reusable skill, saved to a personal CHION.md file: one per employee, governed by your database permissions.
Export the bundle. Claude, Codex inherit your team's analytics know-how.
Built by an analyst who got tired of waiting.
Founded in 2025 by Jonathan Dag, former Meta, Twilio, and American Express analyst.Read allJonathan Dag, Founder
After a decade building data infrastructure across Meta, Twilio, American Express, MasterCard, and Bosch, the pattern was always the same: analysts buried in SQL, business users waiting days for a dashboard update, and AI tools hallucinating the answer.
Chion is the analytics layer that should have existed from the start. Ask in plain English, get a code-validated answer backed by real, traceable SQL.
The same standard drives the other product I build, Lensmark, an AI landmark identifier that shows its sources. Photograph a building instead of querying a table, and the answer still has to arrive with the record it came from.
That's the tool I kept wanting someone else to build.
Choose how you deploy your portable SQL skills.
Quick Start
Connect PostgreSQL with host, database, username, and read-only credentials. Ask a question. Get a chart with the SQL behind it.
- Managed cloud, no infrastructure to run
- Add the SQL your team already trusts
- Chat with your queries: charts, insights, SQL underneath
- Export your skills to Claude Code or Codex
Custom Setup
Configure Chion around your stack: your models, your infrastructure, your admin. Same pipeline, same validation.
- Your own models: any cloud or open source model
- Managed cloud today. Dedicated GPU compute and on-premise model hosting are Enterprise roadmap items discussed under contract.
- Your own admin: plans, seats, and access controls your way
Frequently asked questions
Browse the FAQ covering security, pricing, pipeline architecture, and integrations. Everything from how SQL is code-validated to how credits and plans work.
Explore Chion
Solutions
Learn
Last reviewed: September 1, 2026