capabilities.work

What you can do with ClickHouse

Every task in plain language. Pick one, and we can help you get access.

153 things you can do

ClickHouse

ClickHouse is a fast open-source column-oriented database management system that enables real-time analytical reporting using SQL. ClickHouse exposes multiple interfaces - an HTTP interface for SQL queries, native TCP, MySQL and PostgreSQL wire-compatible interfaces, and a gRPC interface - and the ClickHouse Cloud management plane offers a public OpenAPI-described REST API for provisioning and man

Disaster Recovery & Resilience

Change a service's backup schedule and retentionSet up a custom backup bucket for a serviceRemove a service's custom backup bucketUpdate a service's custom backup bucketList a service's backupsGet details of one backupGet a service's backup schedule and retentionGet a service's custom backup bucket

IT Infrastructure Management

Create a managed Postgres serviceDelete a Postgres serviceRename or resize a Postgres serviceRestore a Postgres service to a new serviceReset a Postgres superuser passwordRestart, promote or switch over a Postgres serviceCreate a read replica of a Postgres serviceReplace all Postgres and PgBouncer configurationChange some Postgres or PgBouncer settingsCreate a new ClickHouse serviceDelete a stopped ClickHouse serviceRename a service or change its IP access listEnable or configure the query-over-API endpointDisable the query-over-API endpointStart, stop or wake a ClickHouse serviceSet total memory limits and idle scalingSet per-replica memory and replica autoscalingChange a ClickHouse service's passwordAdd a private endpoint to a serviceSet a service's scheduled autoscalingRemove a service's scheduled autoscalingSet a service's upgrade windowRemove a service's upgrade windowChange ClickHouse settings on a serviceReset a ClickHouse setting to its defaultList managed Postgres servicesGet a Postgres service's detailsDownload a Postgres service's CA certificatesGet Postgres and PgBouncer configurationGet time-series metrics for a Postgres serviceList the slowest query patterns on PostgresGet one slow query pattern and recent runsSearch Postgres server logsList instance profiles available in a regionList ClickHouse services in the organizationGet a ClickHouse service's detailsGet the info needed to set up a private endpointGet a service's query-over-API endpoint configGet a service's scheduled autoscalingGet a service's upgrade windowList ClickHouse settings explicitly set on a serviceGet the schema of configurable ClickHouse settingsGet one ClickHouse setting's value

Identity & Access Management

Create a custom organization roleDelete a custom organization roleUpdate a custom organization roleRemove a member from the organizationChange a member's roleInvite someone to the organizationCancel an organization invitationList the organization's rolesGet a role's policies and actorsList organization membersGet one member's detailsList pending organization invitationsGet one invitation's details

Observability Management

Create a ClickStack dashboardUpdate an existing ClickStack dashboardDelete a ClickStack dashboardCreate a ClickStack alertCreate a ClickStack data sourceReplace a ClickStack data sourceDelete a ClickStack data sourceUpdate an existing ClickStack alertDelete a ClickStack alertCreate a ClickStack notification webhookReplace a ClickStack notification webhookDelete a ClickStack notification webhookCreate a custom ClickStack team roleUpdate a custom ClickStack team roleDelete a custom ClickStack team roleSave a ClickStack searchReplace an existing ClickStack saved searchDelete a ClickStack saved search and its alertsGet org-wide Prometheus metrics (deprecated)List Prometheus scrape targets for every serviceGet Prometheus metrics for one ClickHouse serviceGet Prometheus metrics for all Postgres servicesGet Prometheus metrics for one Postgres serviceList ClickStack dashboardsGet one ClickStack dashboardValidate a dashboard definition without savingList ClickStack alertsList ClickStack data sourcesGet one ClickStack data sourceGet one ClickStack alertList ClickStack notification webhooksList ClickStack team rolesGet one ClickStack team roleList ClickStack saved searchesGet one ClickStack saved search

Subscription Billing & Revenue Management

Get daily usage costs for the organizationList prepaid balances (deprecated endpoint)Get the organization's remaining credits

Other things you can do

Execute SQL or insert data via HTTP POSTAttach a UDF version to a serviceDetach a UDF from a serviceCreate a new UDFDelete a UDF and all its versionsGet a presigned URL to upload UDF codeBuild a new version of an existing UDFDelete one version of a UDFCreate a ClickPipe to ingest dataDelete a ClickPipeUpdate a ClickPipe's name, source or mappingsTune a ClickPipe's advanced settingsScale a streaming or object storage ClickPipeStart, stop or resync a ClickPipeResize shared compute for database CDC ClickPipesCreate a reverse private endpoint for ClickPipesDelete a reverse private endpointChange a reverse private endpoint's DNS mappingsCreate a new API keyDelete an API keyUpdate an existing API keyRename or reconfigure the organizationCreate BYOC infrastructure in my cloud accountRemove BYOC infrastructureRename BYOC infrastructureCheck replica delay across the clusterRun a read-only SQL query over HTTP GETCheck a UDF's attachment to one serviceList the services a UDF is attached toList the organization's UDFsGet the latest version of a UDFList every version of a UDFList a service's ClickPipesGet a service's ClickPipes capabilities and identityGet details of one ClickPipeGet a ClickPipe's advanced settingsInfer the schema of a ClickPipe sourceGet shared scaling for database CDC ClickPipesList reverse private endpoints for ClickPipesGet one reverse private endpointPing the server to check it is healthyOpen the built-in Play web UIList an organization's API keysGet details of one API keyFind the organization tied to my API keyGet organization detailsList organization resource quotas and usageGet one organization quota by codeList the organization's activity logGet one organization activity entryGet org private endpoint config for a region (deprecated)