Ask your Postgres database a plain-English question, get code-validated SQL and a chart
Watch Chion connect to a live PostgreSQL database with read-only credentials, profile every table automatically, and turn one plain-English question into SELECT-only SQL you can read line by line. The query stays visible under the chart, so every number is auditable.
Chion lets you ask in plain English and read the code-validated SELECT that produced the chart: no template to build, no SQL to write.
Problem. Most text-to-SQL demos hide the schema-discovery step. What Chion does. Chion connecting to PostgreSQL, reading the schema, and answering a plain-English question with a code-validated SELECT and a chart. Unlike the build-it-yourself templates and tutorials, this is a finished product: the SQL runs read-only and stays visible, with nothing to host.
Published ·46s
Want a walkthrough on your own schema?
A 46-second recording: one English question, one auditable SQL query
Reads your schema automatically: no manual table mapping
Chion connects to a PostgreSQL fixture database and classifies every table, column, and relationship on its own: dates, metrics, categories, foreign keys. No manual table mapping, no pre-recording, no fakes; the pipeline you see is the production pipeline.
Generates SELECT-only SQL, checked in code before execution
All generated SQL is restricted to SELECT statements with LIMIT enforcement at the validator layer. INSERT, UPDATE, DELETE, and DDL operations are blocked in code, not by LLM instruction. The two-layer validator runs before any query touches your database. Read-only SELECT. Credentials in an AES-256-GCM vault. Results capped at 1,000 rows. Each executed query leaves an audit row, written fire-and-forget so a logging failure never blocks your answer.
Keeps the SQL visible under the chart, so every number is auditable
The executed SELECT is rendered below the chart on every render. Every aggregation, join, and filter is inspectable; copy the query into psql and reproduce the chart yourself.
Read transcript
Recorded Apr 9, 2026. The page copy above carries the current product vocabulary.
00:00Step 1, Connect Your Data. Point Chion at your PostgreSQL database and supply read-only credentials. Setup is six connection fields and no infrastructure changes on your end.
00:10Step 2, Automatic Discovery. Chion scans every table, column, and relationship in your schema. It classifies each field (dates, metrics, categories, foreign keys) and assembles a semantic catalog of your data automatically.
00:21Step 3, Ask Your Data. Ask any analytical question in plain English. Chion drafts a verified SELECT query, runs it read-only against your database, and renders the result as an interactive D3 chart with the underlying SQL displayed beneath it.
00:36The SQL is always visible, always auditable. Every number you see on the chart traces back to a query you can copy and execute in psql yourself. That auditability is the entire point: business intelligence engineering teams can verify, not a black box.
Frequently asked questions
Common questions about Chion demos and the underlying product.
How is Chion different from other text-to-SQL tools?
Chion enforces three invariants most SQL chatbots skip: every query is read-only SELECT (no writes), every query passes a two-layer validator before execution, and credentials are stored in an AES-256-GCM encrypted vault, never cached in application memory.
Can I use Chion Skills inside Claude Code or Codex?
Yes. The compiled bundle is plain Markdown, and you keep the artifact. Each of those runtimes reads it from its own path and needs its own database connection, so the file travels while discovery and execution stay runtime-specific.
What databases are supported today?
PostgreSQL is the production target. The demos use PostgreSQL 14 fixture databases. MySQL, BigQuery, and Snowflake are on the roadmap.
Does Chion ever write to my database?
No. All generated SQL is SELECT-only with LIMIT enforcement at the validator layer. INSERT, UPDATE, DELETE, and DDL are blocked in code, not by LLM instruction.
Can I run a demo on my own schema?
Yes. Connect your PostgreSQL database with read-only credentials and start asking questions. The trial is 7 days.