database-optimizer
Optimizes database queries and improves performance across PostgreSQL and MySQL systems.
Source: Jeffallan
At a glance
- Best for
- Analyzing slow queries and execution plans
- Works with
- Claude Code
- Outcome
- Designing optimal index strategies
- Source
- Jeffallan/claude-skills
01 / Understand the skill
About database-optimizer
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.
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.
02 / Confirm the fit
Use database-optimizer when you need to
- Analyzing slow queries and execution plans
- Designing optimal index strategies
- Tuning database configuration parameters
- Optimizing schema design and partitioning
- Reducing lock contention and deadlocks
- Improving cache hit rates and memory usage
Check before installing
Compatible platforms
Claude Code
Best fit
Analyzing slow queries and execution plans
Review the source instructions if the required output differs from the formats described above.
Install and use
Compatible with Claude Code · Published by Jeffallan
Ready to add database-optimizer?
Use the published instructions below, then provide the required input and describe the result you need.
General instructions · Claude Code
npx -y skills add Jeffallan/claude-skills --skill database-optimizer --agent claude-code
Review the source repository and license before installing third-party skills.
Continue exploring
Similar skills
Writes and runs KQL against Azure Data Explorer (Kusto/ADX) for log, telemetry, and time-series analysis, with schema discovery and az CLI fallback.
Guides Azure Storage operations and decisions across Blob, Files, Queue, Table, and Data Lake, including access tiers, redundancy, lifecycle, and SDK usage.
Optimizes Snowflake query performance using query ID from history.
Optimizes SQL queries, designs database schemas, and troubleshoots performance issues.