codyswanngt/ops-db-ops

Ops: Database Operations

Manage database migrations, schema generation, and GraphQL code generation.

Argument: $ARGUMENTS — operation (migrate, revert, generate, schema, codegen) and optional environment (default: dev)

Path Convention

• Frontend: Current project directory (.)
• Backend: ${BACKEND_DIR:-../backend-v2} — set BACKEND_DIR in .claude/settings.local.json if your backend is elsewhere

Safety

CRITICAL: Never run migrations or reverts against production without explicit human confirmation.

Discovery

Read the backend package.json to discover available migration and schema scripts:

• migration:run:* — run pending migrations
• migration:revert:* — revert last migration
• migration:generate:* — generate new migration from entity changes
• migration:create — create empty migration
• generate:sql-schema* — regenerate SQL schema for MCP
• AWS credential/profile scripts such as aws:signin:* and any environment-backed remote profile

Read the frontend package.json to discover codegen scripts:

• fetch:graphql:schema:* — fetch GraphQL schema
• generate:types:* — generate TypeScript types

AWS Prerequisite

All database operations (except codegen) require AWS credentials. Verify the target profile first:

cd "${BACKEND_DIR:-../backend-v2}"
aws sts get-caller-identity --profile {aws-profile}

If this is an interactive local session and credentials are expired, refresh the backend's local AWS signin flow. In a headless or remote-routine session, use the preconfigured environment-backed assume-role profile and do not start an SSO browser/device flow.

Operations

migrate (run pending migrations)

Local database:

cd "${BACKEND_DIR:-../backend-v2}"
STAGE={env} bun run migration:run:local

Remote database:

cd "${BACKEND_DIR:-../backend-v2}"
STAGE={env} bun run migration:run:remote:local

revert (undo last migration)

Local database:

cd "${BACKEND_DIR:-../backend-v2}"
STAGE={env} bun run migration:revert:local

Remote database:

cd "${BACKEND_DIR:-../backend-v2}"
STAGE={env} bun run migration:revert:remote:local

generate (create new migration from entity changes)

cd "${BACKEND_DIR:-../backend-v2}"
NAME={migration_name} bun run migration:generate:{env}

create (create empty migration)

cd "${BACKEND_DIR:-../backend-v2}"
NAME={migration_name} bun run migration:create

schema (regenerate SQL schema for MCP)

cd "${BACKEND_DIR:-../backend-v2}"
STAGE={env} bun run generate:sql-schema

codegen (regenerate GraphQL types in frontend)

1. Fetch schema:

   bun run fetch:graphql:schema:{env}
   

2. Generate types:

   bun run generate:types:{env}
   

Note: The backend must be running (locally or deployed) for schema fetching to work.

Output Format

Report operation result:

| Operation | Environment | Target | Status | Details | |-----------|-------------|--------|--------|---------| | migrate | dev | local DB | SUCCESS | 2 migrations applied | | codegen | dev | frontend | SUCCESS | Types regenerated |