# Optimize Database Performance and Scalability

Slow queries and weak database designs can raise latency, cost, and operational risk. This skill provides evidence-based guidance for queries, indexes, caching, scaling, migrations, and monitoring.

## Install

```bash
npx skillstore add sickn33/database-optimizer
```

## Metadata

- Status: approved
- Slug: sickn33-database-optimizer
- Skillstore revision: r2
- Version status: missing
- Tree hash: f60912549868997184c0875a005f14867fa4a485016741a5d8b00f630e82385c
- Author: sickn33
- GitHub username: sickn33
- License: MIT
- Repository: https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/database-optimizer
- Ref: f9e2c34b4f19c7f3e6b0a1e93227b5f77cc12526
- Supported tools: Claude, Codex, Claude Code
- Audit status: complete
- Agent install advisory: allowed
- Manual install advisory: allowed
- Artifact signature: available
- Audit attestation: unavailable
- Human verification: not\_verified
- Risk factors: external\_commands
- Quality score: 78
- Quality tier: bronze
- Public page: https://skillstore.pages.dev/skills/sickn33-database-optimizer
- Manifest: https://skillstore.pages.dev/api/skills/sickn33-database-optimizer/manifest

## Capabilities

- Analyzes execution plans and recommends query rewrites for relational, NoSQL, cloud, and specialized databases.
- Designs composite, covering, partial, full-text, spatial, and platform-specific indexing strategies.
- Diagnoses N\+1 queries and recommends batching, eager loading, DataLoader, or ORM changes.
- Proposes caching, partitioning, sharding, replication, connection pooling, and transaction improvements.
- Defines performance baselines, benchmarks, monitoring metrics, migration validation, and rollback criteria.

## Use Cases

- Resolve Production Query Latency: Review slow queries, execution plans, locks, and metrics to identify prioritized improvements with validation steps.
- Remove Application N\+1 Queries: Analyze ORM or GraphQL query patterns and design batching, eager-loading, or caching changes.
- Plan Database Growth: Compare partitioning, replicas, sharding, caching, and cloud scaling options against workload and cost requirements.

## Prompt Templates

### Review a Slow Query

```
Review this slow query for [database]. Explain likely bottlenecks and suggest safe improvements using [query, schema, and execution plan].
```

### Design an Index Strategy

```
Design indexes for [table schema] and [frequent queries]. Explain column order, expected benefits, write costs, and validation steps.
```

### Diagnose N\+1 Behavior

```
Diagnose N+1 behavior in [framework] using [query log]. Recommend batching or eager-loading changes and a regression test.
```

### Create a Scaling Roadmap

```
Create a phased scaling plan for [workload metrics], covering partitioning, replicas, caching, migration safety, observability, cost, and rollback criteria.
```

## Limitations

- Provides guidance only and does not connect to databases or apply changes.
- Recommendations depend on accurate schemas, query plans, workload metrics, and operational constraints.
- Platform-specific syntax and behavior require validation in a representative environment.
- The referenced detailed implementation playbook is not included in this package.

## Best Practices

- Capture latency, throughput, resource use, and execution plans before recommending changes.
- Test optimizations with representative data and load before production deployment.
- Document expected benefits, operational costs, monitoring signals, and rollback criteria.

## Anti Patterns

- Do not add indexes without checking workload frequency, selectivity, storage, and write overhead.
- Do not rewrite queries without comparing execution plans and measured results.
- Do not introduce caching, sharding, or denormalization before defining consistency and invalidation requirements.

## Security Audit

- Audited at: 2026-07-23T22:46:35.291\+00:00
- Summary: The static finding is a false positive because SKILL.md line 24 uses backticks only to format a Markdown path. No executable command, prompt injection, or semantic security threat was found.

## Stats

- Views: 102
- Downloads: 12
- Favorites: 1
- Popularity score: 0