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.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "list_tables"
}
}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. |