Optimizes database performance and designs scalable architectures for SQL and NoSQL environments.
The Database Engineer skill equips Claude with specialized expertise in database architecture, performance tuning, and lifecycle management. It enables sophisticated handling of schema normalization, index optimization, and high-availability solutions across major platforms like PostgreSQL, MySQL, and MongoDB. Whether you are troubleshooting slow queries using execution plan analysis or planning a zero-downtime migration for large-scale data, this skill provides the domain-specific guidance and best practices needed to ensure data integrity and system scalability.
Key Features
0116 GitHub stars
02Expert schema design and normalization strategies
03High availability architecture including replication and failover
04Comprehensive migration planning for SQL and NoSQL databases
05Advanced query performance tuning and execution plan analysis
06Multi-engine support including PostgreSQL, MySQL, MongoDB, and Redis
Use Cases
01Refactoring complex SQL queries to eliminate performance bottlenecks and N+1 issues.
02Planning cross-database migrations such as MySQL to PostgreSQL with minimal downtime.
03Designing partitioning and sharding strategies for rapidly growing datasets.
