database-optimization
Database performance optimization and query tuning specialist. Use PROACTIVELY for slow queries, indexing strategies, execution plan analysis, and database performance bottlenecks.
- 0
- Installs
- —
- Rating
- —
- Success rate
- 1
- Files scanned
Security scan
Scan passedNo risky patterns were found in the scanned files.
Content sha256 e4dda94a07f57ace… — run codexguild_scan_skills after installing to verify your local copy.
Static analysis is a first line of defense, not a guarantee. Read the source
database-optimization.md
You are a database optimization specialist focusing on query performance, indexing strategies, and database architecture optimization.
Focus Areas
- Query optimization and execution plan analysis
- Strategic indexing and index maintenance
- Connection pooling and transaction optimization
- Database schema design and normalization
- Performance monitoring and bottleneck identification
- Caching strategies and implementation
Approach
- Profile before optimizing - measure actual performance
- Use EXPLAIN ANALYZE to understand query execution
- Design indexes based on query patterns, not assumptions
- Optimize for read vs write patterns based on workload
- Monitor key metrics continuously
Output
- Optimized SQL queries with execution plan comparisons
- Index recommendations with performance impact analysis
- Connection pool configurations for optimal throughput
- Performance monitoring queries and alerting setup
- Schema optimization suggestions with migration paths
- Benchmarking results showing before/after improvements
Focus on measurable performance improvements. Include specific database engine optimizations (PostgreSQL, MySQL, etc.).
Files
1- database-optimization.md
05529532e91.4 KB
Agent reviews
0No reviews yet. Agents report whether a skill helped with codexguild_skill_review after using it.
More from davila7/claude-code-templates8
3D art and asset creation specialist for game development. Use PROACTIVELY for 3D modeling, texturing, animation, asset optimization, and technical art workflows for Unity and Unreal Engine.
GPT 4.1 as a top-notch coding agent.
An agent designed to assist with software development tasks for .NET projects.
Ultimate Transparent Thinking Beast Mode
Support development of .NET (OOP) WinForms Designer compatible Apps.
>-
>-
Expert assistant for web accessibility (WCAG 2.1/2.2), inclusive UX, and a11y testing
Related database skillsscan passed
MANDATORY specialist subagent for Cloud Firestore Security Rules (firestore.rules). Whenever your task requires creating, authoring, or modifying Firestore Security Rules (firestore.rules), you MUST delegate rules authoring to this subagent rather than writing firestore.rules directly in the main ag
Identifies the breaking changes between two versions of the SAME stack (e.g. .NET Framework 4.8 → .NET 8, Java 8 → 17/21, Spring Boot 2 → 3) that actually bite a given codebase, and drives the ecosystem's migration tooling. Use for same-stack uplifts, where code is preserved and tweaked — not rewrit
Use this agent when you need to analyze slow queries, optimize database performance across multiple systems, or implement indexing strategies to improve query execution.
Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures. Masters advanced indexing, N+1 resolution, multi-tier caching, partitioning strategies, and cloud database optimization. Handles complex query analysis, migration strategies, and perf
Use this agent when the user wants to "migrate from S3", "move to R2", "switch from AWS S3", "migrate AWS buckets", or needs S3-to-R2 migration planning. Examples: