> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-fbfa8bee.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> AI Chatbot | Dot is an intelligent virtual data assistant that answers business data questions, retrieves definitions and relevant data assets, and can even assist with data modelling, powered by ClickHouse.

# Dot

export const CommunityMaintainedBadge = () => {
  return <div className="CommunityMaintainedBadge">
            <div className="CommunityMaintainedIcon">
            <svg xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="currentColor" viewBox="0 0 256 256">
                <path d="M244.8,150.4a8,8,0,0,1-11.2-1.6A51.6,51.6,0,0,0,192,128a8,8,0,0,1-7.37-4.89,8,8,0,0,1,0-6.22A8,8,0,0,1,192,112a24,24,0,1,0-23.24-30,8,8,0,1,1-15.5-4A40,40,0,1,1,219,117.51a67.94,67.94,0,0,1,27.43,21.68A8,8,0,0,1,244.8,150.4ZM190.92,212a8,8,0,1,1-13.84,8,57,57,0,0,0-98.16,0,8,8,0,1,1-13.84-8,72.06,72.06,0,0,1,33.74-29.92,48,48,0,1,1,58.36,0A72.06,72.06,0,0,1,190.92,212ZM128,176a32,32,0,1,0-32-32A32,32,0,0,0,128,176ZM72,120a8,8,0,0,0-8-8A24,24,0,1,1,87.24,82a8,8,0,1,0,15.5-4A40,40,0,1,0,37,117.51,67.94,67.94,0,0,0,9.6,139.19a8,8,0,1,0,12.8,9.61A51.6,51.6,0,0,1,64,128,8,8,0,0,0,72,120Z"></path>
            </svg>
        </div>
            Community Maintained
        </div>;
};

export const Image = ({img, alt, size}) => {
  return <Frame>
      <img src={img} alt={alt} />
    </Frame>;
};

[Dot](https://www.getdot.ai/) is your **AI Data Analyst**.
It connects directly to ClickHouse so you can ask data questions in natural language, discover data, test hypotheses, and answer why questions — directly in Slack, Microsoft Teams, ChatGPT or the native Web UI.

<h2 id="pre-requisites">
  Pre-requisites
</h2>

* A ClickHouse database, either self-hosted or in [ClickHouse Cloud](https://clickhouse.com/cloud)
* A [Dot](https://www.getdot.ai/) account

<h2 id="connecting-dot-to-clickhouse">
  Connecting Dot to ClickHouse
</h2>

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/5u7Mhe0xzzPTUaXM/images/integrations/data-visualization/dot_01.png?fit=max&auto=format&n=5u7Mhe0xzzPTUaXM&q=85&s=bf0a07464e7c257cafe88db735c2ab8b" alt="Configuring ClickHouse connection in Dot (light mode)" border width="1499" height="844" data-path="images/integrations/data-visualization/dot_01.png" />

<br />

1. In the Dot UI, go to **Settings → Connections**.
2. Click on **Add new connection** and select **ClickHouse**.
3. Provide your connection details:
   * **Host**: ClickHouse server hostname or ClickHouse Cloud endpoint
   * **Port**: `8443` (ClickHouse Cloud HTTPS) or `8123` (self-hosted HTTP)
   * **Username / Password**: user with read access
   * **Database**: optionally set a default schema
4. Click **Connect**.

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/5u7Mhe0xzzPTUaXM/images/integrations/data-visualization/dot_02.png?fit=max&auto=format&n=5u7Mhe0xzzPTUaXM&q=85&s=7aba73c3bf4d90419278f1717add74cc" alt="Connecting ClickHouse" size="sm" width="1014" height="1602" data-path="images/integrations/data-visualization/dot_02.png" />

Dot uses **query-pushdown**: ClickHouse handles the heavy number-crunching at scale, while Dot ensures correct and trusted answers.

<h2 id="highlights">
  Highlights
</h2>

Dot makes data accessible through conversation:

* **Ask in natural language**: Get answers without writing SQL.
* **Why analysis**: Ask follow-up questions to understand trends and anomalies.
* **Works where you work**: Slack, Microsoft Teams, ChatGPT, or the web app.
* **Trusted results**: Dot validates queries against your schemas and definitions to minimize errors.
* **Scalable**: Built on query-pushdown, pairing Dot’s intelligence with ClickHouse’s speed.

<h2 id="security">
  Security and governance
</h2>

Dot is enterprise-ready:

* **Permissions & roles**: Inherits ClickHouse user access controls
* **Row-level security**: Supported if configured in ClickHouse
* **TLS / SSL**: Enabled by default for ClickHouse Cloud; configure manually for self-hosted
* **Governance & validation**: Training/validation space helps prevent hallucinations
* **Compliance**: SOC 2 Type I certified

<h2 id="additional-resources">
  Additional resources
</h2>

* Dot website: [https://www.getdot.ai/](https://www.getdot.ai/)
* Documentation: [https://docs.getdot.ai/](https://docs.getdot.ai/)
* Dot app: [https://app.getdot.ai/](https://app.getdot.ai/)

Now you can use **ClickHouse + Dot** to analyze your data conversationally — combining Dot’s AI assistant with ClickHouse’s fast, scalable analytics engine.
