Tool overview
Defog is listed under Data Analytics AI tools.
What is Defog?
Defog provides a natural-language data analyst for databases, files, and connected business systems. It generates and executes SQL, visualizes results, supports feedback and custom analysis tools, and can run in Defog Cloud, Docker, desktop, or fully on-premises environments.
Best for
Data teams deploying privacy-first natural-language analysis over structured data
Who is it for?
Decision note
Rebuilt from the original export under V412/V411 independent factual verification. Preview only; Apply requires Failures = 0, Warnings = 0, Unmapped = 0, Missing = 0, reviewed explicit clears, image import disabled or V380 PASS, representative edit-screen comparison, and a zero-change post-Apply Preview.
Key features
Natural-language querying with generated SQL
Desktop, Docker, cloud, and on-premises deployment
REST API and Python client
Open-source SQLCoder models and evaluation framework
Use cases
Explore enterprise databases without manual SQL
Build embedded analytics assistants
Analyze CSV and Excel files
Deploy private text-to-SQL inside the firewall
Pros
- Free key includes up to 1,000 monthly queries
- Supports fully local and on-premises operation
- Open-source SQLCoder models are available
Limitations
The free key is limited to five tables, twenty-five total columns, and one thousand queries per month.
On-premises performance depends on GPU capacity, database metadata, model configuration, and governance around generated SQL.
Pricing details
Billing options
Pricing note
The free key supports up to five tables, twenty-five columns, and 1,000 monthly queries. Enterprise Cloud is $5,000 per month; self-hosted Enterprise requires an annual commitment and custom quote.
Supported languages
- English
Integrations
Snowflake
PostgreSQL
SQL Server
MySQL
BigQuery
Databricks
Redshift
CSV and Excel
Please log in to join the discussion.