mcp-snowflake-server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| SNOWFLAKE_ROLE | Yes | Your Snowflake role | |
| SNOWFLAKE_USER | Yes | Your Snowflake username | |
| SNOWFLAKE_SCHEMA | Yes | Your Snowflake schema | |
| SNOWFLAKE_ACCOUNT | Yes | Your Snowflake account identifier | |
| SNOWFLAKE_DATABASE | Yes | Your Snowflake database | |
| SNOWFLAKE_PASSWORD | Yes | Your Snowflake password | |
| SNOWFLAKE_WAREHOUSE | Yes | Your Snowflake warehouse |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
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_tablesA | List all tables in a specific database and schema |
| describe_tableB | Get the schema information for a specific table |
| read_queryC | Execute a SELECT query. |
| append_insightB | Add a data insight to the memo |
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/isaacwasserman/mcp-snowflake-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server