Aws Dsql

🌐Community
by awslabs · vlatest · Repository

Provides AWS guidance and assistance for deploying and managing cloud infrastructure.

Install on your platform

We auto-selected Claude Code based on this skill’s supported platforms.

1

Run in terminal (recommended)

terminal
claude mcp add aws-dsql npx -- -y @trustedskills/aws-dsql
2

Or manually add to ~/.claude/settings.json

~/.claude/settings.json
{
  "mcpServers": {
    "aws-dsql": {
      "command": "npx",
      "args": [
        "-y",
        "@trustedskills/aws-dsql"
      ]
    }
  }
}

Requires Claude Code (claude CLI). Run claude --version to verify your install.

About This Skill

What it does

The aws-dsql skill enables AI agents to execute SQL queries directly against Amazon DynamoDB tables. It allows for retrieving, inserting, updating, and deleting data within your DynamoDB environment using standard SQL syntax. This provides a familiar interface for interacting with NoSQL data stores.

When to use it

  • Data Extraction: Retrieve specific datasets from DynamoDB based on complex criteria that are difficult to express in the native DynamoDB API.
  • Reporting & Analytics: Generate reports and perform analyses by querying and aggregating data stored within DynamoDB tables.
  • Data Migration/Transformation: Modify or transform data residing in DynamoDB using SQL-based operations.
  • Automated Tasks: Automate routine database tasks, such as updating records based on specific triggers or events.

Key capabilities

  • SQL query execution against DynamoDB
  • Support for standard SQL syntax (SELECT, INSERT, UPDATE, DELETE)
  • Access to data stored in Amazon DynamoDB tables

Example prompts

  • "Show me all users with a status of 'active'."
  • "Update the price of product ID 123 to $9.99."
  • "Delete all orders older than one year."

Tips & gotchas

  • Ensure your AI agent has appropriate AWS credentials and permissions configured to access DynamoDB tables.
  • DynamoDB's schema-less nature might require careful consideration of data types when translating SQL queries.

Tags

🛡️

TrustedSkills Verification

Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.

Security Audits

Gen Agent Trust HubPass
SocketPass
SnykPass

Details

Version
vlatest
License
Author
awslabs
Installs
8

🌐 Community

Passed automated security scans.