> ## Documentation Index
> Fetch the complete documentation index at: https://zite.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Analyze data at scale with ClickHouse

> Search through massive data in ClickHouse with custom dashboards and reports in your Zite app.

## How it works

Query large datasets and build analytics dashboards directly on your Zite app with ClickHouse. Your app can both read data from ClickHouse and send data to it. By connecting ClickHouse, you can:

* Display data from in charts, tables, and dashboards
* Filter and search large datasets in ClickHouse quickly
* Show summaries, trends, and key metrics
* Build custom reports and data views displayed in your Zite app
* Send existing and new data from your Zite app to ClickHouse

You can start with a ClickHouse database that already has data or a blank one that you gradually fill with data from Zite. Over time, ClickHouse can accumulate large amounts of data that your app can query for heavy analytics, such as analyzing trends over years or breaking down millions of records.

## How to analyze data

<Steps>
  <Step title="Connect to ClickHouse">
    In the chat box, request your app to be integrated with ClickHouse or click the `plug icon` <Icon icon="plug" /> on the top right.

    <Frame>
      <img src="https://mintcdn.com/zite/CV9a9BjpBj1wREn7/images/image.png?fit=max&auto=format&n=CV9a9BjpBj1wREn7&q=85&s=d58a93ce02623930d59d84cc2baad17e" alt="Image" width="1374" height="172" data-path="images/image.png" />
    </Frame>

    Alternatively, you can click the `plus icon` **+** in the chat box to connect.

    Then, enter your **HTTPS endpoint**, **username**, and **password**.

    <Frame>
      <img src="https://mintcdn.com/zite/y9cYynYdIPMALIzj/images/clickhouse-details-1.png?fit=max&auto=format&n=y9cYynYdIPMALIzj&q=85&s=b92ad26a3ff1039db5a4db97e3deea0d" alt="Clickhouse Details 1" title="Clickhouse Details 1" style={{ width:"65%" }} width="1070" height="853" data-path="images/clickhouse-details-1.png" />
    </Frame>
  </Step>

  <Step title="Enter use case">
    Tell Zite how you want to use ClickHouse in your app. For example, our Citizen Request Manager collects requests, while an existing ClickHouse table logs requests from another source. Let's display a dashboard combining data from both.

    <Frame>
      <img src="https://mintcdn.com/zite/UVFcy4TH5yqtMCN9/images/Screenshot-2026-09-09-at-5.41.36-PM-1.png?fit=max&auto=format&n=UVFcy4TH5yqtMCN9&q=85&s=807bc759e5e1fa076fdf8ec6f05994a2" alt="Screenshot 2026 09 09 At 5 41 36 PM" width="2880" height="1617" data-path="images/Screenshot-2026-09-09-at-5.41.36-PM-1.png" />
    </Frame>
  </Step>

  <Step title="Deploy and share">
    That's it! Now we have a dashboard combining data from both.

    <Frame>
      <img src="https://mintcdn.com/zite/UVFcy4TH5yqtMCN9/images/Screenshot-2026-09-09-at-5.45.12-PM.png?fit=max&auto=format&n=UVFcy4TH5yqtMCN9&q=85&s=f555d48435fcc684efab61da10e65265" alt="Screenshot 2026 09 09 At 5 45 12 PM" width="2174" height="1590" data-path="images/Screenshot-2026-09-09-at-5.45.12-PM.png" />
    </Frame>

    Click `Publish` in the upper right corner and [**share**](/help/platform/access/share-to-web) your app.
  </Step>
</Steps>

[Modify the theme](https://zite.com/help/platform/how-to-build/design-tools) or [style the components](/help/platform/basics/selective-edits) of your app to personalize it or match it with your brand.

## Common use cases

With a ClickHouse connection, you can create apps like:

* **Analytics Dashboards:** Turn large datasets into charts, KPIs, and reports
* **Reporting Tools:** Summarize and break down data by date, location, or other categories
* **Data Exploration Tools:** Let users search, filter, and browse large datasets
* **Activity & Event Tracking:** Store and analyze events from your app as they happen
* **Monitoring Tools:** Track trends, metrics, and activity over time