菜单
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 职业分类
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.