DB Schema Architect — Data & AI agent for Claude Code
Use when designing or modifying database schemas, migrations, multi-tenant data models, or polymorphic table structures.
How to install DB Schema Architect
Installs to ~/.claude/agents/nonlinear-xyz-factory-kit-db-schema-architect.md
mkdir -p ~/.claude/agents && curl -fsSL https://raw.githubusercontent.com/nonlinear-xyz/factory-kit/HEAD/agents/db-schema-architect.md -o ~/.claude/agents/nonlinear-xyz-factory-kit-db-schema-architect.md Restart Claude Code, or start a new session, for it to be picked up.
What DB Schema Architect does
name: db-schema-architect description: Use when designing or modifying database schemas, migrations, multi-tenant data models, or polymorphic table structures. Carries the factory's data-layer conventions — Drizzle with domain-partitioned schema modules, `_shared.ts` with `timestamps` helper and `pgTableCreator`, org-keyed FKs with cascade delete, JSONB envelope for non-query-driving data, polymorphic table patterns (shared base + variant tables), schema-derived type exports, ESLint Drizzle
Alternatives in Data & AI
- Migration Agent — Creates safe, reversible database migrations with proper indexes, constraints, and zero-downtime strategies 652 ★
- Module Migration — Use this agent to create, review, or fix database migrations for LaraDashboard modules — handles table creatio 407 ★
- Reverse SQL Function Analyst — Spécialiste des FONCTIONS SQL (scalaires, inline, table) du reverse base de données 193 ★
Full documentation available on GitHub
View Source RepositoryRelated Agents
Database Agent
Use this agent when you need to work with database operations, particularly Supabase databases. This includes:
LLM Workflow Engineer
Use when building LangGraph workflows, agents, RAG systems, structured-output nodes, streaming chat surfaces,
Sub Agent Architect
PROACTIVELY used when designing DB schemas, defining Prisma/Supabase structures, or establishing TypeScript ty
SQL Database
Use this agent when designing or optimizing the database layer of a Laravel app — "create a migration", "desig
DB Drizzle
Senior data engineer for 402Lab's PostgreSQL 16 + Drizzle ORM layer in apps/api — schema.ts, migrations under
Schema Architect
Translates OpenAPI specifications into Drizzle ORM schemas and Zod validation schemas. Use when generating dat
Related Skills
Tool Design Principles
Design effective JSON data structures and tool interfaces for the LLM Advisor. Activate when creating new data
Resolve Drizzle Migrations
Resolve Drizzle migration conflicts by accepting upstream and regenerating local migrations
Review Database
Review database - Drizzle migrations, schema drift, CI gates