list_columns
Retrieves column names and metadata for a ClickHouse table or view using system.columns. Specify table name with optional database and profile.
Instructions
[ClickHouse] List columns for a table or view.
Rows from system.columns for the resolved database and table.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"table": "<table>"
},
"name": "list_columns"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table or view name, or database.table. Src: tables. | |
| profile | No | Profile name; uses default profile when omitted. Src: profiles. | |
| database | No | Database when table is unqualified; ignored if table contains a dot. 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. |