Skip to content
Skills Library
DevOps & cloud · Analysis

aws-rds-debug

/aws-rds-debug

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

Repository
skills ↗
Licence
Apache-2.0
Last repository change
27.10.2026

Assessment and security

90/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content25 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
1
Scripts
0
HTML comments
0
URLs in SKILL.md
0
Deprecation

No signals detected. Repository changed on 27.10.2026, without references to retired models or APIs.

Licence

Apache-2.0, otwarta: można używać i zmieniać, z zachowaniem licencji i informacji o zmianach.

What it does and when to use it

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

Triggers from the description

debug RDSRDS issuesAWS database problemscheck RDS health
Original author 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".

How it works

  1. Inputs
  2. Workflow
  3. Key MCP Tools
  4. Report Sections
Original SKILL.md headings · 71 lines, 338 words
SKILL.md preview
---
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".
---

# AWS RDS Debug

Debug AWS RDS PostgreSQL issues by inspecting AWS identity, EC2/security groups, database connections, locks, activity, and InScope docs.

## Inputs

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

## Workflow

### 1. Bootstrap

- `persona_load("devops")` — AWS and database tools
- `check_known_issues("rds")`, `check_known_issues("aws")`, `check_known_issues("psql")`

### 2. AWS Infrastructure

- `aws_sts_get_caller_identity()` — verify AWS identity
- `aws_configure_list()` — check AWS config
- `aws_ec2_describe_instances()` — list EC2 (bastion, app servers)
- `aws_ec2_describe_security_groups()` — RDS access rules

### 3. Database Checks

- `psql_connections()` — connection count
- `psql_activity()` — current activity
- `psql_locks()` — lock contention
- `psql_size()` — database size
- `psql_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 diagnostics

### 4. Connectivity

- `curl_get(url)` — RDS endpoint (adjust URL for environment)
- `ssh_command(host, "echo tunnel_ok")` — bastion tunnel check

### 5. Documentation

- `inscope_query("How do I configure and debug RDS databases in {environment}?", assistant="app-interface")`

### 6. Analysis

- Check lock contention in locks output
- Parse connection count; flag if > 80
- Check xact_rollback in diagnostics; flag if > 1000
- Flag security group if 0.0.0.0/0 in ingress

### 7. Failure Learning

- "credentials expired" / "invalid" → `learn_tool_fix("aws_sts_get_caller_identity", "credentials expired", "AWS credentials expired", "Refresh with aws configure")`
- "connection refused" / "timeout" → `learn_tool_fix("psql_connections", "connection refused", "Cannot connect to RDS", "Verify security groups and VPN")`

### 8. Memory

- `memory_session_log("AWS RDS debug ({environment})", "healthy=X, issues=Y, connections=Z")`

## Key MCP Tools

- `persona_load`, `check_known_issues`, `learn_tool_fix`, `memory_session_log`
- `aws_sts_get_caller_identity`, `aws_configure_list`, `aws_ec2_describe_instances`, `aws_ec2_describe_security_groups`
- `psql_connections`, `psql_activity`, `psql_locks`, `psql_size`, `psql_query`
- `curl_get`, `ssh_command`, `inscope_query`

## Report Sections

- AWS Identity, Issues Found, Database Connections, Activity, Locks, Database Size, Statistics, Security Groups, RDS Docs, Known Issues

Versions

The database has no other skills named aws-rds-debug.

Database snapshot: 13.11.2026 · package version b284f024c24e (SHA-256 digest of the entire package)

Downloads in the last 30 days: 0 · ranking

Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.

Similar skills

  • 100rds-instance-setup
    Configure rds instance setup operations. Auto-activating skill for AWS Skills. Triggers on: rds instance setup, rds instance setup Part of the AWS Skills skill category. Use when working with rds instance setup functionality. Trigger with phrases like "rds instance setup", "rds setup", "rds".
  • 100rds
    AWS RDS relational database service for managed databases. Use when provisioning databases, configuring backups, managing replicas, troubleshooting connectivity, or optimizing performance.
  • 100aws-rds
    Provision and manage RDS databases. Configure backups, replication, and security. Use when deploying managed relational databases on AWS.
  • 100aws-rds
    Provision and manage RDS databases. Configure backups, replication, and security. Use when deploying managed relational databases on AWS.
  • 100aws-sdk-java-v2-rds
    Provides AWS RDS (Relational Database Service) management patterns using AWS SDK for Java 2.x. Use when creating, modifying, monitoring, or managing Amazon RDS database instances, snapshots, parameter groups, and configurations.
  • 90rds-aurora
    Deep-dive into Amazon RDS and Aurora database design, engine selection, high availability, and operations. This skill should be used when the user asks to "design an RDS database", "choose between RDS and Aurora", "configure Aurora Serverless", "set up read replicas", "plan a…

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.