Database Queries

Overview

Execute read-only SQL queries against PostgreSQL databases via PgBouncer from within application pods. No psql available — use the pg module via node -e.

Configuration

Read project-specific values from the project's CLAUDE.md (## Infrastructure section):

• kubectl context, namespace, app pod label, database name, config file per environment

Constraints

• PgBouncer does NOT support parameterized queries — use inline SQL with quoted values.
• Read-only only. Never run INSERT/UPDATE/DELETE without explicit user confirmation.
• Use require('/app/node_modules/pg') — module is not in the global node path.
• Use development.config.js for DEV, production.config.js for PROD (both files exist in every pod).

Process