Snowflake MCP Server
by tushar3006
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) |
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_databasesB | List all available databases in Snowflake |
| list_schemasC | List all schemas in a database |
| list_tablesC | List all tables in a specific database and schema |
| describe_tableC | Get the schema information for a specific table |
| read_queryC | Execute a SELECT query. |
| append_insightC | 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 |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/tushar3006/MCP'
If you have feedback or need assistance with the MCP directory API, please join our Discord server