MCP SQL Server

# Dockerfile for the MCP Database Server # Suggested build command: docker build -t mcp-server:latest . # Use an official Python runtime as a parent image (Debian 12 Bookworm based) FROM python:3.10-slim # Set the working directory in the container WORKDIR /app # Update the package list and install required packages RUN apt-get clean && \ apt-get update -y && apt-get upgrade -y && \ apt-get install -y libgl1 curl git gcc g++ wget bzip2 gnupg \ build-essential unixodbc-dev libmariadb-dev lsb-release && \ apt-get clean && \ rm -rf /var/lib/apt/lists/* # Add Microsoft ODBC Driver for SQL Server RUN curl -sSL https://packages.microsoft.com/keys/microsoft.asc | gpg --dearmor -o /usr/share/keyrings/microsoft.gpg && \ echo "deb [arch=amd64 signed-by=/usr/share/keyrings/microsoft.gpg] https://packages.microsoft.com/debian/12/prod bookworm main" > /etc/apt/sources.list.d/mssql-release.list && \ apt-get update -y && \ ACCEPT_EULA=Y apt-get install -y msodbcsql18 mssql-tools18 && \ echo 'export PATH="$PATH:/opt/mssql-tools18/bin"' >> ~/.bashrc && \ apt-get clean && \ rm -rf /var/lib/apt/lists/* # Update PATH for mssql-tools if installed (optional) # ENV PATH="/opt/mssql-tools/bin:${PATH}" # Copy the requirements file into the container at /app COPY requirements.txt . # Install Python dependencies # --no-cache-dir reduces image size RUN pip install --no-cache-dir -r requirements.txt # Copy the rest of the application code into the container at /app COPY . . # Make port 3939 available to the world outside this container EXPOSE 3939 # Define environment variables (optional, can be set at runtime) # ENV EXAMPLE_VAR=example_value # Run mcp_server.py when the container launches CMD ["python", "mcp_server.py"]