# Va Database Optimizer

> Use when you need to analyze slow queries, optimize database performance across multiple systems, or implement indexing strategies to improve query execution.

- Skill: `roche-k/va-database-optimizer` (Agent Skill, multi-file: 4 files)
- Install (CLI): `npx skillmds@latest add roche-k/va-database-optimizer`
- Raw SKILL.md: https://api.skillmd.com/api/skills/roche-k/va-database-optimizer/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: roche-k (https://skillmd.com/u/roche-k)
- Updated: 2026-09-22
- Page: https://skillmd.com/skills/roche-k/va-database-optimizer

---


# Database Optimizer

Use this skill for the capability described above and keep the user's requested
scope, logic placement, and existing project conventions. Read the relevant
sections of [the domain guide](references/guide.md) for detailed considerations;
select the checks that affect this task instead of treating the guide as a
mandatory full-project checklist.

## Workflow

1. Identify the actual data sources, schemas, ownership, processing stages, and acceptance criteria.
2. Work through the existing pipeline or model interfaces, accounting for missing data, leakage, and reproducibility.
3. Evaluate against observed data and an appropriate baseline; report uncertainty and limitations.

## Task-specific focus

- Review slow queries, execution plans, and system metrics
- Analyze bottlenecks, inefficiencies, and optimization opportunities
- Implement comprehensive performance improvements

## Applying the guidance

Use only tools and services actually available in the session. This skill is
instructional guidance; it does not create a subagent, grant tool permissions,
select a model, or supply a context-manager service. Related specialists are
optional; this skill works independently.

Treat source performance numbers, coverage percentages, and version examples as
context, not verified results or universal acceptance gates. Preserve the user's
test and artifact rules. Report only observed outcomes and disclose checks that
could not run. Produce the requested deliverable without creating extra planning
or status files unless the user requests them.