ARJ999/SnowFlake-God-Agent-MCP-Server

Snowflake MCP Server - Consolidated (ACCOUNTADMIN Edition)

The Ultimate Snowflake Management MCP Server - Combining Official + Enhanced Monitoring

This is a consolidated, production-ready MCP server that merges ALL capabilities from both the official Snowflake MCP server and the enhanced monitoring server. Designed for ACCOUNTADMIN-level users with complete privileges over their Snowflake environment.

🎯 What's Consolidated

This server combines:

• ✅ Official Snowflake MCP Server - Object management, query execution, semantic views, Cortex AI
• ✅ Enhanced Monitoring Server - Activity tracking, credit consumption, query history, warehouse monitoring

🚀 Quick Deployment to Hostinger VPS

# 1. Clone to VPS
cd /opt
git clone https://github.com/ARJ999/snowflake-mcp-consolidated.git
cd snowflake-mcp-consolidated

# 2. Create .env file
cat > .env << 'EOF'
SNOWFLAKE_ACCOUNT=YOUR_ACCOUNT
SNOWFLAKE_USER=YOUR_USER
SNOWFLAKE_PRIVATE_KEY=YOUR_PRIVATE_KEY_BASE64
EOF

# 3. Build and start
docker compose up --build -d

# 4. Check logs
docker compose logs -f

Server URL: http://YOUR_VPS_IP:8083/mcp

📋 Complete Tool List

Core Object Management (from Official Server)

• create_snowflake_object - Create databases, schemas, tables, views
• drop_snowflake_object - Drop Snowflake objects
• describe_object - Get detailed object information
• update_snowflake_object - Modify existing objects

Query Execution (from Official Server)

• run_snowflake_query - Execute ANY SQL query with full ACCOUNTADMIN permissions

Semantic Management (from Official Server)

• query_semantic_view - Query semantic views for AI analytics

Monitoring & Analytics (from Enhanced Server)

• get_activity_summary - Comprehensive activity report (queries, users, credits, logins)
• get_query_history - Detailed query history with filters
• get_credit_consumption - Credit usage breakdown by warehouse
• get_warehouse_status - Current status of all warehouses
• get_failed_queries - Failed queries with error details

Cortex AI Services (Optional, from Official Server)

• Cortex Search, Analyst, and Agent tools (configure in service_config.yaml)

⚙️ Configuration

ACCOUNTADMIN Privileges

The server is configured for full ACCOUNTADMIN access:

sql_statement_permissions:
  - Select: True
  - Insert: True
  - Update: True
  - Delete: True      # ENABLED
  - Drop: True        # ENABLED
  - TruncateTable: True  # ENABLED
  - Create: True
  - Alter: True
  - Grant: True       # ENABLED
  - Revoke: True      # ENABLED
  - Unknown: True     # ENABLED for maximum flexibility

🔧 Management

# View logs
docker compose logs -f

# Restart
docker compose restart

# Stop
docker compose down

# Rebuild
docker compose down && docker compose up --build -d

📊 Example Usage

Get Activity Summary

{
  "tool": "get_activity_summary",
  "arguments": {
    "days": 1,
    "include_failed_queries": true,
    "include_credits": true
  }
}

Execute Query

{
  "tool": "run_snowflake_query",
  "arguments": {
    "query": "SELECT * FROM RNWL_DEV.RNWL_CRM.DIM_MATERIAL LIMIT 10"
  }
}

Track Credits

{
  "tool": "get_credit_consumption",
  "arguments": {
    "days": 7
  }
}

🎯 Key Features

✅ Complete Consolidation - All tools from both servers in one place
✅ ACCOUNTADMIN Power - Full privileges for complete Snowflake control
✅ Comprehensive Monitoring - Activity, credits, queries, warehouses
✅ Unrestricted Querying - Execute any SQL statement
✅ Production Ready - Auto-restart, health checks, logging
✅ Easy Deployment - Docker Compose for Hostinger VPS

🔗 Repository

GitHub: https://github.com/ARJ999/snowflake-mcp-consolidated

📚 Documentation

• Snowflake MCP Official Docs
• Model Context Protocol

Built for ACCOUNTADMIN-level Snowflake management with complete privileges and comprehensive monitoring capabilities.