Defog.ai
Defog.ai is an enterprise text to SQL analyst built on its own SQLCoder models: teams align it to their schema with instructions and golden queries, ask questions in the app, Slack or an API, and can run it on their own infrastructure.
Defog.ai turns plain language questions into SQL for BigQuery, Databricks, MySQL, Postgres, Redshift, Snowflake, SQLite and SQL Server, and returns the SQL alongside tables and charts. It is built on SQLCoder, the family of text to SQL models Defog open sourced from 2023, and Defog also published SQLEval, an open source framework for evaluating generated SQL.
Admins align Defog to their data with written instructions on business rules and golden queries, pairs of questions and verified SQL. Users rate answers, a feedback page collects the results, and an Improve using Feedback feature proposes new instructions from negative feedback. Questions can be asked in the Defog app, in Slack or through an API that carries conversation context. Admin and general user roles separate who can align the model from who can only query, and SSO is available to enterprise customers.
Defog is sold as a cloud hosted Enterprise plan at $5,000 a month or a self hosted Enterprise plan on an annual commitment, deployed as three Docker images with a vLLM model service inside the customer's infrastructure. Defog announced SOC 2 Type II compliance in October 2023. The site footer reads 2024 and the most recent blog post is dated 30 January 2024.
Vendor details
Canonical URL
https://defog.ai
Category
Data analyst agent
Company status
independent
Use cases & customers
Integrations
Defog connects to BigQuery, Databricks, MySQL, Postgres, Redshift, Snowflake, SQLite and SQL Server, accepts CSV uploads, integrates with Slack and offers a query API (generate_query_chat).
In practice
A regulated enterprise runs Defog's Docker images on its own servers, aligns it with instructions and golden queries for its schema, and lets analysts ask questions while data stays inside its network.
A software team calls Defog's query API from its own product to turn a customer's question into SQL, passing previous context so follow up questions work.
A data lead reviews the feedback page each week, turns good answers into golden queries and uses Improve using Feedback to draft instructions that fix the answers users marked wrong.
Agentic Index coverage score
7.5 / 14 capabilities · 54%
| Integrations & Tool Calling | Partial |
|---|---|
|
Defog generates SQL for BigQuery, Databricks, MySQL, Postgres, Redshift, Snowflake, SQLite and SQL Server, accepts CSV uploads and has a Slack integration. The connectors are databases and a chat surface, and no action in other systems or custom tool is documented. SourceDefog, docs.defog.ai API Access, Setting Up Your Database and Slack Integration pages and homepageread 2026-09-28 |
|
| Workflow Orchestration | Partial |
|
Defog Agents were launched in October 2023 to handle multi step workflows in SQL, Python and R with a person in the loop, and the current docs cover question to SQL querying. No branching, conditions, multiple agents or flow the buyer configures is documented. SourceDefog, blog post of 5 October 2023 and docs.defog.ai Querying Your Data; defog.ai/blogread 2026-09-28 |
|
| Knowledge Grounding & RAG | Partial |
|
Admins align Defog with schema metadata, written instructions on business rules and golden queries (question and SQL pairs), stored in the backend, which builds the prompts sent to the model. No retrieval over them or scale past the prompt is described. SourceDefog, docs.defog.ai Aligning Defog To Your Usecase and On Premise Architecture pagesread 2026-09-28 |
|
| Human Oversight & Guardrails | Partial |
|
Only admins may align the model and manage the database while general users can only query, admins set the business rule instructions the agent follows, and golden queries are refined by a person before saving; the 2023 agents launch describes a person in the loop. No approval step before a query runs is documented. SourceDefog, docs.defog.ai Managing Users and Aligning pages and blog post of 5 October 2023read 2026-09-28 |
|
| Security, Identity & Governance | Full |
|
Defog documents admin and general user roles and SSO for enterprise customers, and announced SOC 2 Type II compliance on 6 October 2023. No auditor is named and no later attestation date is published. SourceDefog, docs.defog.ai Managing Users page, Pricing page and blog post of 6 October 2023; defog.ai/blog/soc-2-type-iiread 2026-09-28 |
|
| Observability & Auditability | Partial |
|
Users see the SQL behind each answer alongside tables and charts, and a feedback page lists the queries users marked right or wrong with their comments. No audit log, per query history for admins or trace export is documented. SourceDefog, homepage and docs.defog.ai Aligning pageread 2026-09-28 |
|
| Memory & State Persistence | Partial |
|
The query API carries previous context through a conversation, and feedback turns into golden queries and instructions, which ground later answers. No memory the agent keeps across sessions with a stated scope and lifetime is described. SourceDefog, docs.defog.ai API Access and Aligning pagesread 2026-09-28 |
|
| Deployment & Data Residency | Full |
|
A self hosted Enterprise plan runs on the customer's own infrastructure, and the docs describe an on premise deployment of three Docker images, including a vLLM model service, with users, metadata and golden queries kept in the customer's Postgres. SourceDefog, Pricing page and docs.defog.ai On Premise Architecture and Docker Deployment pagesread 2026-09-28 |
|
| Prebuilt Agents, Templates & Packs | Not documented |
|
No prebuilt agents, templates or packs are offered; the customer aligns Defog to its own schema with instructions and golden queries. SourceDefog, docs.defog.ai and homepageread 2026-09-28 |
|
| Triggers & Channel Coverage | Partial |
|
The buyer's own users ask questions in the Defog app, in Slack or through the API. Those all start with a person, no schedules, alerts, events or channel for the buyer's customers is documented, and no embedded widget appears on the vendor's pages. SourceDefog, docs.defog.ai Slack Integration and API Access pagesread 2026-09-28 |
|
| Model Flexibility & Routing | Not documented |
|
Defog runs its own SQLCoder models (a vLLM service in the on premise build), and no third party model or customer selection of a provider is documented. SourceDefog, homepage and docs.defog.ai On Premise Architecture page; defog.airead 2026-09-28 |
|
| APIs, SDKs & MCP Extensibility | Full |
|
A documented API (POST api.defog.ai/generate_query_chat with an API key) returns SQL for a natural language question against a named database type, carrying previous conversation context. SourceDefog, docs.defog.ai API Access pageread 2026-09-28 |
|
| Testing, Debugging & Optimization | Full |
|
In the product, users rate each answer and a feedback page collects the results, and Improve using Feedback proposes new instructions from negative feedback while good answers become golden queries, an improvement loop on the deployed analyst. SQLEval, Defog's open source framework, benchmarks Defog's own models rather than the customer's deployment. SourceDefog, docs.defog.ai Aligning Defog To Your Usecase pageread 2026-09-28 |
|
| Browser & Computer Use | Not documented |
|
No browser, desktop or computer control is described; Defog works through database connections and SQL. SourceDefog, homepage and docs.defog.ai; defog.airead 2026-09-28 |
|
The Agentic Index coverage score grades every vendor Full, Partial or Not documented against the same 14 buyer facing capabilities, from public evidence only. Each capability links to how all vendors in the index score on it. How this evidence is graded
Pricing
Enterprise (cloud hosted) $5,000 per month; self hosted on annual commitment
per month (cloud hosted); annual commitment (self hosted)
What is public
Defog publishes the cloud hosted Enterprise price; the self hosted plan's price is not published.
Variable cost rationale
A flat monthly fee for the cloud plan and an annual commitment for self hosting; no usage metering is published.
Sales call required
Yes, required for paid access
Free / trial
Not published
Lowest paid plan
Enterprise, cloud hosted ($5,000 per month)
Related vendors
- Actian AI Analyst — Wobby, now sold as Actian AI Analyst, answers plain language…
- AnswerRocket — Enterprise AI agent platform for analytics built around Max, which…
- AskEarth — Geospatial intelligence agent (GIA) that answers plain language…
- AskYourDatabase — AskYourDatabase is a conversational data analyst that turns plain…
- Athenic AI — Athenic AI is a data analyst agent that connects databases,…
- BlazeSQL — BlazeSQL is an AI data analyst that turns plain English into SQL…
Alternatives to Defog.ai
The closest documented capability profiles to Defog.ai among data analyst agents tracked by Agentic Index, ordered by similarity on the same 14 point evidence the rankings use. No vendor pays for placement.
- BlazeSQL9.0 / 14Fuller documented coverage on Integrations & Tool Calling and Knowledge Grounding & RAG
- Querio9.0 / 14Adds documented Prebuilt Agents, Templates & Packs
- AskYourDatabase7.5 / 14Adds documented Model Flexibility & Routing
- Brewit6.5 / 14Fuller documented coverage on Knowledge Grounding & RAG and Triggers & Channel Coverage
- Powerdrill8.0 / 14Adds documented Prebuilt Agents, Templates & Packs
- Actian AI Analyst9.5 / 14Adds documented Prebuilt Agents, Templates & Packs and Model Flexibility & Routing
Similarity is computed from each vendor's Agentic Index coverage score evidence, axis by axis, not from the totals. How this evidence is graded