ClickHouse

Query (SELECT)

Execute a SELECT query on a ClickHouse database

Execute Raw SQL

Execute raw SQL (DDL, mutations, or queries) on a ClickHouse database

Insert Row

Insert a row into a ClickHouse table

Insert Rows (Bulk)

Insert multiple rows into a ClickHouse table

Update Data

Update rows in a ClickHouse table via an ALTER TABLE ... UPDATE mutation

Delete Data

Delete rows from a ClickHouse table via an ALTER TABLE ... DELETE mutation

List Databases

List all databases on a ClickHouse server

List Tables

List tables in the connected ClickHouse database

Describe Table

Describe the columns of a ClickHouse table

Show Create Table

Get the CREATE TABLE statement (DDL) for a ClickHouse table

Count Rows

Count rows in a ClickHouse table, optionally filtered

Introspect Schema

Introspect a ClickHouse database to retrieve table structures, columns, and engines

Create Database

Create a new database on a ClickHouse server

Drop Database

Drop a database from a ClickHouse server

Create Table

Create a new MergeTree-family table in ClickHouse

Drop Table

Drop a table from a ClickHouse database

Truncate Table

Remove all rows from a ClickHouse table

Rename Table

Rename a ClickHouse table

Optimize Table

Trigger a merge of table parts via OPTIMIZE TABLE

List Partitions

List active partitions for a ClickHouse table

Drop Partition

Drop a partition from a ClickHouse table

List Mutations

List mutations (async ALTER UPDATE/DELETE) for the connected database

List Running Queries

List currently running queries on a ClickHouse server

Kill Query

Kill a running query by its query ID

Table Stats

Get row counts and on-disk size for tables in the connected database

List Clusters

List configured clusters, shards, and replicas