Design and visualize database schemas with normalization guidance, relationship mapping, and ERD generation
Installation
npx claude-plugins install @jeremylongshore/claude-code-plugins-plus/database-schema-designer
Contents
Folders: commands, skills
Files: LICENSE, README.md
Documentation
Design and visualize database schemas with normalization guidance and ERD generation.
Installation
/plugin install database-schema-designer@claude-code-plugins-plus
Usage
/design-schema
Features
- Normalization Guidance: 1NF through BCNF
- ERD Generation: Mermaid diagram output
- Relationship Mapping: All relationship types
- Best Practices: Industry-standard patterns
- SQL Generation: Complete CREATE statements
Example
Describe your application, and receive a complete database schema with tables, relationships, indexes, and visualization.
License
MIT
Included Skills
This plugin includes 1 skill definition:
designing-database-schemas
|
View skill definition
Database Schema Designer
This skill provides automated assistance for database schema designer tasks.
Prerequisites
Before using this skill, ensure:
- Required credentials and permissions for the operations
- Understanding of the system architecture and dependencies
- Backup of critical data before making structural changes
- Access to relevant documentation and configuration files
- Monitoring tools configured for observability
- Development or staging environment available for testing
Instructions
Step 1: Assess Current State
- Review current configuration, setup, and baseline metrics
- Identify specific requirements, goals, and constraints
- Document existing patterns, issues, and pain points
- Analyze dependencies and integration points
- Validate all prerequisites are met before proceeding
Step 2: Design Solution
- Define optimal approach based on best practices
- Create detailed implementation plan with clear steps
- Identify potential risks and mitigation strategies
- Document expected outcomes and success criteria
- Review plan with team or stakeholders if needed
Step 3: Implement Changes
- Execute implementation in non-production environment first
- Verify changes work as expected with thorough testing
- Monitor for any issues, errors, or performance impacts
- Document all changes, decisions, and configurations
- Prepare rollback plan and recovery procedures
Step 4: Validate Implementation
- Run comprehensive tests to v