How Modal gave non-data teams self-serve analytics with Hex agents
Serverless compute company Modal connected its warehouses to Hex and let staff ask data questions through Hex's agents, including from Slack. Hex reports faster analysis and wider use beyond the data team.
The problem
Staff had the technical skills to query data. But setting up notebooks and validating outputs discouraged quick ad hoc questions, which mattered more as the company grew.
How they did it
- Connected two warehouses (Snowflake and ClickHouse) in one Hex workspace.
- Configured the agent with less than 50 lines of context, using endorsed dbt models and workspace rules.
- Enabled the Slack integration so people can ask @Hex questions directly.
- Used Context Studio to monitor agent usage and keep answers accurate.
Results as reported by Hex
- Hex reports multi-day analysis compressed to under 24 hours (75% faster).
- 1,300 AI agent messages across Notebook Agent and Threads. 53% of Threads conversations started from Slack.
- 6 cross-functional teams use Hex independently.
- Hex says Modal unlocked $100M+ in pipeline by using the agent to build targeted outreach to 15 AI labs. These had Modal accounts but no usage.
These figures are as reported by Hex in Hex customer story ↗. Hex sells the product used here. AgentGid did not measure or independently verify them.
This suits a team that already has a warehouse and dbt models, plus someone who can curate the endorsed models and rules the agent relies on. Watch the cost: full agent access starts on Professional at $36 per editor a month, AI usage draws on per-seat credits, and the speedup and $100M+ pipeline figures are Hex's own reports. PandasAI (Free, open source) is a cheaper alternative if you can build the Slack layer yourself.
The agent used here
Similar use cases
Cyera rolled out Claude Cowork to 1,500 employees and reached 88% weekly use
Cyera, an AI security company, gave its non-engineering staff Claude Cowork after most of them stalled at the command line with Claude Code. It mapped data access first, connected…
Weekly active usage of Claude reached 88% across roughly 1,500 employees, including new hires, as reported by Anthropic.
Supermetrics' Claude connector cut an agency's 10-hour reports to 20 minutes
Supermetrics, which moves marketing data for more than 200,000 businesses, built a Claude connector on its MCP server so marketers can ask Claude Cowork about live ad and analytic…
Active users of Supermetrics' Claude connector grew 250% month over month on average since its February launch, as reported by Anthropic.
Montgomery County Food Bank cut overtime from 99 to 11 hours with Claude
Montgomery County Food Bank in Texas runs with a staff of 46 and gives about 14 of them paid Claude seats. The team uses Claude to analyze driver shifts, compare a partner agency'…
Biweekly driver and warehouse associate overtime fell from 99 hours to 11 after Claude helped analyze shifts and delivery requirements, as reported b…