# ─────────────────────────────────────────────────────────────────────────────
# Pandas MCP Server
# 数据源：数据分析 MCP — 读取CSV/JSON/Excel、描述性统计、分组聚合、相关性分析、透视表
# ─────────────────────────────────────────────────────────────────────────────

FROM python:3.12-slim

WORKDIR /app

# Security: create non-root user
RUN groupadd --gid 1000 mcpuser \
    && useradd --uid 1000 --gid 1000 --shell /bin/bash --create-home mcpuser

# Install system dependencies
RUN apt-get update && apt-get install -y --no-install-recommends \
    curl \
    ca-certificates \
    && rm -rf /var/lib/apt/lists/*

# Copy server code
COPY server.py .
COPY SERVER_METADATA.json .
COPY tools/ ./tools/
# Copy healthcheck (P0 修复 2026-06-28)
COPY mcp_healthcheck.py /app/mcp_healthcheck.py

# Install Python dependencies (version-pinned)
# P0 修复 2026-06-28: 补齐 pandasql（支持 SQL 风格的 DataFrame 查询）
RUN pip install --no-cache-dir --break-system-packages \
    mcp>=1.1.0 \
    pandas>=2.0.0 \
    pandasql>=0.7.3 \
    sqlalchemy>=2.0.0

# Environment
ENV PYTHONUNBUFFERED=1 \
    PYTHONDONTWRITEBYTECODE=1 \
    PYTHONFAULTHANDLER=1

# Health check
HEALTHCHECK --interval=30s --timeout=15s --start-period=10s --retries=3 \
    CMD python mcp_healthcheck.py --server-dir /app --timeout 10

# Labels
LABEL org.opencontainers.image.title="Pandas MCP Server" \
      org.opencontainers.image.description="数据分析 MCP — 读取CSV/JSON/Excel、描述性统计、分组聚合、相关性分析、透视表" \
      org.opencontainers.image.source="https://github.com/csmar432/finai-research-workflow" \
      org.opencontainers.image.version="1.0.0" \
      finresearch.mcp.server="user_pandas_mcp" \
      finresearch.mcp.api="API" \
      finresearch.mcp.apikey="none"

EXPOSE 8000

# Switch to non-root user
USER mcpuser

CMD ["python", "server.py"]
