Prompt file imported from ip2cloud/bravo-edd (.codex/prompts/schema.md). Copyright stays with the author.

Schema Command

Name: schema
Author: ip2cloud

Design data models interactively (star schema, Data Vault, SCD, normalization)

Usage

/schema <description-or-file>

Examples

/schema "Star schema for e-commerce analytics"
/schema "SCD Type 2 for customer dimension"
/schema "Data Vault for multi-source integration"
/schema requirements/data-model-spec.md

What This Command Does

Invokes the schema-designer agent
Analyzes your modeling requirements
Loads KB patterns from data-modeling and sql-patterns domains
Generates:
- Entity-relationship diagrams (ASCII)
- DDL statements for target platform
- Grain definition and cardinality analysis
- SCD strategy recommendations

Agent Delegation

Agent	Role
`schema-designer`	Primary — dimensional modeling, SCD, Data Vault
`dbt-specialist`	Escalation — when models need dbt implementation
`sql-optimizer`	Escalation — when index strategy is needed

KB Domains Used

data-modeling — dimensional modeling, SCD types, normalization, schema evolution
sql-patterns — DDL patterns, index strategies
data-quality — constraint enforcement

Output

The agent generates DDL, model documentation, and implementation recommendations for your target platform.

{ "prompt": "# Schema Command\n\n> Design data models interactively (star schema, Data Vault, SCD, normalization)\n\n## Usage\n\n```bash\n/schema <description-or-file>\n```\n\n## Examples\n\n```bash\n/schema \"Star schema for e-commerce analytics\"\n/schema \"SCD Type 2 for customer dimension\"\n/schema \"Data Vault for multi-source integration\"\n/schema requirements/data-model-spec.md\n```\n\n---\n\n## What This Command Does\n\n1. Invokes the **schema-designer** agent\n2. Analyzes your modeling requirements\n3. Loads KB patterns from `data-modeling` and `sql-patterns` domains\n4. Generates:\n - Entity-relationship diagrams (ASCII)\n - DDL statements for target platform\n - Grain definition and cardinality analysis\n - SCD strategy recommendations\n\n## Agent Delegation\n\n| Agent | Role |\n|-------|------|\n| `schema-designer` | Primary — dimensional modeling, SCD, Data Vault |\n| `dbt-specialist` | Escalation — when models need dbt implementation |\n| `sql-optimizer` | Escalation — when index strategy is needed |\n\n## KB Domains Used\n\n- `data-modeling` — dimensional modeling, SCD types, normalization, schema evolution\n- `sql-patterns` — DDL patterns, index strategies\n- `data-quality` — constraint enforcement\n\n## Output\n\nThe agent generates DDL, model documentation, and implementation recommendations for your target platform.", "variables": [], "notes": "Interactive schema design — delegates to schema-designer agent", "metadata": { "source": { "provider": "github-codex-prompts", "repository": "https://github.com/ip2cloud/bravo-edd", "path": ".codex/prompts/schema.md", "ref": "ae4c539580470e782ac67d2dc4a4eabe9fc68336", "url": "https://github.com/ip2cloud/bravo-edd/blob/ae4c539580470e782ac67d2dc4a4eabe9fc68336/.codex/prompts/schema.md", "key": "ip2cloud/bravo-edd/.codex/prompts/schema.md" } } }

schema

About

Schema Command

Usage

Examples

What This Command Does

Agent Delegation

KB Domains Used

Output

Use it

Manifest

Reviews