database-analyzer

Analyze and optimize database schemas and relationships

⭐0stars🔀0forks📁View on GitHub🕐Updated Jan 1, 2026⬇️1downloads

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.
namedatabase-analyzer
descriptionAnalyze 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