Menu
Query the local Postgres database — credentials via server/.env, psql one-liners, TypeORM table/column naming, dev vs test DB.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
NestJS endpoint return-type and DTO rules — explicit DTO return types, @ApiOkResponse matching, wrapper DTOs, constructor patterns, and the post-edit `bun run gen-api` step. Read before editing any *.dto.ts or *.controller.ts in server/.
Generate and review TypeORM database migrations in server/ — migration:generate vs migration:create, and the column-rename DROP+ADD pitfall. Read before generating or writing any db migration.
Verify changes against the locally running apps — curl the API, drive the admin/frontend GUIs with Playwright
| name | local-db |
| description | Query the local Postgres database — credentials via server/.env, psql one-liners, TypeORM table/column naming, dev vs test DB. |
Local Postgres credentials in server/.env. Do not read the entire file.
You can grep for the lines containing the specific variables: grep -E '^(DB_HOST|DB_PORT|DB_USERNAME|DB_PASSWORD|DB_NAME)' server/.env (these variables are not sensitive).
PGPASSWORD=$DB_PASSWORD psql -h $DB_HOST -p $DB_PORT -U $DB_USERNAME -d $DB_NAME -c "SELECT ..."
ReminderGroup → reminder_group)."newStatus").server/.env.test): password postgres, database postgres — don't mix up with dev DB.