# Speed up slow SQL queries (/database--query-optimize)

/database--query-optimize is a Claude Code skill in the Data section. Analyzes a slow SQL or ORM query, spots missing indexes and N+1 problems, and suggests index and rewrite fixes.

- Web version: https://skills.sgomez.dev/en/s/database--query-optimize
- Section: [Data](https://skills.sgomez.dev/en/data.md)
- Author: Santiago Gómez de la Torre
- License: MIT
- Source: https://github.com/sgomez-dev/claude-skills/blob/main/skills/database/query-optimize.md
- Updated 26 Mar 2026

## How to ask for it

- `/database--query-optimize this SQL query takes 10 seconds, why?`
- `/database--query-optimize optimize this slow Prisma query`
- `/database--query-optimize review indexes for this reporting query`

## Install

macOS · Linux:

```
curl -fsSL https://raw.githubusercontent.com/sgomez-dev/claude-skills/main/install.sh | bash
```

Windows:

```
irm https://raw.githubusercontent.com/sgomez-dev/claude-skills/main/install.ps1 | iex
```

Claude Code plugin:

```
/plugin marketplace add sgomez-dev/claude-skills
/plugin install database-skills@claude-skills-collection
```

## Permissions

- Reads: `**/*`
- Writes: `**/*`
- Runs: —
- Network: No
- Destructive: No

## Author's description

Analyze and optimize slow SQL queries or ORM queries

- [How we review this](https://skills.sgomez.dev/en/methodology.md)