ClickHouse
Query ClickHouse Cloud — run SQL, list databases and tables, explore services and backups, inspect usage, run ClickPipes.
Community: Submitted by a user or imported; check the owner before granting accessOnlineNo sign-inGlobalFreeRead-only
What it can do
- Get Clickpipe: Returns the specified ClickPipe.
- Get Organizations: Retrieves all accessible ClickHouse Cloud organizations.
- Run Select Query: Executes a SELECT query against a ClickHouse service. Runs a read-only SELECT query on the specified ClickHouse service via the Query API endpoint. This function provides direct acce
What data it sees
Do you need an account
No: the server works without sign-in
Query ClickHouse Cloud — run SQL, list databases and tables, explore services and backups, inspect usage, run ClickPipes.
Server tool list (13)
Raw names from tools/list. Only developers need these.
| get_clickpipe | Returns the specified ClickPipe. |
| get_organizations | Retrieves all accessible ClickHouse Cloud organizations. |
| run_select_query | Executes a SELECT query against a ClickHouse service. Runs a read-only SELECT query on the specified ClickHouse service via the Query API endpoint. This function provides direct access to database content through SQL queries while ensuring that only read operations are permitted. |
| list_databases | Retrieves all databases available in a ClickHouse service. |
| list_tables | Retrieves a comprehensive list of tables in a ClickHouse database, including columns. |
| get_services_list | Retrieves all services in a ClickHouse Cloud organization. |
| get_organization_details | Returns details of a single organization. The auth key must belong to the organization. |
| get_service_details | Returns a service that belongs to the organization. |
| list_clickpipes | Retrieves all ClickPipes configured for a specific service. |
| list_service_backups | Returns a list of all backups for the service. The most recent backups comes first in the list. |
| get_organization_cost | Retrieves billing and usage cost data for a ClickHouse Cloud organization. Returns a grand total and a list of daily, per-entity organization usage cost records for the organization in the queried time period (maximum 31 days). |
| get_service_backup_details | Returns a single backup info. |
| get_service_backup_configuration | Returns the service backup configuration. |