# DB Schema Change

> Use when adding/modifying database tables or columns in Drizzle ORM schema

- Skill: `hiroppy/db-schema-change` (Agent Skill)
- Install (CLI): `npx skillmds@latest add hiroppy/db-schema-change`
- Raw SKILL.md: https://api.skillmd.com/api/skills/hiroppy/db-schema-change/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: hiroppy (https://skillmd.com/u/hiroppy)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/hiroppy/db-schema-change

---


# DB Schema Change Skill

## Checklist (MUST complete all)

- [ ] Add `createdAt: text("created_at").notNull()` to new tables
- [ ] Add `updatedAt: text("updated_at").notNull()` to new tables
- [ ] Specify `onDelete` for all foreign keys (cascade/set null)
- [ ] Add index for frequently queried columns
- [ ] Update `packages/db/src/schema/relations.ts` if adding relations
- [ ] Run migration: `pnpm --filter @mf-dashboard/db exec drizzle-kit generate`
- [ ] Update `docs/architecture/database-schema.md` with new ERD

## File Locations

- Schema: `packages/db/src/schema/tables.ts`
- Relations: `packages/db/src/schema/relations.ts`
- Repositories: `packages/db/src/repositories/`
- Types: `packages/db/src/types.ts`

## Template

```typescript
export const newTable = sqliteTable("new_table", {
  id: integer("id").primaryKey({ autoIncrement: true }),
  // ... your columns ...
  createdAt: text("created_at").notNull(),
  updatedAt: text("updated_at").notNull(),
});
```

## Foreign Key Template

```typescript
foreignKeyColumn: integer("foreign_key_column")
  .notNull()
  .references(() => parentTable.id, { onDelete: "cascade" }),
```

## Index Template

```typescript
export const myTable = sqliteTable(
  "my_table",
  {
    // columns...
  },
  (table) => [index("my_table_column_idx").on(table.columnName)],
);
```