Azure SQL MCP Server

#!/bin/bash # Quick Start Setup Script for Azure SQL MCP Server # This script helps you set up the MCP server quickly set -e echo "==============================================" echo "Azure SQL MCP Server - Quick Setup" echo "==============================================" echo "" # Check Python version echo "Checking Python version..." if command -v python3 &> /dev/null; then PYTHON_VERSION=$(python3 --version 2>&1 | awk '{print $2}') echo "✓ Python $PYTHON_VERSION found" else echo "✗ Python 3 not found. Please install Python 3.8 or higher." exit 1 fi # Create virtual environment echo "" echo "Creating virtual environment..." if [ ! -d "venv" ]; then python3 -m venv venv echo "✓ Virtual environment created" else echo "✓ Virtual environment already exists" fi # Activate virtual environment echo "" echo "Activating virtual environment..." source venv/bin/activate echo "✓ Virtual environment activated" # Install dependencies echo "" echo "Installing dependencies..." pip install --upgrade pip > /dev/null 2>&1 pip install -r requirements.txt echo "✓ Dependencies installed" # Check for .env file echo "" if [ ! -f ".env" ]; then echo "⚠️ No .env file found. Creating from template..." cp .env.example .env echo "✓ Created .env file" echo "" echo "━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━" echo "IMPORTANT: Please edit .env and add your Azure SQL credentials" echo "━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━" echo "" echo "Required values:" echo " - AZURE_SQL_SERVER" echo " - AZURE_SQL_DATABASE" echo " - AZURE_SQL_USERNAME" echo " - AZURE_SQL_PASSWORD" echo "" echo "After editing .env, run: python test_server.py" echo "" else echo "✓ .env file exists" # Check if credentials are set if grep -q "your-server.database.windows.net" .env || grep -q "your-database-name" .env; then echo "" echo "⚠️ .env file contains placeholder values" echo "Please update it with your actual Azure SQL credentials" echo "" else echo "" echo "Testing server connection..." python test_server.py fi fi echo "" echo "==============================================" echo "Setup complete!" echo "==============================================" echo "" echo "Next steps:" echo " 1. Ensure your .env file has correct credentials" echo " 2. Test the server: python test_server.py" echo " 3. Run the server: python azure_sql_mcp.py" echo "" echo "For Copilot Studio integration, see:" echo " - COPILOT_STUDIO_SETUP.md" echo ""