Onboarding Basics

git clone git@github.com:your-org/your-app.git
cd your-app
cat CONTRIBUTING.md | grep -i postgres

# docker-compose.yml (excerpt)
services:
  postgres:
    image: postgres:18.4
    environment:
      POSTGRES_USER: app
      POSTGRES_PASSWORD: app
      POSTGRES_DB: app_dev
    ports: ["5432:5432"]

docker compose up -d postgres
docker compose ps
psql "postgresql://app:app@localhost:5432/app_dev" -c "SELECT version();"

psql "postgresql://app:app@localhost:5432/app_dev"

\conninfo
\dt app.*
\d+ orders
\q

flyway -url=jdbc:postgresql://localhost:5432/app_dev \
  -user=app -password=app migrate

SELECT version, description, success
FROM flyway_schema_history ORDER BY installed_rank DESC LIMIT 3;

EXPLAIN (ANALYZE, BUFFERS)
SELECT id FROM orders WHERE tenant_id = $1 AND status = 'open' LIMIT 50;

## Production access (week 2+)
- Role: app_readonly (SELECT only)
- Buddy required first 5 sessions
- No DDL, no pg_terminate_backend
- Use bastion VPN + psql only (no GUI write mode)

-- Verify role
SELECT current_user, rolsuper, rolcreatedb FROM pg_roles WHERE rolname = current_user;

psql "$LOCAL_URL" -f db/seeds/dev_fixtures.sql
ANALYZE;

docs/
├── database/
│   ├── CONTRIBUTING-db.md
│   └── runbooks/
site/postgresql/   # internal SME guides

Day 1: local postgres + psql + first \d table
Day 2: flyway migrate + read-only staging SELECT
Day 3: EXPLAIN on sample PR with buddy comment
Day 4: incident bundle script walkthrough (read-only)
Day 5: shadow on-call for non-SEV1 alert

-- Good first PR: add partial index with CONCURRENTLY on staging
CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_orders_open_tenant
  ON orders (tenant_id) WHERE status = 'open';

App query slow → EXPLAIN → #database Slack → DBA rotation
SEV1 database → PagerDuty → incident channel → Incident Triage Skill
Schema design question → office hours Tuesday 10:00