Design Database — Data skill for Claude Code
Design a database schema with ERD, migrations, and indexes for a given domain.
How to install Design Database
Installs to ~/.claude/commands/kumaran-is-claude-code-onboarding-design-database.md
mkdir -p ~/.claude/commands && curl -fsSL https://raw.githubusercontent.com/kumaran-is/claude-code-onboarding/HEAD/.claude/commands/design-database.md -o ~/.claude/commands/kumaran-is-claude-code-onboarding-design-database.md Restart Claude Code, or start a new session, for it to be picked up.
What Design Database does
description: Design a database schema with ERD, migrations, and indexes for a given domain argument-hint: "[domain or requirements]" allowed-tools: Bash, Read, Write, Edit disable-model-invocation: true
Design Database Schema
Design a complete database schema for the following domain:
**Domain / Requirements:** $ARGUMENTS
Steps
- Identify the core entities and their relationships
- Draw an ERD in Mermaid syntax
- Write Flyway migration SQL files (
V1__*.sql,V2__*.sql, etc
Alternatives in Data
- Arcgis To Portaljs — Migrate a whole ArcGIS Hub site (opendata.arcgis.com or a Hub Premium custom domain) into a PortalJS Arc porta 2.3k ★
- Aoci Code — Local-first MCP server + CLI in Go: a persistent, governed codebase index that distills code and database sche 443 ★
- Extraction Pipeline — Extraction Pipeline — Core Domain Logic — GenAI IDP Accelerator 295 ★
Full documentation available on GitHub
View Source RepositoryRelated Skills
Database Optimizer
Optimize SQL queries, design efficient indexes, and handle database migrations. Solves N+1 problems, slow quer
Rogue Database Engineering Skill
Expert database engineering for application data layers: schema and ERD design, relational modeling, indexing,
Agent Database Architect
Dispatch hub:database-architect — Expert database architect for schema design, query optimization, migrations,
Symfony Migrations
Create and manage Doctrine migrations for database schema changes
Symptomsync Data Change
Use when tasks change the data model or reminder plumbing in supabase/, database/, database/migrations/, or fr
Embedded Database
SQLite and DuckDB as application-embedded databases at production scale - PRAGMA discipline, schema migrations
Related Agents
14 Dba
Database schema, ERD, SQL, indexes, data dictionary, multi-tenancy strategy. Invoke after systems analyst defi
Migration Agent
Creates safe, reversible database migrations with proper indexes, constraints, and zero-downtime strategies. U
SQL Developer
Designs and owns the database schema — tables, relationships, constraints, indexes, migrations, query tuning a