Using Snowflake MCP server

Snowflake MCP server provides tools for interacting with Snowflake databases. This server provides direct integration with Snowflake data warehouse for schema exploration and data analysis. Here are some tools it contains:

• list_databases: Lists all available databases
• get_database_ddl(): Gets DDL in YAML format
• list_tables(): Lists tables in a specific schema
• read_query(): Executes SELECT queries
• get_database_info(): Gets detailed database information

Snowflake MCP server common uses cases:

• Explore Snowflake database schemas and tables
• Execute data analysis queries
• Generate database documentation
• Track data insights and discoveries
• Support SOLE (Snowflake Object Lifecycle Engine) operations

Example prompts

Basic prompt: Show me all tables in the DATAOPS_DEV database, PUBLIC schema

Assist uses the Snowflake MCP server, precisely the list_tables tool, to fetch the available tables and returns them in the response.

Advanced prompt: Analyze my current Snowflake environment and create a SOLE database definition that matches the existing ANALYTICS_PROD database structure, but optimized for a development environment

Assist creates a to-do list (as shown in the above image), calls the appropriate tool for each subtask, retrieves the relevant information, and consolidates the results into a single response.

Assist response: