DataPilot MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_sqlB | Execute a SQL query on Snowflake and return results |
| list_databasesB | List all databases available to the user |
| list_schemasC | List all schemas in a database |
| list_tablesB | List all tables in a database/schema |
| describe_tableC | Get detailed information about a table's columns |
| get_table_sampleC | Get a sample of data from a table |
| list_warehousesB | List all warehouses available to the user |
| get_warehouse_statusB | Get current warehouse, database, and schema status |
| natural_language_to_sqlC | Convert natural language question to SQL query using AI |
| analyze_query_resultsC | Execute a query and analyze its results using AI |
| suggest_query_optimizationsB | Get AI-powered suggestions for optimizing a SQL query |
| explain_queryA | Explain what a SQL query does in plain English |
| generate_table_insightsC | Generate AI-powered insights about a table's data |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| sql_analysis_prompt | Generate a prompt for analyzing SQL query results |
| data_exploration_prompt | Generate a prompt for exploring a data table |
| sql_optimization_prompt | Generate a prompt for SQL query optimization |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| get_databases_resource | Resource to get list of databases |
Latest Blog Posts
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