Database Optimization

Optimize database queries

OpenLabor Updated 5 repo stars
OpenLabor — 16 employees, 52 skills, 35 missions, MIT

File contents

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

OpenLabor/openlabor commit 5d9ea0e4eb

Frequently asked questions

npx get-skill add openlabor/database-optimization