dsql
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, foreign key constraints, OCC retry patterns, ORM migration (Django/EF Core/Hibernate/Rails/SQLAlchemy), DDL operations, query plan explainability, system diagnostics via CloudWatch AAS, SQL compatibility validation, and bulk data loading. Load before answering DSQL limit or error-code questions; it has limits docs omit. 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.
- License
- Apache-2.0
Pinned to revision 4e8964e24a5a, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/dsql/SKILL.md
- skills/dsql/LICENSE
- skills/dsql/mcp/mcp-setup.md
- skills/dsql/mcp/mcp-tools.md
- skills/dsql/mcp/tools/database-tools.md
- skills/dsql/mcp/tools/documentation-tools.md
- skills/dsql/mcp/tools/input-validation.md
- skills/dsql/mcp/tools/safe_query.py
- skills/dsql/mcp/tools/workflow-patterns.md
- skills/dsql/references/access-control.md
- skills/dsql/references/auth/authentication-guide.md
- skills/dsql/references/auth/connectivity-tools.md
- skills/dsql/references/auth/scaling-guide.md
- skills/dsql/references/data-loading.md
- skills/dsql/references/ddl-migrations/batched-migration.md
- skills/dsql/references/ddl-migrations/column-operations.md
- skills/dsql/references/ddl-migrations/constraint-operations.md
- skills/dsql/references/ddl-migrations/overview.md
- skills/dsql/references/development-guide.md
- skills/dsql/references/dsql-examples.md
- skills/dsql/references/dsql-lint.md
- skills/dsql/references/examples/connection.md
- skills/dsql/references/examples/data-operations.md
- skills/dsql/references/examples/migrations.md
- skills/dsql/references/examples/patterns.md
- skills/dsql/references/examples/schema.md
- skills/dsql/references/foreign-keys.md
- skills/dsql/references/language.md
- skills/dsql/references/limits-and-error-codes.md
- skills/dsql/references/mysql-migrations/ddl-auto-increment.md
- skills/dsql/references/mysql-migrations/ddl-batching.md
- skills/dsql/references/mysql-migrations/ddl-column-changes.md
- skills/dsql/references/mysql-migrations/ddl-constraints.md
- skills/dsql/references/mysql-migrations/ddl-operations.md
- skills/dsql/references/mysql-migrations/ddl-structural.md
- skills/dsql/references/mysql-migrations/ddl-type-alternatives.md
- skills/dsql/references/mysql-migrations/full-example.md
- skills/dsql/references/mysql-migrations/type-mapping.md
- skills/dsql/references/occ-retry-patterns.md
- skills/dsql/references/onboarding.md
- skills/dsql/references/orm-guides/overview.md
- skills/dsql/references/pg-migrations/index-conversion.md
- skills/dsql/references/pg-migrations/multi-region.md
- skills/dsql/references/pg-migrations/schema-objects.md
- skills/dsql/references/pg-migrations/type-mapping.md
- skills/dsql/references/query-plan/catalog-queries.md
- skills/dsql/references/query-plan/guc-experiments.md
- skills/dsql/references/query-plan/plan-interpretation.md
- skills/dsql/references/query-plan/query-rewrites-dsql-specific.md
- skills/dsql/references/query-plan/query-rewrites-generic.md
- skills/dsql/references/query-plan/query-rewrites/cte-late-materialization.md
- skills/dsql/references/query-plan/query-rewrites/flatten-union-all.md
- skills/dsql/references/query-plan/query-rewrites/left-join-to-inner.md
- skills/dsql/references/query-plan/query-rewrites/not-in-to-not-exists.md
- skills/dsql/references/query-plan/query-rewrites/or-to-in.md
- skills/dsql/references/query-plan/query-rewrites/propagate-filter.md
- skills/dsql/references/query-plan/query-rewrites/push-computation-to-constant.md
- skills/dsql/references/query-plan/query-rewrites/push-group-by-into-subquery.md
- skills/dsql/references/query-plan/query-rewrites/reltuples-estimate.md
- skills/dsql/references/query-plan/query-rewrites/split-large-joins.md
- skills/dsql/references/query-plan/query-rewrites/subquery-unnesting-correlated.md
- skills/dsql/references/query-plan/query-rewrites/subquery-unnesting-scalar.md
- skills/dsql/references/query-plan/query-rewrites/subquery-unnesting-uncorrelated.md
- skills/dsql/references/query-plan/report-format.md
- skills/dsql/references/query-plan/workflow.md
- skills/dsql/references/system-diagnostics/promql-patterns.md
- skills/dsql/references/system-diagnostics/wait-events.md
- skills/dsql/references/system-diagnostics/workflow.md
- skills/dsql/references/troubleshooting.md
Every link opens the file at its source, pinned to the revision this page describes.