Setup & Installation
openclaw skills install @alirezarezvani/database-designer
Or with the ClawHub CLI, for registry-managed skill folders outside a full OpenClaw workspace:
npx clawhub install database-designer
Version History
v2.1.1Mar 10, 2026 - Version note by skill developer:
v2.1.1: optimization, reference splits
What This Skill Does
Analyzes and optimizes database schemas through automated normalization detection, index gap analysis, and migration planning. Generates ERD diagrams from DDL and produces zero-downtime migration scripts with rollback support.
Combines schema analysis, index optimization, and migration planning in one workflow instead of using separate tools for each.
When to use it
- Detecting normalization violations in a legacy schema
- Generating an ERD diagram from existing DDL
- Planning a zero-downtime column type migration
- Finding missing indexes on foreign key columns
- Designing composite indexes for slow queries
Example Workflow
Here's how your AI assistant might use this skill in practice.
INPUT
User asks: Analyze this schema and suggest index improvements
AGENT
- 1Parses DDL to extract tables, columns, and existing constraints
- 2Runs normalization analysis and flags violations up to BCNF
- 3Identifies foreign keys and query patterns missing index coverage
- 4Models selectivity and query cost for proposed indexes
- 5Generates index creation statements with rationale
OUTPUT
List of recommended indexes with creation SQL, estimated performance impact, and notes on any redundant existing indexes