What is Dex?
Dex is an AI data analytics platform that converts plain English questions into SQL queries against company databases. Users connect their existing database, type a question like “Why did revenue dip last week?”, and Dex generates the SQL, runs it, and returns results as charts, tables, and written analysis. It gives non-technical team members direct access to business data without relying on engineers or BI tools. Dex supports PostgreSQL, Snowflake, BigQuery, and MySQL.
Features & Benefits
- Natural language to SQL – Ask questions in plain English and receive auto-generated, optimized SQL queries including SELECT, JOIN, WHERE, and GROUP BY operations.
- Schema mapping – Automatically parse database schema structure to map natural language intent to the correct tables and fields.
- Visual data output – View query results as tables, graphs, and charts with contextual explanations of trends and patterns.
- Trend and root cause analysis – Go beyond raw numbers with AI-generated explanations of anomalies, dips, and performance changes.
- Export options – Export query results and visualizations to CSV and PNG formats.
- Multi-database support – Connect to PostgreSQL, Snowflake, MySQL and other sources using encrypted credentials with SSL/TLS verification.
- Slack integration – Ask data questions and receive AI data analytics responses directly within Slack workflows.
- Role-based permissions – Control who can access specific data and queries across the organization.
- Zero data storage – Process query results in real-time without storing database records or using data for AI model training.
- End-to-end encryption – Secure all data in transit and at rest using AES-256 encryption.
Real-World Applications
Startup founders and operators may use Dex to answer time-sensitive business questions without waiting for engineering support. A founder tracking weekly revenue can type a question and get a breakdown by product, channel, or time period in seconds. This kind of AI data analytics access can replace the cycle of filing tickets, waiting for dashboard builds, and interpreting results days after the data was relevant.
Marketing teams can query campaign performance across channels to identify which sources drive the most revenue or conversions. Instead of requesting a custom report, a marketing manager might ask Dex which ad channel had the highest return last quarter and receive a visual comparison immediately. This helps teams adjust spend while the data is still actionable.
Sales and customer success teams may use Dex to monitor churn, deal size, and pipeline metrics on demand. Questions like “How many customers churned this month?” or “What’s the average deal size for enterprise clients?” can return answers without needing SQL skills or analyst involvement. Dex can surface these AI data analytics insights in Slack, keeping answers inside the tools teams already use daily.
Product managers can explore feature usage data to understand which parts of a product get the most engagement from different user segments. Rather than building a one-off dashboard, a PM might ask which features power users interact with most and receive a ranked breakdown. This type of self-serve AI data analytics access reduces bottlenecks between product, engineering, and data teams.
