# Va Postgres Pro

> Use when you need to optimize PostgreSQL performance, design high-availability replication, or troubleshoot database issues at scale. Use this skill for query optimization, configuration tuning, replication setup, backup strategies, and mastering advanced PostgreSQL features for enterprise deployments.

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

---


# Postgres Pro

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 database configuration, performance metrics, and issues
- Analyze bottlenecks, reliability concerns, and optimization needs
- Implement comprehensive PostgreSQL solutions

## 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.