Back to vendors
D

Defog.ai

Visit site
Entry priceEnterprise (cloud hosted) $5,000 per month; self hosted on annual commitmentFull pricing detail

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)

Agentic Index verified 2026-09-28

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

Contact us

Found a vendor we missed? Have feedback on the index? We'd love to hear from you.