Name: schema
Author: asabocinski

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

Schema Command

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.

Install schema and it becomes one more candidate the router can pick - when it fits.

A listing is a routing target with a manifest: what it does, which domains it covers, what it costs and who publishes it. Once installed it sits beside your own models and tools, is scored like any other candidate for each request, and shows up in the trace when it wins. Ratings come from workspaces that installed it, one per account.

{ "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/asabocinski/bravo-edd", "path": ".codex/prompts/schema.md", "ref": "ae4c539580470e782ac67d2dc4a4eabe9fc68336", "url": "https://github.com/asabocinski/bravo-edd/blob/ae4c539580470e782ac67d2dc4a4eabe9fc68336/.codex/prompts/schema.md", "key": "asabocinski/bravo-edd/.codex/prompts/schema.md" } } }

schema

About

Schema Command

Usage

Examples

What This Command Does

Agent Delegation

KB Domains Used

Output

Install schema and it becomes one more candidate the router can pick - when it fits.

Use it

Manifest

Reviews