aurora-dsql

SKILL.md

Amazon Aurora DSQL

Overview

Aurora DSQL is a serverless, PostgreSQL-compatible distributed SQL database. This skill provides direct database interaction via psql scripts and PostgreSQL drivers, schema management, migration support, multi-tenant patterns, and query-plan explainability.

Key capabilities:

Direct query execution via psql with generated IAM auth tokens (see scripts/psql-connect.sh)

Schema management with DSQL constraints (one DDL per transaction, async indexes)

Safe data migration (column-level, constraint-level, MySQL→DSQL)

Multi-tenant isolation via tenant_id + parameterized SQL

IAM-based authentication with a 15-minute token expiry

Query-plan diagnosis for slow queries (EXPLAIN ANALYZE + GUC experiments)

The recommended runtime is psql with aws dsql generate-db-connect-auth-token for IAM-authenticated sessions. Application code SHOULD use the language-specific DSQL Connectors and SDKs. For AWS knowledge lookups (service docs, AWS API calls), the AWS MCP Server is the preferred MCP integration.