Set up docs MCPNow that your data is in ClickHouse, it’s time to analyze it, which often involves building visualizations using a BI tool. Many of the popular BI and visualization tools connect to ClickHouse. Some connect to ClickHouse out-of-the-box, while others require a connector to be installed. We have docs for some of the tools, including:
- Apache Superset
- Astrato
- Chartbrew
- Databrain
- Deepnote
- Dot
- Draxlr
- Embeddable
- Explo
- Fabi.ai
- Grafana
- Lightdash
- Looker
- Luzmo
- Metabase
- Mitzu
- Omni
- Querio
- Rill
- Rocket BI
- Splunk
- Tableau
- Holistics BI
ClickHouse Cloud compatibility with data visualization tools
| Tool | Supported via | Tested | Documented | Comment |
|---|---|---|---|---|
| Apache Superset | ClickHouse official connector | ✅ | ✅ | |
| Astrato | Native connector | ✅ | ✅ | Works natively using pushdown SQL (direct query only). |
| AWS QuickSight | MySQL interface | ✅ | ✅ | Works with some limitations, see the documentation for more details |
| Chartbrew | ClickHouse official connector | ✅ | ✅ | |
| Databrain | Native connector | ✅ | ✅ | |
| Deepnote | Native connector | ✅ | ✅ | |
| Dot | Native connector | ✅ | ✅ | |
| Explo | Native connector | ✅ | ✅ | |
| Fabi.ai | Native connector | ✅ | ✅ | |
| Grafana | ClickHouse official connector | ✅ | ✅ | |
| Hashboard | Native connector | ✅ | ✅ | |
| Holistics | Native connector | ✅ | ✅ | |
| Lightdash | Native connector | ✅ | ✅ | |
| Looker | Native connector | ✅ | ✅ | Works with some limitations, see the documentation for more details |
| Looker | MySQL interface | 🚧 | ❌ | |
| Luzmo | ClickHouse official connector | ✅ | ✅ | |
| Looker Studio | MySQL interface | ✅ | ✅ | |
| Metabase | ClickHouse official connector | ✅ | ✅ | |
| Mitzu | Native connector | ✅ | ✅ | |
| Omni | Native connector | ✅ | ✅ | |
| Power BI Desktop | ClickHouse official connector | ✅ | ✅ | Via ODBC, supports direct query mode |
| Power BI service | ClickHouse official connector | ✅ | ✅ | A Microsoft Data Gateway setup is required |
| Querio | Native connector | ✅ | ✅ | |
| Rill | Native connector | ✅ | ✅ | |
| Rocket BI | Native connector | ✅ | ❌ | |
| Tableau Desktop | ClickHouse official connector | ✅ | ✅ | |
| Tableau Online | MySQL interface | ✅ | ✅ | Works with some limitations, see the documentation for more details |