PostgreSQL MCP AllAccess

# PgBouncer Dockerfile FROM alpine:3.18 # Install PgBouncer and dependencies RUN apk add --no-cache \ pgbouncer \ postgresql-client \ bash \ coreutils # Create pgbouncer user and group (let Alpine auto-assign UID/GID) RUN addgroup -S pgbouncer && \ adduser -S -D -G pgbouncer pgbouncer # Create directories and set ownership RUN mkdir -p /etc/pgbouncer /var/log/pgbouncer /var/run/pgbouncer && \ chown -R pgbouncer:pgbouncer /etc/pgbouncer /var/log/pgbouncer /var/run/pgbouncer # Copy configuration files COPY pgbouncer.ini /etc/pgbouncer/pgbouncer.ini COPY entrypoint.sh /usr/local/bin/entrypoint.sh # Set executable permissions RUN chmod +x /usr/local/bin/entrypoint.sh # Expose PgBouncer port EXPOSE 6432 # Health check HEALTHCHECK --interval=30s --timeout=5s --start-period=10s --retries=3 \ CMD psql -h localhost -p 6432 -U postgres -d pgbouncer -c "SHOW STATS" || exit 1 # Switch to pgbouncer user USER pgbouncer # Set entrypoint ENTRYPOINT ["/usr/local/bin/entrypoint.sh"]