The Snowflake MCP is a **managed MCP hosted by Webrix** with Snowflake security: - **Key Pair Authentication**: Secure authentication using RSA key pairs - **OAuth Support**: Alternative OAuth-based authentication - **Role-Based Access**: Respects Snowflake RBAC permissions - **Warehouse Isolation**: Queries run in your designated warehouse - **Query Logging**: All queries are logged in Snowflake's query history **Best practices**: Use a dedicated service account with minimal privileges, set appropriate warehouse timeouts, and avoid exposing sensitive data in query results.

Getting started with the Snowflake MCP: 1. **Provide credentials**: Configure account identifier, username, and authentication 2. **Set context**: Specify default warehouse, database, and schema 3. **Start querying**: Ask your AI assistant to query or explore your data **Example prompts**: - "List all databases in my Snowflake account" - "Show me the tables in the ANALYTICS schema" - "Describe the CUSTOMERS table" - "Run this query: SELECT * FROM sales WHERE date > '2024-01-01' LIMIT 100" - "Preview the first 10 rows of the ORDERS table" - "What's the status of my COMPUTE_WH warehouse?"