execute-query
Run SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH) in Snowflake via Simple Snowflake MCP. Supports read-only mode for secure data retrieval and outputs results in markdown format.
Instructions
Execute a SQL query in read-only mode (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH) or not (if 'read_only' is false), result in markdown format.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| read_only | No | Allow only read-only queries | |
| sql | Yes | SQL query to execute |
Input Schema (JSON Schema)
{
"properties": {
"read_only": {
"default": true,
"description": "Allow only read-only queries",
"type": "boolean"
},
"sql": {
"description": "SQL query to execute",
"type": "string"
}
},
"required": [
"sql"
],
"type": "object"
}