Database Optimizer
by jeffallan1be15d8064f8MIT11K starsListed Oct 8, 2026Updated Oct 8, 2026Repository updated 5 days ago
Optimizes database queries and improves performance across PostgreSQL and MySQL systems. Use when investigating slow queries, analyzing execution plans, or optimizing database performance. Invoke for index design, query rewrites, configuration tuning, partitioning strategies, lock contention resolution.
Only the file list is public. File contents are available once the skill is installed in a workspace.
| Path | Size | Type |
|---|---|---|
| references/index-strategies.md | 7.9 KB | text/markdown |
| references/monitoring-analysis.md | 14.3 KB | text/markdown |
| references/mysql-tuning.md | 10.8 KB | text/markdown |
| references/postgresql-tuning.md | 10 KB | text/markdown |
| references/query-optimization.md | 5.7 KB | text/markdown |
| SKILL.md | 6.1 KB | text/markdown |
Source and attribution
Source:jeffallan/claude-skillsinskills/database-optimizerat commit1be15d8
License: MIT
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More from jeffallan/claude-skills
Wordpress Pro
jeffallan
Guides WordPress theme, plugin, Gutenberg block, and WooCommerce development with security and performance practices.
Vue Expert Js
jeffallan
Builds Vue 3 apps in JavaScript only, using JSDoc annotations instead of TypeScript.
The Fool
jeffallan
Applies five structured critical-reasoning modes to stress-test ideas, plans, and decisions.
Swift Expert
jeffallan
Guides Swift 5.9+ development for Apple platforms, covering SwiftUI, async/await, actors, protocols and testing.
Sql Pro
jeffallan
Guides SQL query optimization, database schema design, and performance troubleshooting across major dialects.
Spring Boot Engineer
jeffallan
Guides Spring Boot 3.x backend implementation: REST controllers, JPA data access, Security 6, WebFlux and testing.
More in Data & Analytics
Content Strategy
anthropics
Turns PayPal, QuickBooks or Square sales data into a prioritized 30-day content brief for small businesses.
Cash Flow Snapshot
anthropics
Builds a 30/60/90-day cash flow forecast with confidence bands and named risk flags from ledger, payment or CSV data.
Pipeline Review
anthropics
Reviews CRM sales pipeline health by stage, flagging aging, stale and at-risk deals and checking coverage.
Metrics Review
anthropics
Reviews product metrics, analyzes trends against targets, and produces a scorecard with recommended actions.
Performance Report
anthropics
Builds marketing performance reports with key metrics, trend analysis, wins and misses, and prioritized optimization recommendations.
People Report
anthropics
Generates HR people-analytics reports on headcount, attrition, diversity, and org health from workforce data.