Schema | DataPilot MCP Server

DataPilot MCP Server

Describes the environment variables required to run the server.

Name	Required	Description	Default
No arguments

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Server capabilities have not been inspected yet.

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

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

Contextual data attached and managed by the client

Name	Description
`get_databases_resource`	Resource to get list of databases

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