MCP Servers / database / Data Pilot (Snowflake)

Data Pilot (Snowflake)

none★ 2database

A comprehensive Model Context Protocol (MCP) server for interacting with Snowflake using natural language and AI.

Install

How to run this server

[ { "cmd": "pip install -r", "imports": [] } ]

server path: data-pilot-snowflake

Tools

What this server exposes

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

Configuration

Environment & auth

authnone

envOPENAI_API_KEY

Resources