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.

referencesplatformsgemini.md

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

MCP Setup: Gemini

Part of MCP Server Setup. The skill PREFERS direct psql for ad-hoc DSQL queries (via scripts/psql-connect.sh) and the AWS MCP Server for AWS knowledge and AWS API access.

AWS MCP Server (recommended)

Follow the official setup guide at Setting up the AWS MCP Server for the Gemini-specific install command and config-file paths.

Choosing the Right Scope

Gemini offers 2 scopes: project (default) and user.

  1. Project-Scoped servers are only accessible from the project's root directory and added to the project configuration: .gemini/settings.json. Useful for project-specific tools that should stay within the codebase.
  2. User-Scoped servers are accessible from all projects you work on with the Gemini CLI and added to global configuration: ~/.gemini/settings.json.

Verification

gemini mcp list

You should see the AWS MCP Server listed and connected.

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