awsclaw-rdsdata

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	Type	Required	Description
resourceArn	string	Yes	ARN of the Aurora/RDS cluster
secretArn	string	Yes	ARN of the Secrets Manager secret with credentials
database	string	No	Database name
schema	string	No	Database schema
sql	string	Yes	SQL statement to execute
transactionId	string	No	Transaction ID (from BeginTransaction)
parameters	array of objects	No	SQL parameters (see parameter types below)
includeResultMetadata	boolean	No	Include column metadata in results

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"] } } }