PostgreSQL MCP Server with Authentication

version: '3.8' services: postgres: image: postgres:16 container_name: mcp-postgres environment: POSTGRES_DB: mcp_database POSTGRES_USER: mcp_user POSTGRES_PASSWORD: mcp_password ports: - "5432:5432" volumes: - postgres_data:/var/lib/postgresql/data - ./init.sql:/docker-entrypoint-initdb.d/init.sql healthcheck: test: ["CMD-SHELL", "pg_isready -U mcp_user -d mcp_database"] interval: 10s timeout: 5s retries: 5 volumes: postgres_data: