## 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   |