Database Schema Optimizer
Analyze database schemas for performance issues and generate migration scripts
What You Can Do
Audit your entire database schema to detect structural inefficiencies that degrade performance. The skill identifies denormalization problems, missing or poorly designed indexes, N+1 query patterns, referential integrity risks, and partitioning opportunities—then generates executable migration code tailored to your database system (PostgreSQL, MySQL, or SQLite). You'll get prioritized recommendations that address both immediate bottlenecks and long-term design improvements.
Features
identifies redundant data and update anomalies caused by improper schema design
flags missing indexes and suggests optimal index strategies for query performance
spots inefficient query patterns and recommends eager-loading solutions
checks referential integrity and relationship constraints for data consistency
suggests table partitioning strategies for large datasets based on access patterns
produces executable SQL migration code for PostgreSQL, MySQL, or SQLite
quantifies expected query performance improvements from recommendations
provides application-level changes (eager loading, caching) alongside schema fixes
Example Output
Input: A user pastes their PostgreSQL schema with 8 tables, user and post relationships, and slow query logs.
Output:
## Critical Issues (Fix First)
1. Missing composite index on posts(user_id, created_at) — estimated 340% query speedup
Migration: CREATE INDEX idx_posts_user_time ON posts(user_id, created_at);
2. N+1 pattern detected: Comments table missing user_id denormalization
Recommendation: Add user_id + username columns to comments for eager-loading
Migration script provided with backfill strategy
## Schema Improvements
- Normalize 'user_roles' (currently comma-separated in users table)
- Partition posts table by year on created_at (current: 45M rows)
## Generated Migrations
[Full executable migration scripts with rollback procedures]
What's Included
- SKILL.md: core analyzer instructions and schema assessment framework
- Schema audit template: structured checklist for database analysis
- Migration script templates: boilerplate SQL for PostgreSQL, MySQL, SQLite
- N+1 detection patterns: code examples and eager-loading strategies
- Index design worksheet: step-by-step guide for evaluating indexing strategies
Who It's For
- Database administrators managing legacy systems or performance issues
- Backend engineers optimizing application database performance
- Technical architects designing schemas for new systems
- DevOps engineers planning database infrastructure upgrades
- Data engineers working with OLTP systems requiring query optimization
Best For
- Legacy database health assessments and performance audits
- Identifying root causes of slow queries before profiling individual statements
- Pre-production schema validation and optimization
- N+1 query detection and eager-loading strategy planning
- Migration planning for database refactoring and scaling
You might also like
You can systematically diagnose database performance bottlenecks by sharing your schema, slow query logs, and execution plans with Claude. It identifies root causes—missing indexes, inefficient joins, lock contention—and provides prioritized recommendations with ready-to-implement SQL. Skip the manual log analysis and get tuning strategies tailored to your workload.
Use Claude to systematically analyze your database queries, execution plans, and schema to identify performance bottlenecks. The skill generates actionable optimization recommendations with SQL rewrites, index strategies, and configuration tuning. You'll receive detailed before-and-after performance analysis to validate improvements and prioritize work by impact.
Rapidly analyze firmware logs and diagnose hardware issues that cause device failures, connectivity problems, and performance degradation. You'll identify root causes from stack traces, crash dumps, and sensor data, then generate specific optimization recommendations. This skill transforms raw device logs into actionable debugging plans that reduce time-to-resolution from hours to minutes.
You'll develop systematic approaches to injectable formulation design, from API selection through sterilization strategy. Claude helps you troubleshoot failed batches by analyzing root causes, recommends regulatory pathways (505(b)(2), ANDA, NDA), and provides science-backed solutions for stability, compatibility, and manufacturability challenges.
You'll design and implement mobile features with architectural rigor, cross-platform considerations, and edge-case handling built-in. This skill generates complete system designs, platform-specific implementation strategies, performance optimization approaches, and testing frameworks. The output is production-ready guidance spanning iOS and Android with security, offline resilience, and deployment strategies included.
Claude analyzes your code diffs and generates standardized commit messages that follow the Conventional Commits specification. The skill automatically determines the correct commit type, scope, and description based on the changes you've made, ensuring your messages are parseable by automation tools while remaining human-readable for code reviewers.
You can transform raw text into structured, labeled datasets for machine learning, analysis, and research. This skill performs named entity recognition, sentiment classification, part-of-speech tagging, and dependency parsing—generating consistent, validated annotations at scale. Use it to prepare corpora, extract entities, classify documents, or perform linguistic analysis without manual annotation.
You can architect multi-node ROS control systems from scratch, including node design patterns, communication flows, and real-time constraints. You'll debug complex node interactions using publisher/subscriber analysis, service call tracing, and action server diagnostics. You can optimize motion controllers through PID tuning, trajectory planning validation, and performance profiling to achieve precise, responsive robotic behavior.