ClickHouse icon

ClickHouse

Query, insert, update, delete, and manage ClickHouse tables. Supports AI agent tool use with schema discovery, auto-pagination for large results, and parameterized queries.

Actions11

List Tables

AI-generated

Summary

List tables in a ClickHouse database, optionally filtered by a SQL LIKE pattern.

Inputs

  • database — Database name or ID to list tables from; can be selected from a list or expressed with an expression.
  • pattern — SQL LIKE pattern to filter table names, e.g., '%events%'.

Output shape

array of table descriptors (each includes name, engine, total_rows, total_bytes, etc.)

Returns a JSON array of tables; no pagination — all matching tables are returned in one response.

Examples

Example 1: List all tables in the default database

Leave both options empty; the node returns all tables.

Example 2: List tables matching a pattern

Set 'Pattern' to '%events%' and optionally specify a 'Database Name or ID'.

Links

Discussion