# Triagic + ClickHouse: ticket investigations over your database, read-only

> ClickHouse in Triagic: Run read-only SQL against a ClickHouse cluster. Read-only, with a credential you configure.

Source: https://triagic.com/integrations/clickhouse

## What you can ask

- Look up account acme-labs in ClickHouse and tell me why their last export failed
- In ClickHouse, how many orders for org 8412 are stuck in a non-terminal state right now?
- Which rows in ClickHouse changed for user 51930 in the last 24 hours?
- Compare the ClickHouse record for invoice INV-2291 with what the customer says they see
- Does ClickHouse show the same plan for this account as the billing system does?

## What the agent can do

- `list_databases`
- `list_tables`
- `run_query`

## Connect in three steps

1. **Mint a read-only credential in ClickHouse.** Create a dedicated user or token that can only read. Writes are disabled in the server and each query carries ClickHouse's readonly setting; a role can be pinned per query with SET ROLE.
2. **Add it in the Triagic portal.** Integrations, then Add shared data source, then ClickHouse. Fill in: Host (required); User (required)
3. **Let a desktop pick it up.** Saving validates the shape of what you typed. The first desktop app to sync starts ClickHouse locally and reports running or degraded with the error text.

Setup reference: https://triagic.com/docs/integrations/databases#clickhouse

## Read-only, by construction

Writes are disabled in the server and each query carries ClickHouse's readonly setting; a role can be pinned per query with SET ROLE.

## FAQ

**Can Triagic change anything in ClickHouse?**
No. Writes are disabled in the server and each query carries ClickHouse's readonly setting; a role can be pinned per query with SET ROLE. Give it a read-only credential as well, so the guarantee does not rest on one layer.

**What do I need to connect ClickHouse?**
Host, User. The desktop app on a member's machine starts the connection; the portal never holds a live process.

**Does ClickHouse cost extra?**
No. Every connector is included in the seat price. Start a 14-day trial without a card.

## Related integrations

- [MongoDB](https://triagic.com/integrations/mongodb)
- [PostgreSQL](https://triagic.com/integrations/postgres)
- [MySQL](https://triagic.com/integrations/mysql)
- [Redis](https://triagic.com/integrations/redis)