Can it help with ORM-related performance issues?

Yes, it specializes in detecting N+1 query patterns in ORMs like Prisma, TypeORM, and SQLAlchemy, offering implementation patterns for eager loading and batching.

How does this skill help with slow SQL queries?

The skill analyzes execution plans to identify bottlenecks like full table scans or inefficient joins, then provides optimized query rewrites and specific indexing strategies to improve speed.

Can this skill help with database migrations?

Yes, it provides strategies for zero-downtime migrations, including schema versioning, large table refactoring, and rollback procedures for high-availability systems.

Does it support cloud-specific databases?

Absolutely. It includes specialized knowledge for optimizing AWS Aurora, DynamoDB, Azure SQL, and Google Cloud Spanner, focusing on both performance and cost reduction.

Database Optimizer

Name: Database Optimizer
Author: itsimonfredlingjack

byitsimonfredlingjack

0•

数据库管理

Optimizes database performance through advanced query tuning, strategic indexing, and scalable architecture design for modern data stacks.

The Database Optimizer skill transforms Claude into a senior database administrator and performance engineer capable of solving complex data bottlenecks. It provides expert-level guidance on execution plan analysis, N+1 query resolution, and the implementation of multi-tier caching architectures using Redis or Memcached. Whether you are refactoring legacy SQL for better throughput, designing a sharding strategy for global scale, or optimizing cloud database costs on AWS, Azure, or GCP, this skill offers proactive, production-ready patterns to ensure your data layer remains fast and efficient.

主要功能

01Automated detection and resolution patterns for N+1 query problems in popular ORMs.

020 GitHub stars

03Comprehensive execution plan analysis and query rewriting for SQL and NoSQL systems.

04Design of scalable architectures using horizontal partitioning, sharding, and read replicas.

05Strategic indexing recommendations including B-tree, GIN, GiST, and covering indexes.

06Cloud-native optimization for RDS, Aurora, DynamoDB, and BigQuery environments.

使用场景

01Designing zero-downtime migration strategies for large-scale production databases.

02Troubleshooting and fixing slow-running production queries using EXPLAIN ANALYZE.

03Refactoring application-level data fetching logic to reduce database round-trips.

主要功能

01Automated detection and resolution patterns for N+1 query problems in popular ORMs.

020 GitHub stars

03Comprehensive execution plan analysis and query rewriting for SQL and NoSQL systems.

04Design of scalable architectures using horizontal partitioning, sharding, and read replicas.

05Strategic indexing recommendations including B-tree, GIN, GiST, and covering indexes.

06Cloud-native optimization for RDS, Aurora, DynamoDB, and BigQuery environments.

使用场景

01Designing zero-downtime migration strategies for large-scale production databases.

02Troubleshooting and fixing slow-running production queries using EXPLAIN ANALYZE.

03Refactoring application-level data fetching logic to reduce database round-trips.