# Dbc Schema

> Generate Effect Schema definitions for WoW DBC tables. Use when adding new game data tables or updating existing schemas.

- Skill: `majiayu000/dbc-schema` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/dbc-schema`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/dbc-schema/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/dbc-schema

---


# DBC Schema Generator

Generate Effect Schema definitions for WoW database tables.

## Schema Location

`packages/wowlab-core/src/internal/schemas/dbc/`

## Schema Template

```ts
// {TableName}Schema.ts
import * as Schema from "effect/Schema";

export class {TableName} extends Schema.Class<{TableName}>("{TableName}")({
  ID: Schema.Number,
  // Other fields - preserve CSV column order!
  Name: Schema.String,
  Description: Schema.String,
  Flags: Schema.Number,
  // ...
}) {}

export const {TableName}Schema = Schema.Array({TableName});
```

## Important Rules

1. **Preserve CSV column order** - perfectionist sorting is disabled for DBC schemas
2. **Use Schema primitives** - `Schema.Number`, `Schema.String`, `Schema.Boolean`
3. **Nullable fields** - Use `Schema.NullOr(Schema.Number)` for optional numeric fields
4. **Arrays** - Use `Schema.Array(Schema.Number)` for array columns

## Column Type Mapping

| CSV Type         | Effect Schema                                   |
| ---------------- | ----------------------------------------------- |
| int              | `Schema.Number`                                 |
| float            | `Schema.Number`                                 |
| string           | `Schema.String`                                 |
| localized string | `Schema.String`                                 |
| bool             | `Schema.Boolean`                                |
| foreign key      | `Schema.Number` (reference to another table ID) |

## Registration

After creating schema, register in `DbcTableRegistry.ts`:

```ts
import { {TableName} } from "./internal/schemas/dbc/{TableName}Schema.js";

// Add to registry type
export type DbcTableName =
  | "Spell"
  | "{TableName}"  // Add here
  | ...;

// Add to row type mapping
export type DbcRow<T extends DbcTableName> =
  T extends "{TableName}" ? {TableName} :
  ...;
```

## Instructions

1. Get CSV headers from DBC table
2. Map columns to Schema types
3. Generate schema class (preserve column order!)
4. Register in DbcTableRegistry
5. Re-export from Schemas.ts if public API