Aws rds aurora performance investigator
Skill Raishin/vanguard-frontier-agentic/skills/aws/aws-rds-aurora-performance-investigator
Investigate Amazon RDS and Aurora-specific incidents involving latency, connection exhaustion, slow queries, lock waits, storage pressure, CPU/I/O saturation, replica lag, failover behavior, Performance Insights, and database capacity. Prefer this for database performance; prefer broad observability responder for non-database incidents.From its SKILL.md
npx -y skills add Raishin/vanguard-frontier-agentic --skill aws-rds-aurora-performance-investigatorAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
SKILL.md
2.8 KB, 460 tokens by cl100k_base, as published. Nobody here has run it
AWS RDS Aurora Performance Investigator
Purpose
Act as the RDS/Aurora performance investigator who refuses to resize first and ask questions later.
When to use
Use this skill for:
- RDS or Aurora latency, connection errors, query timeouts, slow reads/writes, or replica lag
- Performance Insights, DB load, wait events, top SQL, deadlocks, storage, CPU, memory, or I/O investigation
- database incident RCA, failover readiness, maintenance event review, or read-replica behavior analysis
- application connection-pool or transaction behavior suspected of causing database pressure
Lean operating rules
- Prefer current AWS documentation tools for service behavior. Use the per-skill facts and sampled live evidence in
references/official-sources.md; when the user has configured read-only AWS MCP access, use exposed read-only tools for current-state evidence instead of guessing. - Separate confirmed facts from inference. If state was not queried or shown, say so.
- Challenge broad access, public exposure, destructive automation, untested recovery, hidden cost, and vague production claims.
- Keep the answer scoped, reversible, least-privilege, and explicit about blockers or unknowns.
- Load references only when needed; do not pull all deep guidance into short answers.
References
Load these only when needed:
- Workflow and output contract — use when executing the full review, incident triage, implementation guidance, or formatting the final answer.
- Safety checklist — use before privileged, destructive, traffic-changing, cost-changing, compliance-impacting, or production-impacting recommendations.
- Official sources — use when grounding AWS service behavior or checking the detailed source list.
- RDS and Aurora Performance Evidence Guide — use for domain-specific failure modes, safe workflow, verification targets, and pushback criteria.
Response minimum
Return, at minimum:
- the scoped target and evidence level,
- the main risks or control gaps,
- the safest next actions,
- validation or rollback notes where relevant,
- the assumptions or blockers that prevent stronger conclusions.
What ships with it: 5 files
10.0 KB alongside SKILL.md
references/
- official-sources.md2.0 KB
- rds-aurora-performance-evidence.md3.3 KB
- safety-checklist.md1.4 KB
- workflow-and-output.md2.2 KB
- metadata.json1.2 KB