execute_sql
Execute SQL queries on Snowflake databases, manage warehouses, and retrieve query results with specified row limits using the DataPilot MCP Server.
Instructions
Execute a SQL query on Snowflake and return results
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| request | Yes |
Input Schema (JSON Schema)
{
"$defs": {
"SQLQueryRequest": {
"description": "Request model for SQL query execution",
"properties": {
"limit": {
"anyOf": [
{
"type": "integer"
},
{
"type": "null"
}
],
"default": null,
"description": "Maximum number of rows to return",
"title": "Limit"
},
"query": {
"description": "SQL query to execute",
"title": "Query",
"type": "string"
},
"warehouse": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"description": "Warehouse to use for this query",
"title": "Warehouse"
}
},
"required": [
"query"
],
"title": "SQLQueryRequest",
"type": "object"
}
},
"properties": {
"request": {
"$ref": "#/$defs/SQLQueryRequest",
"title": "Request"
}
},
"required": [
"request"
],
"type": "object"
}