run_select_query
Run read-only SQL queries (SELECT, SHOW, DESCRIBE, EXISTS) against ClickHouse with results capped at 10,000 rows. Data-modifying statements are automatically rejected.
Instructions
Run a read-only SQL query (SELECT/SHOW/DESCRIBE/EXISTS/...) against ClickHouse.
Results are capped at max_rows (default 1000, hard cap 10000) and the response's "truncated" field reports whether rows were cut off. Data-modifying statements are rejected before reaching the server, and the connection is additionally opened in ClickHouse's server-side readonly mode as a second layer of enforcement.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | ||
| max_rows | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||