database-designer

What This Skill Does

The Database Designer skill is a high-performance tool designed for architects and developers to streamline the lifecycle of database management. It acts as an expert consultant capable of performing deep-dive normalization analysis, recommending schema denormalization strategies, and optimizing index structures. The skill excels at identifying performance bottlenecks by analyzing schema definitions, proposing composite index strategies, and flagging redundant or unused indexes. Beyond structural analysis, it offers a robust framework for managing schema migrations, ensuring that changes follow the expand-contract pattern for zero-downtime deployments. It also provides automatic ERD generation via Mermaid syntax, making it easier to visualize complex data relationships and document architecture.

Installation

To integrate this skill into your OpenClaw environment, execute the following command in your terminal: clawhub install openclaw/skills/skills/alirezarezvani/database-designer Ensure your local agent has the necessary permissions to access your project workspace for schema file analysis.

Use Cases

• Legacy Schema Refactoring: Use the tool to normalize bloated legacy tables or identify missing foreign key constraints that lead to data integrity issues.
• Performance Tuning: Provide your slow-query logs and schema definitions to get actionable advice on index creation and partition strategies.
• CI/CD Pipeline Automation: Automate the generation of SQL migration scripts for feature branches, ensuring that column changes are handled safely.
• Architecture Documentation: Quickly generate ERD documentation for new hires or stakeholder presentations by piping your DDL through the tool.

Example Prompts

1. "Analyze this Postgres DDL schema. Identify any missing foreign key constraints and suggest a composite index strategy for the users and orders tables to speed up lookup performance."
2. "I am planning to rename a primary column in a table with 10 million rows. Create a zero-downtime migration plan using the expand-contract pattern."
3. "Convert the following schema snippet into a Mermaid ERD and explain any potential normalization improvements for the current structure."

Tips & Limitations

To get the best results, always provide the specific database dialect (e.g., PostgreSQL, MySQL, SQLite) you are targeting, as syntax for constraints and indexing varies significantly. While the tool provides expert recommendations, always validate generated migration scripts in a staging environment before executing them in production. The skill is optimized for structural design and migration planning; it does not replace the need for physical database tuning based on actual real-time query execution plans (EXPLAIN ANALYZE output). Ensure your schema files are clean and correctly formatted for the most accurate analysis.