// Debug AWS RDS database issues by gathering infrastructure and database-level diagnostics. Use when user says "debug RDS", "RDS issues", "AWS database problems", or "check RDS health".
| name | aws-rds-debug |
| description | Debug AWS RDS database issues by gathering infrastructure and database-level diagnostics. Use when user says "debug RDS", "RDS issues", "AWS database problems", or "check RDS health". |
Debug AWS RDS PostgreSQL issues by inspecting AWS identity, EC2/security groups, database connections, locks, activity, and InScope docs.
| Input | Type | Default | Purpose |
|---|---|---|---|
environment | string | "stage" | Environment (stage, production) |
issue_description | string | "" | Description of the RDS issue |
check_connections | bool | true | Include connection and lock analysis |
persona_load("devops") — AWS and database toolscheck_known_issues("rds"), check_known_issues("aws"), check_known_issues("psql")aws_sts_get_caller_identity() — verify AWS identityaws_configure_list() — check AWS configaws_ec2_describe_instances() — list EC2 (bastion, app servers)aws_ec2_describe_security_groups() — RDS access rulespsql_connections() — connection countpsql_activity() — current activitypsql_locks() — lock contentionpsql_size() — database sizepsql_query("SELECT datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit, tup_returned, tup_fetched FROM pg_stat_database WHERE datname NOT IN ('template0', 'template1') ORDER BY numbackends DESC;") — RDS diagnosticscurl_get(url) — RDS endpoint (adjust URL for environment)ssh_command(host, "echo tunnel_ok") — bastion tunnel checkinscope_query("How do I configure and debug RDS databases in {environment}?", assistant="app-interface")learn_tool_fix("aws_sts_get_caller_identity", "credentials expired", "AWS credentials expired", "Refresh with aws configure")learn_tool_fix("psql_connections", "connection refused", "Cannot connect to RDS", "Verify security groups and VPN")memory_session_log("AWS RDS debug ({environment})", "healthy=X, issues=Y, connections=Z")persona_load, check_known_issues, learn_tool_fix, memory_session_logaws_sts_get_caller_identity, aws_configure_list, aws_ec2_describe_instances, aws_ec2_describe_security_groupspsql_connections, psql_activity, psql_locks, psql_size, psql_querycurl_get, ssh_command, inscope_queryAutomatically fix CVE vulnerabilities in Python dependencies for downstream projects. Queries Jira for unresolved CVEs, filters already-fixed issues, updates Pipfile and Pipfile.lock using container-based pipenv lock, creates MRs, and updates Jira. Use when the user mentions CVEs, vulnerabilities, security fixes, CVE remediation, dependency security updates, or asks to fix CVEs.
Add a new project to config.json with auto-detection and validation. Detects settings from directory, validates GitLab/Jira access, optionally configures Quay/Bonfire, generates initial knowledge. Use when user says "add project", "configure new repo".
Configure VMs with Ansible playbooks and ad-hoc commands. Run playbooks, install Galaxy roles, ad-hoc modules, inventory management, check mode. Use when configuring VMs or running Ansible against hosts.
Run smoke tests against API endpoints to verify availability and performance. Use after deploy_to_ephemeral, release_to_prod, or when debugging API connectivity.
Validate app-interface configuration and release readiness. Validates YAML, compares refs to live cluster, shows quotas, pending MRs. Use when user says "check app-interface", "app-interface validation".
Attach the current AI session context to a Jira issue as a formatted comment. Useful for investigation, audit trail, handoff, debugging. Use when user says "attach session to Jira", "document on Jira", or "export context to AAP-XXXXX".