database-optimizer
Database Optimizer Skill
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: MongoDB aggregation pipelines, DynamoDB query patterns
- Cloud database optimization: RDS, Aurora, Azure SQL, Cloud SQL specific tuning
Modern Indexing Strategies
- Advanced indexing: B-tree, Hash, GiST, GIN, BRIN indexes, covering indexes
More from anton-abyzov/specweave
technical-writing
Technical writing expert for API documentation, README files, tutorials, changelog management, and developer documentation. Covers style guides, information architecture, versioning docs, OpenAPI/Swagger, and documentation-as-code. Activates for technical writing, API docs, README, changelog, tutorial writing, documentation, technical communication, style guide, OpenAPI, Swagger, developer docs.
45spec-driven-brainstorming
Spec-driven brainstorming and product discovery expert. Helps teams ideate features, break down epics, conduct story mapping sessions, prioritize using MoSCoW/RICE/Kano, and validate ideas with lean startup methods. Activates for brainstorming, product discovery, story mapping, feature ideation, prioritization, MoSCoW, RICE, Kano model, lean startup, MVP definition, product backlog, feature breakdown.
43kafka-architecture
Apache Kafka architecture expert for cluster design, capacity planning, and high availability. Use when designing Kafka clusters, choosing partition strategies, or sizing brokers for production workloads.
34docusaurus
Docusaurus 3.x documentation framework - MDX authoring, theming, versioning, i18n. Use for documentation sites or spec-weave.com.
29frontend
Expert frontend developer for React, Vue, Angular, and modern JavaScript/TypeScript. Use when creating components, implementing hooks, handling state management, or building responsive web interfaces. Covers React 18+ features, custom hooks, form handling, and accessibility best practices.
29reflect
Self-improving AI memory system that persists learnings across sessions in CLAUDE.md. Use when capturing corrections, remembering user preferences, or extracting patterns from successful implementations. Enables continual learning without starting from zero each conversation.
27