dbt MCP Server

#!/bin/bash # dbt MCP Server Startup Script # Starts the dbt MCP server for Claude Code integration set -e echo "🚀 Starting dbt MCP Server for Claude Code..." echo "=============================================" # Check if virtual environment exists if [ ! -d "venv" ]; then echo "❌ Virtual environment not found. Please run setup first." exit 1 fi # Activate virtual environment source venv/bin/activate # Load environment configuration if [ -f ".env.dbt-mcp" ]; then source .env.dbt-mcp echo "✅ Loaded dbt MCP configuration" else echo "⚠️ Warning: .env.dbt-mcp not found, using defaults" fi # Validate dbt project if [ ! -d "$DBT_PROJECT_DIR" ]; then echo "❌ dbt project directory not found: $DBT_PROJECT_DIR" exit 1 fi # Validate dbt profiles if [ ! -d "$DBT_PROFILES_DIR" ]; then echo "❌ dbt profiles directory not found: $DBT_PROFILES_DIR" exit 1 fi # Validate DuckDB database if [ ! -f "$DUCKDB_PATH" ]; then echo "⚠️ Warning: DuckDB database not found at $DUCKDB_PATH" echo " Run 'meltano run tap-csv target-duckdb' to create database" fi echo "" echo "📊 dbt MCP Server Configuration:" echo " Project Dir: $DBT_PROJECT_DIR" echo " Profiles Dir: $DBT_PROFILES_DIR" echo " Profile: $DBT_PROFILE" echo " Target: $DBT_TARGET" echo " Database: $DUCKDB_PATH" echo " CLI Tools: $DBT_MCP_ENABLE_CLI_TOOLS" echo " Discovery Tools: $DBT_MCP_ENABLE_DISCOVERY_TOOLS" echo " Remote Tools: $DBT_MCP_ENABLE_REMOTE_TOOLS" echo "" # Start MCP server echo "🎯 Starting MCP server..." echo " Use Ctrl+C to stop" echo "" python mcp_servers/dbt_server.py