Data Pilot (Snowflake)
JSON →A comprehensive Model Context Protocol (MCP) server for interacting with Snowflake using natural language and AI.
Install
pip install -r Tools · 13
- execute_sql Execute SQL queries with results
- list_databases List all accessible databases
- list_schemas List schemas in a database
- list_tables List tables in a database/schema
- describe_table Get detailed table column information
- get_table_sample Retrieve sample data from tables
- list_warehouses List all available warehouses
- get_warehouse_status Get current warehouse, database, and schema status
- natural_language_to_sql Convert natural language questions to SQL queries
- analyze_query_results AI-powered analysis of query results
- suggest_query_optimizations Get optimization suggestions for SQL queries
- explain_query Plain English explanations of SQL queries
- generate_table_insights AI-generated insights about table data
Environment variables
OPENAI_API_KEY
Links
★ 2 GitHub stars