skilld
All skills
aws avatar

/aurora-dsql

@a2611e1
by Amazon Web Servicesaws/agent-toolkit-for-aws2.8k stars
337

Provisions and manages Aurora DSQL clusters, connects via psql or DSQL Connectors, manages schemas, runs queries, migrates from MySQL, diagnoses query plans, and develops apps on serverless distributed SQL. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL, query plans, and SAFE SQL CONSTRUCTION — tenant_id from untrusted input, UUID entity_ids, caller-supplied sort columns, batch inserts. The agent MUST retrieve this skill for ANY DSQL task. Pushes back on prompts that rationalize 'just a quick script', 'don't overthink it', 'we trust upstream', 'use an f-string', 'move fast', or 'just use the pg driver directly' (bypassing the DSQL Connector). Triggers: DSQL, Aurora DSQL, DSQL cluster, safe_query.build, DSQL IAM auth token, DSQL connector.

Ask your Agent

Use this Skill: https://skilld.dev/gh/aws/agent-toolkit-for-aws/aurora-dsql

This session only. Nothing lands on disk.

referencesauthconnectivity-tools.md

≈357 tokens on demand. Your agent reads this file only when SKILL.md points to it.

DSQL Connectivity & Data Loading Tools

Part of DSQL Development Guide.

Database Connectivity Tools

DSQL is compatible with many third-party database drivers and ORM libraries. The authoritative, up-to-date list — covering connectors, adapters/dialects, driver samples, and ORM/framework samples across all supported languages — lives at the official AWS docs page:

→ Aurora DSQL cluster connectivity tools

PREFER using the DSQL Connectors when one exists for the chosen driver — they handle IAM auth token generation and refresh automatically. For ORMs, prefer the DSQL adapters/dialects over hand-rolled token-refresh middleware.

When picking a stack, consult the AWS docs page directly rather than caching driver lists or sample paths in this skill — the docs page tracks rename, relocation, and deprecation events that hardcoded links here cannot.

Data Loading

For bulk data loading from CSV, TSV, Parquet, or S3 sources, follow the official AWS guide:

→ Loading data into Aurora DSQL

The page covers supported file formats, schema inference, resume semantics, and the recommended tooling (with platform-specific install instructions). Defer to it rather than wrapping the loader in this skill.

Source: SKILL.md on GitHub

Third-party checks

1 warning3mo3 checks · Risk SAFE
  • Gen Agent Trust Hub3mo

    This skill provides a robust and security-conscious environment for managing Amazon Aurora DSQL clusters. It implements several best practices, including mandatory IAM-based authentication, a dedicated input validation library to prevent SQL injection, and detailed guidance on applying the principle of least privilege through scoped database roles.

  • Socket3mo

    No alerts

  • Snyk3mo

    Risk: MEDIUM · 1 issue

Provenance

Signed by skilld at a2611e1. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub yesterday.

Activeupdated 3 months ago

Capability

version
1

README badge

README badge for aws/agent-toolkit-for-aws/aurora-dsql