Lightdash vs Hex
Side-by-side trajectory, velocity, and editorial themes.
Lightdash is turning the analyst's prompt into the primary way to build BI
Lightdash is pushing hard on AI-native BI. Its data apps now generate reusable chart types from a plain-language prompt, verified content has gone GA and merged with the AI-agent and MCP layer, and AI-written summaries are appearing in scheduled deliveries. Alongside that, steady core work continues on SQL parameters, chart layouts, and enterprise controls like user impersonation.
The clear direction is a prompt-driven analytics surface backed by a trusted-content layer that external agents like Claude and Cursor can query through MCP. Expect the 'describe it and Lightdash builds it' pattern to spread from chart types into more of the modeling and dashboard workflow, with verification as the guardrail that keeps agent answers trustworthy.
The next moves likely push prompt-to-artifact generation deeper into dashboards and the semantic model, and expand what the MCP and verified-content layer exposes to external agents.
Hex is remaking its notebook into an agent that both uses and plugs into MCP
Hex is converting its analytics notebook into an AI agent platform. It now runs as an MCP client, is invocable from Codex, and ships generative data apps built from prompts, while keeping its model roster current with Kimi K2.7 and Fable 5 and giving admins default-model and branding controls. Integration and governance work — a Figma connector, AWS IAM-role support, signed embedding — rounds out the core.
The arc points at Hex as connective agent infrastructure: consuming external context and tools via MCP, distributing itself into other agent surfaces like Codex, and letting analysts assemble apps and dashboards from prompts. Expect the agent, rather than the notebook grid, to become the primary interface, with model choice and governance layered on top.
Likely next steps deepen the agent's tool-use over MCP connections and push generative apps further toward production embedding and governance controls.
See more alternatives to Lightdash →
See more alternatives to Hex →