Schema | snowflake-mcp

snowflake-mcp

Describes the environment variables required to run the server.

Name	Required	Description
`SNOWFLAKE_ROLE`	No	Snowflake role (optional)
`SNOWFLAKE_USER`	Yes	Snowflake username (typically email)
`SNOWFLAKE_SCHEMA`	No	Snowflake schema name (optional)
`SNOWFLAKE_ACCOUNT`	Yes	Snowflake account identifier (e.g., your-account.region.provider)
`SNOWFLAKE_DATABASE`	No	Snowflake database name (optional)
`SNOWFLAKE_PASSWORD`	Yes	Snowflake password
`SNOWFLAKE_WAREHOUSE`	No	Snowflake warehouse name (optional)

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.

Features and capabilities supported by this server

Protocol revision2025-11-25

Capability	Details
`tools`	{}
`resources`	{}

Functions exposed to the LLM to take actions

Name	Description
read_queryB	Execute a SELECT query on Snowflake
list_databasesA	List all available databases
list_schemasB	List all schemas in a database
list_tablesB	List all tables in a schema
describe_tableB	Get table schema information

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
`Databases`	List of available Snowflake databases
`Schemas`	List of available schemas in the current database
`Tables`	List of tables in the current schema

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/patrickfreyer/mcp-server-snowflake'

If you have feedback or need assistance with the MCP directory API, please join our Discord server