snowflake-mcp-platinum

ARJ999/snowflake-mcp-platinum

3.2

If you are the rightful owner of snowflake-mcp-platinum and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The Snowflake MCP Platinum Server is a comprehensive management tool designed to consolidate all Snowflake capabilities into a single, powerful platform for expert-level environment management.

Tools
5
Resources
0
Prompts
0

Snowflake MCP Platinum Server

The Ultimate Snowflake Management & Architecture MCP Server

A world-class, platinum standard MCP server that consolidates all Snowflake capabilities into a single, powerful tool for expert-level, full-cycle environment management.

Features

Core Capabilities (from snowflake-official)

  • ✅ Object Management: Create, drop, and manage databases, schemas, tables, views
  • ✅ Query Execution: Run any SQL query with ACCOUNTADMIN privileges
  • ✅ Warehouse Management: Suspend, resume, and configure warehouses

Monitoring & Analytics (from snowflake-enhanced)

  • ✅ Activity Summaries: Get detailed activity reports
  • ✅ Credit Tracking: Monitor credit consumption
  • ✅ Query History: Analyze query patterns and performance

Expert-Level Tools (NEW)

  • ✅ Semantic View Validation: Validate semantic views against underlying tables
  • ✅ Query Performance Analysis: Deep dive into query execution and optimization
  • ✅ Warehouse Sizing Recommendations: AI-powered warehouse sizing based on usage patterns
  • ✅ Data Lineage Tracking: Trace data flow from source to destination

AI & Innovation

  • ✅ Cortex Analyst: Natural language to SQL
  • ✅ Cortex Search: Semantic search over unstructured data
  • ✅ Cortex Agents: Agentic AI orchestration
  • ✅ Document AI: Extract structured data from documents

Deploy to Hostinger

Deploy to Hostinger

Environment Variables

SNOWFLAKE_ACCOUNT=your_account_identifier
SNOWFLAKE_USER=your_username
SNOWFLAKE_PRIVATE_KEY=your_base64_encoded_private_key

MCP Client Configuration

Claude Desktop

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "snowflake-platinum": {
      "url": "http://72.61.173.164:8083/mcp",
      "transport": "http",
      "description": "Snowflake MCP Platinum - Ultimate Snowflake Management"
    }
  }
}

Available Tools

Object Management

  • create_database, drop_database
  • create_schema, drop_schema
  • create_table, drop_table
  • describe_object

Query & Performance

  • run_snowflake_query - Execute any SQL query
  • analyze_query_performance - Deep performance analysis
  • recommend_warehouse_sizing - AI-powered sizing recommendations

Architecture & Modeling

  • validate_semantic_view - Validate semantic views
  • get_data_lineage - Trace data lineage

Monitoring

  • get_activity_summary - Activity reports
  • get_credit_consumption - Credit tracking
  • get_query_history - Query analytics

AI & Innovation

  • cortex_analyst_query - Natural language queries
  • cortex_search - Semantic search
  • cortex_agent_execute - Agentic orchestration

Server URL

http://72.61.173.164:8083/mcp

License

Apache 2.0

Support

For issues or questions, please open an issue on GitHub.