Skip to main content
Glama

DataPilot MCP Server

by rickyb30
GitHub
Python
MIT License
OverviewInspectNewEndpointsSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

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

NameRequiredDescriptionDefault
requestYes

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

This server cannot be installed

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