القائمة
Query the local Postgres database — credentials via server/.env, psql one-liners, TypeORM table/column naming, dev vs test DB.
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
استنادا إلى تصنيف SOC المهني
| 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.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