Enhanced MCP MSSQL Server

# Use Node.js 18 Alpine as base image for smaller size FROM node:18-alpine # Set working directory WORKDIR /app # Copy package files first (for better Docker layer caching) COPY package*.json ./ # Install only runtime dependencies (no dev dependencies needed) RUN npm install --omit=dev --ignore-scripts # Copy pre-compiled application COPY dist/ ./dist/ # Create non-root user for security RUN addgroup -g 1001 -S nodejs && \ adduser -S mcp -u 1001 -G nodejs # Change ownership of the app directory RUN chown -R mcp:nodejs /app USER mcp # Expose port (though MCP uses stdio, this is for potential future HTTP interface) EXPOSE 3000 # Health check HEALTHCHECK --interval=30s --timeout=3s --start-period=5s --retries=3 \ CMD node -e "console.log('MCP Server is healthy')" || exit 1 # Default command CMD ["node", "dist/index.js"]