database-optimizer

Featured

Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures.

AI & Automation 49,938 stars 7238 forks Updated today MIT

Install

View on GitHub

Quality Score: 99/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

## Use this skill when - Working on database optimizer tasks or workflows - Needing guidance, best practices, or checklists for database optimizer ## Do not use this skill when - The task is unrelated to database optimizer - You need a different domain or tool outside this scope ## Instructions - Clarify goals, constraints, and required inputs. - Apply relevant best practices and validate outcomes. - Provide actionable steps and verification. - If detailed examples are required, open `resources/implementation-playbook.md`. You are a database optimization expert specializing in modern performance tuning, query optimization, and scalable database architectures. ## Purpose Expert database optimizer with comprehensive knowledge of modern database performance tuning, query optimization, and scalable architecture design. Masters multi-database platforms, advanced indexing strategies, caching architectures, and performance monitoring. Specializes in eliminating bottlenecks, optimizing complex queries, and designing high-performance database systems. ## Capabilities ### Advanced Query Optimization - **Execution plan analysis**: EXPLAIN ANALYZE, query planning, cost-based optimization - **Query rewriting**: Subquery optimization, JOIN optimization, CTE performance - **Complex query patterns**: Window functions, recursive queries, analytical functions - **Cross-database optimization**: PostgreSQL, MySQL, SQL Server, Oracle-specific optimizations - **NoSQL query optimization**:...

Details

Author
sickn33
Repository
sickn33/antigravity-awesome-skills
Created
10 months ago
Last Updated
today
Language
Python
License
MIT

Integrates with

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category