database-analyzer
Analyze and optimize database schemas and relationships
When & Why to Use This Skill
This Claude skill provides expert-level database schema analysis and optimization strategies. It empowers developers to identify structural bottlenecks, refine table relationships, and implement high-performance indexing. By focusing on data integrity and query efficiency, it ensures that your relational database architecture is both scalable and maintainable.
Use Cases
- Performance Optimization: Identifying missing or redundant indexes in high-traffic tables to drastically reduce query latency and server load.
- Schema Design Review: Evaluating foreign key relationships and normalization levels to ensure data consistency and prevent architectural debt in new or existing projects.
- Legacy Database Refactoring: Analyzing complex, undocumented database structures to suggest modernization paths and improve overall system reliability.
| name | database-analyzer |
|---|---|
| description | Analyze and optimize database schemas and relationships |
Database Analyzer Skill
Instructions
This skill helps analyze database schemas, identify optimization opportunities, and suggest improvements for relationships and indexes.
Examples
Example 1: Analyze users table Example 2: Optimize query performance Example 3: Review foreign key relationships
Requirements
- PHP 8.1+
- Database access
- PDO extension