The Snowflake MCP server provides tools for Snowflake Cortex AI, enabling object management and SQL orchestration within the MCP ecosystem. It supports various capabilities including querying unstructured and structured data, executing SQL, and managing Snowflake objects.
From the registry: MCP Server for Snowflake from Snowflake Labs
Please install the `mcp-snowflakelabs` MCP server into my current AI client (that's you).
Required prerequisites (do these first if not already done):
- **Snowflake account** — Active Snowflake account with appropriate role permissions
- **Service config file** — Create a tools_config.yaml defining Cortex services and permissions
Canonical MCP server config (stdio transport):
- command: `uvx`
- args: ["snowflake-labs-mcp","--service-config-file","<path_to_file>/tools_config.yaml","--connection-name","default"]
- optional environment variables:
- `SNOWFLAKE_ACCOUNT`: Snowflake account identifier (example: `<your-account>`)
- `SNOWFLAKE_USER`: Snowflake username (example: `<your-username>`)
- `SNOWFLAKE_PASSWORD`: Snowflake password or PAT (example: `<your-password>`)
- `SNOWFLAKE_ROLE`: Role to use
- `SNOWFLAKE_WAREHOUSE`: Warehouse to use
- `SNOWFLAKE_PRIVATE_KEY`: Private key for key-pair auth
- `SNOWFLAKE_PRIVATE_KEY_FILE`: Path to private key file
- `SNOWFLAKE_PRIVATE_KEY_FILE_PWD`: Private key file password
Note: Prefers connections.toml via --connection-name. Also supports streamable-http for container deployments on port 9000.
Add this MCP server to my current client's config in the correct format for you. If you need secrets or credentials I haven't provided, ASK me — do not invent values or leave raw placeholders. After adding it, tell me how to verify the server is connected.SNOWFLAKE_ACCOUNTrequiredAccount identifier for Snowflake.SNOWFLAKE_USERrequiredUsername for authentication.SNOWFLAKE_PASSWORDrequiredPassword or programmatic access token.SNOWFLAKE_ROLERole to use for connection.SNOWFLAKE_WAREHOUSEWarehouse to use for queries.Minimal, token-efficient Database MCP Server for PostgreSQL, MySQL, SQL Server, SQLite, MariaDB