SKILL.md
RDS OSS Advisor (MySQL, MariaDB, PostgreSQL)
Overview
Advisor for Amazon RDS on the open-source engines — MySQL, MariaDB, and PostgreSQL. Five decision areas:
- Instance creation — provision production-ready instances with best-practice defaults (latest version, Multi-AZ, encryption, Performance Insights, Secrets Manager password management)
- Upgrade planning — identify instance, enumerate targets, run live prechecks, flag plan regressions, surface pre/post checklists
- Commitment pricing — estimate RI and Database Savings Plan savings for steady workloads
- RDS Proxy evaluation — decide whether proxy is worth it, based on connection utilization and pinning risks
- Blue/Green deployments — plan low-downtime DDL or major upgrades, with DDL compatibility analysis
Produces cost estimates, precheck findings, and CLI commands. For instance creation, executes the create-db-instance call with production best practices. For upgrades, purchases, and switchovers — advisory only, never executes without explicit user confirmation.
Scoped to RDS open-source engines. For Aurora, use amazon-aurora. For Oracle, SQL Server, Db2, use the engine-specific skills.
The AWS MCP server is recommended for executing commands but is not required; all operations can also be performed via the AWS CLI.