Snowflake MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| SNOWFLAKE_ROLE | No | Your Snowflake role | |
| SNOWFLAKE_USER | No | Your Snowflake username/email | |
| SNOWFLAKE_SCHEMA | No | Your Snowflake schema name | |
| SNOWFLAKE_ACCOUNT | No | Your Snowflake account identifier | |
| SNOWFLAKE_DATABASE | No | Your Snowflake database name | |
| SNOWFLAKE_PASSWORD | No | Your Snowflake password | |
| SNOWFLAKE_WAREHOUSE | No | Your Snowflake warehouse name | |
| SNOWFLAKE_AUTHENTICATOR | No | Authentication method (e.g., 'externalbrowser' for external browser authentication) |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_databasesA | List all available databases in Snowflake |
| list_schemasB | List all schemas in a database |
| list_tablesB | List all tables in a specific database and schema |
| describe_tableA | Get the schema information for a specific table |
| read_queryB | Execute a SELECT query. |
| append_insightB | Add a data insight to the memo |
| fetch_violation_videosC | Fetch video media for specific violation events. Returns simple list with DEVICE_EVENT_UUID and Region. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| Data Insights Memo | A living document of discovered data insights |
TDQS
Scored across 7 tools
Each tool has a clearly distinct purpose with no overlap: append_insight handles data insights, describe_table provides schema details, fetch_violation_videos retrieves video media, list_databases/schemas/tables enumerate database objects, and read_query executes queries. The tools are well-separated by function and target resources.
All tools follow a consistent verb_noun naming pattern (e.g., append_insight, describe_table, fetch_violation_videos, list_databases, list_schemas, list_tables, read_query). The naming is uniform, predictable, and uses snake_case throughout without any deviations.
With 7 tools, the server is well-scoped for Snowflake database operations. The count is appropriate, covering core functions like listing databases/schemas/tables, describing tables, executing queries, and adding insights, without being too sparse or bloated.
The toolset provides good coverage for Snowflake database interactions, including listing, describing, and querying. However, there are minor gaps such as lacking tools for creating or modifying database objects (e.g., create_table, update_table) or handling transactions, which agents might need to work around.