run_sql
Execute a read-only SQL query via a Preset database connection to verify query functionality before dataset creation. Supports SELECT, SHOW, DESCRIBE, and EXPLAIN statements.
Instructions
Execute a read-only SQL query through a Preset database connection.
This is a debugging/verification tool — use it to confirm a query works through Preset's connection before creating a dataset. For primary SQL exploration, prefer your Snowflake MCP (igloo-mcp).
Only SELECT, SHOW, DESCRIBE, and EXPLAIN are permitted. Write operations and multi-statement queries are blocked.
Args: sql: SQL query to execute (read-only, single statement) database_id: Database connection ID — use list_databases to find it schema: Optional schema name limit: Max rows to return (default 1000) response_mode: 'compact' (columns only), 'standard' (5 sample rows), or 'full' (all rows with smart truncation). Default: standard.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| database_id | Yes | ||
| schema | No | ||
| limit | No | ||
| response_mode | No | standard |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |