Snowflake MCP Server - Barndoor Documentation
Snowflake
SecureBarndoor ManagedData, Analytics & Code Quality
Summary: Snowflake is a cloud-based data platform that powers analytics, reporting, and large-scale data operations, giving teams a unified environment to store, query, and share business-critical data securely and efficiently.
How Teams Use It: With the Barndoor-Managed Snowflake MCP Server, teams can safely connect AI agents to query datasets, retrieve tables, analyze results, and automate data workflows — all while enforcing role-based access controls and keeping sensitive warehouse data protected.
Click for sound
Tools
| Tool Name | Tool Description | Tool Type |
|---|---|---|
| Cortex Complete | Generates text completions using Snowflake's Cortex AI models. Supports chat conversations and function calling. Requires model name and messages. | Execute |
| Cortex Embed | Generates text embeddings (vector representations) using Snowflake's embedding models. Useful for semantic search and similarity. Requires model name and text array. | Execute |
| Get Database | Retrieves detailed metadata for a specific database. Returns properties like retention time, owner, and creation date. Requires the database name. | Read |
| Get Table | Retrieves detailed information about a specific table including columns, data types, and properties. Requires database name, schema name, and table name. | Read |
| List Databases | Retrieves a list of all accessible databases in Snowflake. Returns database names, owners, creation dates, and retention settings. Supports filtering by name pattern. | Read |
| List Schemas | Retrieves schemas within a specific database. Returns schema names, owners, and properties. Requires the database name and optionally supports filtering. | Read |
| List Warehouses | Retrieves a list of all accessible compute warehouses. Returns warehouse names, sizes, states, and resource usage. Supports filtering by name pattern. | Read |
| Send Analyst Feedback | Submits feedback on Cortex Analyst responses for quality improvement. Helps train better query generation. Requires request ID and feedback rating. | Create |
| Send Analyst Message | Converts natural language questions into SQL queries using Cortex Analyst. Returns generated SQL based on semantic models. Requires messages and semantic model. | Execute |
| Submit Statement | Executes one or more SQL statements in Snowflake. Can run queries, create objects, or modify data. Returns results or status. Requires the SQL statement to execute. | Execute |