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 get Claude to analyze your API specifications and automatically generate bulletproof parameter validation logic. Claude creates security-hardened middleware, enforces type constraints, detects malicious input patterns, and generates comprehensive error handling — all tailored to your framework and existing codebase. The result is production-ready validation code with zero unvalidated inputs reaching your business logic.
This skill enables you to automatically audit your websites against compliance standards and detect deviations from expected baselines. You can track regulatory requirements, identify policy violations, and generate compliance reports with actionable remediation steps. Monitor multiple sites simultaneously and maintain detailed audit trails for compliance documentation.
Transform schema and data changes into production-ready migration packages that protect data integrity and minimize downtime. You can handle column additions, renames, type conversions, and backfills using proven patterns like expand-contract and shadow tables. The skill generates explicit rollback scripts, validation checklists, and phased execution plans that keep applications stable throughout the migration.
You'll transform high-level feature requirements into a complete development plan covering API design, frontend implementation, testing strategy, and documentation. The skill helps you identify dependencies, parallelize work across frontend and backend teams, and establish quality gates that ensure features ship bug-free with proper error handling and logging.
You can conduct comprehensive toxicology safety assessments, generate regulatory-compliant safety documentation, and produce detailed hazard analyses for pharmaceutical and chemical submissions. This skill structures toxicological data into standardized safety reports, maps findings to regulatory guidelines (FDA, EMA, ICH), and identifies risk characterization strategies to support regulatory submissions and approval timelines.
You can submit your Solidity smart contracts for comprehensive security analysis, vulnerability detection, and gas optimization recommendations. Claude reviews your code against known attack vectors, design patterns, and best practices—identifying reentrancy risks, overflow/underflow issues, access control flaws, and inefficient operations. You receive actionable fix recommendations with explanations of the security implications and gas savings potential.
You can design end-to-end NGS pipelines tailored to your experiment type (WGS, WES, RNA-seq, targeted), troubleshoot pipeline failures by analyzing QC metrics and logs, and optimize performance by fine-tuning parameters and identifying bottlenecks. This skill handles the full workflow from raw sequencing data quality assessment through variant interpretation and annotation.
You can accelerate your entire antenna design workflow—from initial concept to optimized specifications—by leveraging Claude's knowledge of electromagnetic theory, antenna types, and design trade-offs. Claude helps you parameterize designs, identify optimal configurations for your frequency band and application, and prepare detailed briefs for simulation and manufacturing. You'll generate design reviews, impedance-matching solutions, and validation checklists without context-switching to multiple tools.