Awsclaw RDS Data

Run SQL and manage transactions via the Amazon RDS Data API for Aurora Serverless and RDS clusters with Data API enabled.

When to Use This Skill

Use this skill when the user:

• Wants to execute SQL queries against Aurora Serverless
• Needs to run SQL on RDS clusters with Data API enabled
• Wants to manage database transactions (begin, commit, rollback)
• Needs to run batch SQL operations
• Asks about the RDS Data API

Tool: RDSDataTool

Execute Amazon RDS Data API commands. ALWAYS provide params object.

Commands

ExecuteStatement

Execute a single SQL statement.

{
  "command": "ExecuteStatement",
  "params": {
    "resourceArn": "arn:aws:rds:us-east-1:123456789012:cluster:my-cluster",
    "secretArn": "arn:aws:secretsmanager:us-east-1:123456789012:secret:my-secret",
    "database": "mydb",
    "sql": "SELECT * FROM users WHERE age > :minAge",
    "parameters": [{ "name": "minAge", "value": { "longValue": 30 } }],
    "includeResultMetadata": true
  }
}

Parameters:

Parameter value types:

{ "name": "param1", "value": { "stringValue": "hello" } }
{ "name": "param2", "value": { "longValue": 42 } }
{ "name": "param3", "value": { "doubleValue": 3.14 } }
{ "name": "param4", "value": { "booleanValue": true } }
{ "name": "param5", "value": { "isNull": true } }
{ "name": "param6", "value": { "blobValue": "base64encoded..." } }
{ "name": "param7", "value": { "arrayValue": { "stringValues": ["a", "b"] } } }

BatchExecuteStatement

Execute a SQL statement with multiple parameter sets (batch insert/update).

{
  "command": "BatchExecuteStatement",
  "params": {
    "resourceArn": "arn:aws:rds:...",
    "secretArn": "arn:aws:secretsmanager:...",
    "database": "mydb",
    "sql": "INSERT INTO users (name, age) VALUES (:name, :age)",
    "parameterSets": [
      [{ "name": "name", "value": { "stringValue": "Alice" } }, { "name": "age", "value": { "longValue": 30 } }],
      [{ "name": "name", "value": { "stringValue": "Bob" } }, { "name": "age", "value": { "longValue": 25 } }]
    ]
  }
}

Parameters:

BeginTransaction

Start a new database transaction.

{
  "command": "BeginTransaction",
  "params": {
    "resourceArn": "arn:aws:rds:...",
    "secretArn": "arn:aws:secretsmanager:...",
    "database": "mydb"
  }
}

Parameters:

Returns a transactionId to use with ExecuteStatement and CommitTransaction/RollbackTransaction.

CommitTransaction

Commit a transaction.

{
  "command": "CommitTransaction",
  "params": {
    "resourceArn": "arn:aws:rds:...",
    "secretArn": "arn:aws:secretsmanager:...",
    "transactionId": "abc123"
  }
}

Parameters:

RollbackTransaction

Roll back a transaction.

{
  "command": "RollbackTransaction",
  "params": {
    "resourceArn": "arn:aws:rds:...",
    "secretArn": "arn:aws:secretsmanager:...",
    "transactionId": "abc123"
  }
}

Parameters:

Related Services

• RDS Data → RDS: Use RDSTool DescribeDBClusters to find cluster ARNs and check if Data API is enabled (see awsclaw-rds skill)
• RDS Data → Secrets Manager: The secretArn parameter references a Secrets Manager secret containing database credentials
• RDS Data → Lambda: Lambda functions commonly use the Data API to access Aurora Serverless without managing connections
• RDS Data → CloudWatch: SQL query metrics and errors appear in CloudWatch