---
title: "Database Optimizer - Air Market"
description: "A query that used to be fine is now slow and the database is not telling you why. This digs into it: reads the plan, rewrites the query, works out which indexes would help. Reach for it when the app…"
canonical: "https://airmarket.ai/app/database-optimizer"
---

[Air Market](/) / [Data & Analytics](/category/data) / Database Optimizer

Skill by [Jeffallan](/@jeffallan)

# Database Optimizer

When a query got slow and you need to know why

## What this does

A query that used to be fine is now slow and the database is not telling you why. This digs into it: reads the plan, rewrites the query, works out which indexes would help. Reach for it when the app is fine but the database is the thing holding everything up.

### Top 3 things it does for you

- Investigate a slow query
- Read an execution plan
- Design the right indexes

## Information

**Database Optimizer at a glance**

|  |  |
| --- | --- |
| Kind | Skill |
| Publisher | [Jeffallan](/@jeffallan) |
| Category | [Data & Analytics](/category/data) |
| Works with | Agent Skills - an open standard supported by 40+ agents |
| Version | 1.1.1 |
| Size | 55 KB |
| Licence | MIT |
| Repository | [Jeffallan/claude-skills](https://github.com/Jeffallan/claude-skills/tree/5e8b6b8ff4007414f91f980771047b6136600c34/skills/database-optimizer) |
| GitHub stars | 11,146 (as of Nov 2026) |

## Security report

**Verified.** AIR scanned this exact version of Database Optimizer and flagged nothing. AIR's verdict: **safe**.

**What Database Optimizer's check was run against**

|  |  |
| --- | --- |
| Commit | 5e8b6b8ff4007414f91f980771047b6136600c34 |
| Content hash | 16f2607ed05d162aab3d7e19231c493e8738f94e4c8839277dd8e551ce26c2cc |
| Files read | [Browse the files at this exact commit](https://github.com/Jeffallan/claude-skills/blob/5e8b6b8ff4007414f91f980771047b6136600c34/skills/database-optimizer/SKILL.md) |

A scan is named by the exact content it read, not by a version number. A different version is a different artifact, and nothing here applies to a version AIR has not scanned.

[Read the full security report for Database Optimizer](/security/database-optimizer)

## About Database Optimizer

This optimizes database queries and improves performance on PostgreSQL and MySQL. Use it when investigating slow queries or analyzing execution plans.

It covers index design, query rewrites, configuration tuning, partitioning strategies, and resolving lock contention.

## What's inside

- SKILL.md - instructions
- references/index-strategies.md - reference
- references/monitoring-analysis.md - reference
- references/mysql-tuning.md - reference
- references/postgresql-tuning.md - reference
- references/query-optimization.md - reference

## Questions

### Is Database Optimizer safe to install?

AIR scanned this exact version of Database Optimizer and flagged nothing. AIR's verdict: safe. The verdict is named by the content that was read, at commit 5e8b6b8ff400, so it cannot drift onto a version nobody scanned. The full report is at https://airmarket.ai/security/database-optimizer.

### How do I install Database Optimizer?

Open https://airmarket.ai/app/database-optimizer on Air Market and use the install action: Air Market hands Claude a prompt naming this exact skill, and Claude sets it up. Source, pinned to the exact commit this listing describes: https://github.com/Jeffallan/claude-skills/tree/5e8b6b8ff4007414f91f980771047b6136600c34/skills/database-optimizer. Install from that link, not the branch.

## Related on Air Market

- [More Data & Analytics listings](/category/data)
- [Everything by Jeffallan](/@jeffallan)

---

Canonical URL: <https://airmarket.ai/app/database-optimizer>