list_tables
List tables and views in a ClickHouse database, showing engine, keys, row count, and size for query planning.
Instructions
[ClickHouse] List tables and views in a database.
Rows from system.tables: name, engine, primary_key, sorting_key, partition_key, total_rows, total_bytes for query planning.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| profile | No | Profile name; uses default profile when omitted. Src: profiles. | |
| database | No | Database to list; client default when omitted. Src: databases. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | Row values aligned with the columns list. | |
| columns | Yes | Ordered list of column names. Each row aligns with these names by index. |