start_server.sh

#!/bin/bash

# Start the SQL Local MCP Server
echo "Starting SQL Local MCP Server..." >&2

# Get the directory where this script is located
DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" &> /dev/null && pwd )"

# Create virtual environment if it doesn't exist
if [ ! -d "$DIR/venv" ]; then
    echo "Creating virtual environment..." >&2
    python3 -m venv "$DIR/venv"
    if [ $? -ne 0 ]; then
        echo "Error: Failed to create virtual environment" >&2
        exit 1
    fi
    echo "Virtual environment created successfully" >&2
fi

# Activate virtual environment
echo "Activating virtual environment..." >&2
source "$DIR/venv/bin/activate"
if [ $? -ne 0 ]; then
    echo "Error: Failed to activate virtual environment" >&2
    exit 1
fi

# Install/update requirements if requirements.txt exists
if [ -f "$DIR/requirements.txt" ]; then
    echo "Installing/updating requirements..." >&2
    pip install -r "$DIR/requirements.txt" >&2
    if [ $? -ne 0 ]; then
        echo "Error: Failed to install requirements" >&2
        exit 1
    fi
    echo "Requirements installed successfully" >&2
else
    echo "Warning: requirements.txt not found" >&2
fi

# Run the MCP server
echo "Starting MCP server..." >&2
python3 "$DIR/mcp_server.py"