Schema | Snowflake MCP Server

Snowflake MCP Server

Describes the environment variables required to run the server.

Name	Required	Description
`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)

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.

Server capabilities have not been inspected yet.

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.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
`Data Insights Memo`	A living document of discovered data insights

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