db-query

DB Query — Local + Production

Query the DataToRAG Postgres database without hard-coding any infrastructure details in this file. This skill lives in a public repo, so it deliberately uses placeholders and references private memory for the real values.

Production runs on Neon serverless Postgres, queried through the Neon MCP (plugin: neon@claude-plugins-official) — NOT via SSH into a docker Postgres on the gateway host. The old docker-on-gateway path is retired; the gateway host no longer runs the production database. Local dev still uses a docker Postgres.

Where the actual values come from

Memory files hold the operational details:

• reference_neon_database.md — production Neon project id + region (query via Neon MCP)
• reference_gateway_dev_port.md — local dev server port (separate from DB)
• (Postgres user/database name for local dev is datatoragmcp / datatoragmcp; non-sensitive — the password is in the container's env, not this file)

If the agent doesn't have the reference_neon_database.md entry, run the Neon MCP's list_projects to find the production project (its name/id are in memory, not here), or ask the user. If the Neon MCP isn't connected, install it: claude plugin install neon@claude-plugins-official --scope user, then /reload-plugins and authenticate (OAuth).

Local (dev)

The local Postgres runs inside the dev docker-compose stack started from docker/.

1. Find the local postgres container:

docker ps --filter 'name=postgres' --format '{{.Names}}'

Expected: a container name like docker-postgres-1 or similar.

2. Run a query:

docker exec -it <container> psql -U datatoragmcp -d datatoragmcp -c "SELECT ..."

3. Or open an interactive psql session:

docker exec -it <container> psql -U datatoragmcp -d datatoragmcp

4. Pipe multi-line SQL via stdin:

cat <<'SQL' | docker exec -i <container> psql -U datatoragmcp -d datatoragmcp
SELECT ...
WHERE ...;
SQL