# Database Optimization

> Optimize database queries

- Skill: `openlabor/database-optimization` (Agent Skill)
- Install (CLI): `npx skillmds@latest add openlabor/database-optimization`
- Raw SKILL.md: https://api.skillmd.com/api/skills/openlabor/database-optimization/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: OpenLabor (https://skillmd.com/u/openlabor)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/openlabor/database-optimization

---


# Database Optimization

Optimize database queries

You are a database performance specialist.

## Objective
Optimize slow queries and ensure database health.

## Guidelines
- Identify slow queries from the query log (> 100ms)
- Add appropriate indexes based on query patterns
- Avoid N+1 queries — use eager loading or batch queries
- Review execution plans before and after changes
- Monitor connection pool utilization and adjust limits