databases-on-aws

v1.6.1

Expert database guidance for the AWS database portfolio. Design schemas, execute queries, handle migrations, and choose the right database for your workload.

CodexClaude Code1 skill3 MCP serversstdiostreamable-http

by Amazon Web ServicesApache-2.0856updated 3 days ago

Source

$ git clone https://github.com/awslabs/agent-plugins

Clone the source, then follow the repository's marketplace instructions for your runtime. The plugin root is plugins/databases-on-aws/ inside the repository.

Layout

plugins/databases-on-aws/

├── .codex-plugin/plugin.json
├── .claude-plugin/plugin.json
├── skills/dsql/SKILL.md
└── .mcp.json

Skills1

dsqlskills/dsql/SKILL.md

Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, diagnose cluster performance, load data, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL and PostgreSQL-to-DSQL schema conversion, FK replacement code generation, OCC retry patterns, ORM migration (Django/EF Core/Hibernate/Rails), DDL operations, query plan explainability, system diagnostics via CloudWatch AAS, SQL compatibility validation, and bulk data loading. Triggers on phrases like: DSQL, Aurora DSQL, distributed SQL database, serverless PostgreSQL-compatible database, migrate to DSQL, DSQL query plan, DSQL EXPLAIN ANALYZE, DSQL ENUM, DSQL foreign key, DSQL OCC retry, DSQL multi-region, DSQL JSONB, DSQL GIN index, load into DSQL, load CSV into DSQL, bulk load DSQL, aurora-dsql-loader, DSQL slow, DSQL performance, DSQL wait events, DSQL AAS.

MCP servers3

aurora-dsqlstdio

command: uvx
args: awslabs.aurora-dsql-mcp-server@latest
env.FASTMCP_LOG_LEVEL: ERROR

awsknowledgestreamable-http

url: https://knowledge-mcp.global.api.aws

cloudwatchstdio

command: uvx
args: awslabs.cloudwatch-mcp-server@latest
env.FASTMCP_LOG_LEVEL: ERROR
env.AWS_REGION: [your dsql cluster region, e.g. us-east-1 — must be a PromQL-enabled region]
env.AWS_PROFILE: [your aws profile name, e.g. default]

Manifests2

plugins/databases-on-aws/.codex-plugin/plugin.json

{
  "name": "databases-on-aws",
  "version": "1.6.1",
  "description": "Expert database guidance for the AWS database portfolio. Design schemas, execute queries, handle migrations, and choose the right database for your workload.",
  "author": {
    "name": "Amazon Web Services",
    "email": "aws-agent-plugins@amazon.com",
    "url": "https://github.com/awslabs/agent-plugins"
  },
  "homepage": "https://github.com/awslabs/agent-plugins",
  "repository": "https://github.com/awslabs/agent-plugins",
  "license": "Apache-2.0",
  "keywords": [
    "aws",
    "aurora",
    "database",
    "databases",
    "distributed-sql",
    "dsql",
    "iam-auth",
    "migration",
    "postgresql",
    "postgres",
    "schema",
    "serverless",
    "sql"
  ],
  "skills": "./skills/",
  "mcpServers": "./.mcp.json",
  "interface": {
    "displayName": "Databases on AWS",
    "shortDescription": "Design schemas, query data, and choose the right AWS database path.",
    "longDescription": "AWS database guidance for schema design, queries, migrations, and database selection, starting with Aurora DSQL workflows.",
    "defaultPrompt": [
      "Review this schema for Aurora DSQL fit.",
      "Plan a migration path to AWS databases.",
      "Help me use Aurora DSQL safely in this repo."
    ],
    "developerName": "Amazon Web Services",
    "category": "Database",
    "capabilities": [
      "Read",
      "Write"
    ],
    "websiteURL": "https://github.com/awslabs/agent-plugins",
    "privacyPolicyURL": "https://aws.amazon.com/privacy/",
    "termsOfServiceURL": "https://aws.amazon.com/service-terms/",
    "brandColor": "#FF9900"
  },
  "hooks": "./hooks/hooks.json"
}

plugins/databases-on-aws/.claude-plugin/plugin.json

{
  "author": {
    "name": "Amazon Web Services"
  },
  "description": "Expert database guidance for the AWS database portfolio. Design schemas, execute queries, handle migrations, and choose the right database for your workload.",
  "homepage": "https://github.com/awslabs/agent-plugins",
  "keywords": [
    "aws",
    "aurora",
    "database",
    "databases",
    "distributed-sql",
    "dsql",
    "iam-auth",
    "migration",
    "postgresql",
    "postgres",
    "schema",
    "serverless",
    "sql"
  ],
  "license": "Apache-2.0",
  "name": "databases-on-aws",
  "repository": "https://github.com/awslabs/agent-plugins",
  "version": "1.6.1"
}