Skip to main content

ClickHouse

Run read-only SQL against your ClickHouse over its HTTPS interface.

Connect a ClickHouse deployment's HTTPS interface to run read-only SELECT/SHOW/DESCRIBE queries with server-side row caps.

Connect

Credential fieldRequiredWhere it comes from
Password (PASSWORD)YesThe database user's password.
SettingRequiredWhat it is
Host URL (HOST_URL)YesThe HTTPS interface, e.g. https://abc.clickhouse.cloud:8443.
Username (USERNAME)NoDatabase user. Defaults to default.

Tools

ToolAccessWhat it does
Query (yekar.clickhouse.query)ReadRun one read-only SQL statement against the connected ClickHouse and return JSON rows, capped server-side.
List tables (yekar.clickhouse.list-tables)ReadList the tables visible to this connection, per database.

Notes

  • Point the Host URL at the HTTPS interface - ClickHouse Cloud exposes it at port 8443 by default.
  • Use a read-only database user; the surface refuses non-read statements regardless.