drizzle-orm-schema-and-relations

Drizzle ORM Schema and Relations

Use this skill when the task is about schema declaration, relation modeling, or the ownership of database structure in Drizzle.

Scope

• dialect-specific table and column declaration
• schema organization across one or many files
• aliases, casing, and naming conventions
• indexes, constraints, views, sequences, and RLS
• soft relations and relational-query schema definitions
• beta-only relation-modeling changes like defineRelations

Routing cues

• pgTable, mysqlTable, sqliteTable, column types, pgSchema, constraints, views, relations, defineRelations, or casing -> use this skill
• query composition, CRUD, filters, joins, transactions, cache, or sql -> use drizzle-orm-queries-and-sql
• database connection setup or runtime-specific drivers -> use drizzle-orm-drivers-and-runtimes
• migration generation, introspection, or drizzle.config.ts -> use drizzle-orm-migrations-and-drizzle-kit
• Zod/Valibot/TypeBox schema generation, seed, GraphQL, or ESLint plugin -> use drizzle-orm-ecosystem-and-extensions

Default path

1. Read references/schema-design.md first.
2. If the task touches relations, advanced schema entities, or beta-only relation APIs, read references/relations-and-advanced-schema.md.
3. Keep schema shape, relation definitions, and migration expectations consistent across the same dialect.
4. Distinguish database-enforced foreign keys from Drizzle’s soft-relation/query helpers.

When to deviate

• Use beta-line relation APIs only when the project is intentionally on that version line.
• Split schema files only when the schema size or team workflow justifies it.
• Move to migrations skill when the real question is rollout, introspection, or config rather than schema design.

Quick example

import { integer, pgTable, text } from "drizzle-orm/pg-core";
import { relations } from "drizzle-orm";

export const users = pgTable("users", {
  id: integer().primaryKey().generatedAlwaysAsIdentity(),
  name: text().notNull(),
});

export const usersRelations = relations(users, ({ many }) => ({
  posts: many(posts),
}));