run_show
Executes SHOW introspection statements (e.g., SHOW DATABASES, SHOW CREATE TABLE) on ClickHouse, with profile and parameter support.
Instructions
[ClickHouse] Execute SHOW introspection statement.
One statement per call; INTO OUTFILE rejected. Interactive row limits apply (default 500, hard ceiling 1 000). Same timeout as run_query.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | Single SHOW statement (e.g. SHOW DATABASES, SHOW CREATE TABLE). No INTO OUTFILE. | |
| profile | No | Profile name; uses default profile when omitted. Src: profiles. | |
| database | No | Session default database for unqualified names. Src: databases. | |
| parameters | No | Named parameters for driver placeholders (e.g. %(name)s or {name:Type}). |
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. | |
| row_limit | No | The enforced maximum number of rows returned for this query. | |
| truncated | No | Whether the result set was truncated due to the enforced row limit. |