Excel + AI for ClickHouse
Give your ClickHouse a semantic layer
ClickHouse is fast. But your business users can't query it — and no cloud vendor will ever bring a semantic layer or an Excel add-in to it. XLTable does: native Excel PivotTables over XMLA and an AI chat interface, live on your ClickHouse, with one governed set of metrics.
What you get
- • Native PivotTables with drill-down, hierarchies, and time intelligence — no SQL for users.
- • AI questions in plain language via MCP — including locally hosted models for air-gapped environments.
- • Live pushdown: queries run on ClickHouse, data never moves.
- • Row- and member-level access control, LDAP / AD.
Also works with StarRocks, Trino, and Greenplum.
Proven in production
Retail chain Lenta runs self-service analytics for ~80 concurrent users on ClickHouse with XLTable — deployed in a single working day.
Read the Lenta case study →