Custom integrations
Generate SQL from a question
Register a database, ask in plain language, and get a SQL statement grounded in the schema you registered — for a human to read before anything runs.
What you'll learn
- What SQL generation does today, and what it does not do
- How to ground generation in your schema
- How to give an agent live database access instead
What this does today
Dezifi turns a natural-language question into a SQL statement, grounded in the schema and the read-only intent you registered with the data source. The statement is returned for review; Dezifi does not connect to your database and does not run it. Nothing is executed, so there is no result set, no row cap, and no query cost.
To give an agent live database access
Use the database MCP integrations — PostgreSQL, MySQL and Snowflake are agent-callable today, with credentials, per-action scoping and the same audit trail as any other tool. That is a different mechanism from this page: those connectors execute, this one drafts.
How generation is grounded
- 1
Register the data source
Create the data source with its engine type, the schema you want generation grounded in, and whether the intent is read-only. - 2
Ask a question
Post the question to the data source. The model drafts a statement using only the schema you supplied — it has no other view of your database. - 3
Review before running
The statement comes back with the question that produced it, and the request is written to the audit log. Running it is yours to do, in whatever client you already trust.
Frequently asked questions
- Does Dezifi connect to my database?
- Not for SQL generation. It works from the schema you register, drafts a statement, and returns it. To let an agent actually query a database, use the PostgreSQL, MySQL or Snowflake MCP integrations.
- Can an agent call this in a conversation?
- Not today. SQL generation is available through the platform API for a person or an application to call. Agent-callable database access is the MCP database integrations.
- Is the generated SQL guaranteed to be correct or safe to run?
- No. It is a draft grounded in the schema you gave it, which is exactly why it is returned for review rather than executed. Treat it as a starting point, and run it with a database user scoped to what you intend to allow.
- Is anything recorded?
- The question, the generated statement and who asked are written to the audit log. No row data is involved, because no query runs.