DataPilot MCP Server

MIT License

Overview InspectNew Schema Related Servers Reviews Score

execute_sql

Run SQL queries on Snowflake directly through the DataPilot MCP Server to retrieve or analyze data efficiently, specifying query, row limits, and warehouse as needed.

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"
}

Install Server

HTTP connection URL

Other Tools from DataPilot MCP Server

Related Tools

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/rickyb30/datapilot-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server