database-optimizer
Optimizes database queries and improves performance across PostgreSQL
by jeffallanFree
Description
database-optimizer is an agent skill from the jeffallan claude-skills collection that helps a coding agent improve the performance of PostgreSQL and MySQL databases. It is used when investigating slow queries, analysing execution plans, designing index strategies, tuning configuration parameters, optimising schema design and partitioning, reducing lock contention and deadlocks, and improving cache hit rates and memory use. The skill's persona is a senior database specialist who works across several database systems and asks for evidence before changing anything. Its core workflow lists the steps the agent follows for a tuning task, and it points to reference material for the specific database and problem. It is useful for developers and database engineers who have a slow query or a memory problem and want a structured approach. It is listed on skills.sh, where the page shows install counts and GitHub stars for the collection. Its Gen Agent Trust Hub audit is marked as failing, which is listed in the FAQ, while Socket and Snyk pass. Install it with npx skills add https://github.com/jeffallan/claude-skills --skill database-optimizer.…
Highlights
- Slow query analysis
- Execution plan review
- Index strategy design
- Configuration tuning
- Partitioning and schema design
- Installs from skills.sh
Ratings & Reviews
No ratings yet
Be the first to rate database-optimizer.
People also visit
database-optimizer FAQ
What does this skill do?
It helps an agent improve performance on PostgreSQL and MySQL, from slow queries and execution plans to indexes and configuration.
Which databases does it cover?
PostgreSQL and MySQL.
What problems does it address?
Slow queries, index design, lock contention and deadlocks, cache hit rates, memory use, partitioning and schema design.
How do I install it?
Run npx skills add https://github.com/jeffallan/claude-skills --skill database-optimizer.
What are the security audit results?
skills.sh lists three audits: Gen Agent Trust Hub Fail, Socket Pass and Snyk Pass. A Warn or Fail is worth reading before you install.
How popular is it?
The page shows about 5.7K installs, and the claude-skills repository has 11.9K GitHub stars.
What are the best database-optimizer alternatives?
Popular alternatives to database-optimizer include postgres-pro, sql-pro and database-migrations. See all database-optimizer alternatives