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

• 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?

These are the 3 tools Triagic exposes from the ClickHouse MCP server. Anything else the server lists is dropped at connect time.

• list_databases
• list_tables
• run_query

1. 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. 2

   Add it in the Triagic portal

   Integrations, then Add shared data source, then ClickHouse.

   • Host
   • User
3. 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.

Field-by-field setup, TLS options and the error table: ClickHouse in the docs.

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

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.

• MongoDBQuery collections and inspect documents behind a ticket.
• PostgreSQLBrowse schemas and run read-only SQL against a Postgres database.
• MySQLBrowse every database, table and schema the credentials can reach. Read-only: there is no tool that runs a statement you write.
• RedisInspect keys and cached values. Read-only: the server's write tools are not exposed.