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.