// 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".
Automatically 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".
| 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_query