pggm-mcp-snowflake-server

# PGGM MCP Snowflake Server A customized Model Context Protocol (MCP) server for Snowflake integration, allowing AI assistants to interact with Snowflake databases securely and efficiently. ## Features - Connect to Snowflake databases and execute queries - Support for various SQL operations and schema exploration - Data insights collection and memoization - SQL write operation detection for enhanced security - Customizable database, schema, and table filtering - Support for authentication through environment variables or command-line arguments ## Installation ### Using pip Option 1: Install Install this in your user site-packages so that it works with all your projects, run a powershell window and: ```bash C:\Users\User> pip install --user pggm-mcp-snowflake-server ``` This will install the package in: C:\Users\USER\AppData\Roaming\Python\Python311\site-packages with the .exe in your C:\Users\USER\AppData\Roaming\Python\Python311\Scripts You might have to add this to your PATH: 1) windows search: Edit the System Environment Variables 2) Navigate: advanced / Environment Variables / select: PATH / Edit.. 3) New: C:\Users\USER\AppData\Roaming\Python\Python311 Option 2: Install in your project venv ```bash pip install pggm-mcp-snowflake-server ``` ### Inside VS-Code Add the following to your settings.json in vs-code (F1 + Preferences: Open User Settings(JSON)) ```bash "workbench.settings.applyToAllProfiles": [ "chat.agent.enabled" ], "github.copilot.chat.agent.thinkingTool": true, "mcp": { "inputs": [], "servers": { "snowflake_local": { "command": "C:\\Users\\USER\\AppData\\Roaming\\Python\\Python311\\Scripts\\pggm_mcp_snowflake_server.exe", # In case you chose to install in your venv, replace above with the following: # "command": "{project_source}\\venv\\Scripts\\pggm_mcp_snowflake_server.exe", "a…