Snowflake Stored Procedure Integration
About
Integrates and executes Snowflake stored procedures through an MCP server.
Details
- Author
- cjaimesg
- Categories
- Database, Other
Jump to
Quickstart Setup Guide For Dev Environment
Thequickstart/folder contains a step-by-step guide for setting up and testing this module in theDev Environment.
This project is licensed under the MIT License.
Read-only access to Snowflake databases. Requires Snowflake connection information provided via MCP client configuration.
A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants
Analyzes relational database schemas (PostgreSQL, Snowflake, and Dremio) and automatically generates comprehensive ontologies in RDF/Turtle format with direct SQL mappings.
API-first engine and MCP server that transforms declarative YAML model definitions into optimized SQL for Postgres, Snowflake, ClickHouse, Dremio, and Databricks
Interact with Snowflake databases to query and manage data.
Snowflake MCP server by CData for read-only querying of live Snowflake data from AI agents and MCP clients.
A read-only server for interacting with Snowflake databases, allowing SELECT queries and access to schema context.
An MCP server for interacting with Snowflake databases.
Official MCP server for dbt (data build tool) providing integration with dbt Core/Cloud CLI, project metadata discovery, model information, and semantic layer querying capabilities.
Snowflake Stored Procedure Integration with MCP Server
This project simplifies the integration of Snowflake stored procedures with an MCP (Model Context Protocol) server. It provides a framework to define, manage, and execute Snowflake procedures from the MCP server environment.
git clone https://github.com/Cjaimesg/snowflake-mcp-sp-integration.git cd snowflake-mcp-sp-integration
uv venv source .venv/bin/activate # On Windows: .venv\Scripts\activate
- Create a.envfile in the root directory (do not commit this file). Define all required Snowflake credentials:
SNOWFLAKE_ACCOUNT=<xxx>-<xxx> SNOWFLAKE_USER=<xxx> SNOWFLAKE_PASSWORD=<xxx> SNOWFLAKE_ROLE=<xxx> SNOWFLAKE_WAREHOUSE=<xxx> SNOWFLAKE_DATABASE=<xxx> SNOWFLAKE_SCHEMA=<xxx> SNOWFLAKE_HOST=<xxx>-<xxx>.snowflakecomputing.com
All variables are mandatory and must be defined by the user.
- Configure the project as an MCP server. In your MCP configuration file, add an entry like the following, adjusting the paths to match your local environment. Both --schemas and --procedures are optional and default to empty lists.
- Schemas: All store procedures in the specified schemas will be available to the MCP server.
- Procedures: Only the specified procedures will be available to the MCP server.
{ "mcpServers": { "snowflake_sp_server": { "command": "absolute/path/to/your/uv/uv.exe", "args": [ "--directory", "absolute/path/to/snowflake-mcp-sp-integration", "run", "main.py", "--schemas", "DB_NAME.SCHEMA_NAME", "--procedures", "DB_NAME.OTHER_SCHEMA_NAME.PROCEDURE_NAME" ] } } }
Replaceabsolute/path/to/snowflake-mcp-sp-integrationwith the actual directory where you cloned this repository.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
