Individual skill
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.
plugins/databases-on-aws/skills/dsql/SKILL.md
Source commit fbefb3764e67558fe10ac834dd85db49734aa9b6
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- Yes
- Repository scan complete
- No
- Skill scan complete
- No
- Observed behavior
- Network or broad shell
- Last checked
- Nov 4, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 937
- Repository last updated
- Nov 5, 2026
- License
- Apache-2.0
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- agent-skills Repository topic
- agents Repository topic
- coding-agent-skills Repository topic
- coding-agents Repository topic
- agent-plugins Repository topic
- aws Repository topic
- data Derived category
- operations Derived category
- docs Derived category
- engineering Derived category
- data-databases Derived category
- engineering-web Derived category
Declared tags are partial or unavailable.
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Browse files
SKILL.mdcore · 28,554 bytesSKILL.mdcore · 28,554 bytesSKILL.mdcore · 28,554 bytesSKILL.mdcore · 28,554 bytesmcp/mcp-setup.mddoc · 6,852 bytesmcp/mcp-tools.mddoc · 2,020 bytesmcp/platforms/claude-code.mddoc · 3,701 bytesmcp/platforms/codex.mddoc · 1,667 bytesmcp/platforms/gemini.mddoc · 2,116 bytesmcp/platforms/kiro.mddoc · 2,888 bytesmcp/tools/database-tools.mddoc · 4,727 bytesmcp/tools/documentation-tools.mddoc · 1,317 bytesmcp/tools/input-validation.mddoc · 3,429 bytesmcp/tools/safe_query.pyruns · 10,654 bytesmcp/tools/workflow-patterns.mddoc · 3,214 bytesreferences/access-control.mddoc · 5,142 bytesreferences/auth/authentication-guide.mddoc · 4,685 bytesreferences/auth/connectivity-tools.mddoc · 8,958 bytesreferences/auth/scaling-guide.mddoc · 4,033 bytesreferences/data-loading.mddoc · 6,146 bytesreferences/ddl-migrations/batched-migration.mddoc · 2,530 bytesreferences/ddl-migrations/column-operations.mddoc · 5,371 bytesreferences/ddl-migrations/constraint-operations.mddoc · 6,847 bytesreferences/ddl-migrations/overview.mddoc · 4,941 bytesreferences/development-guide.mddoc · 9,794 bytesreferences/dsql-examples.mddoc · 1,565 bytesreferences/dsql-lint.mddoc · 11,049 bytesreferences/examples/connection.mddoc · 2,566 bytesreferences/examples/data-operations.mddoc · 3,013 bytesreferences/examples/migrations.mddoc · 1,620 bytesreferences/examples/patterns.mddoc · 5,634 bytesreferences/examples/schema.mddoc · 1,633 bytesreferences/foreign-keys.mddoc · 6,106 bytesreferences/language.mddoc · 8,837 bytesreferences/limits-and-error-codes.mddoc · 19,681 bytesreferences/mysql-migrations/ddl-auto-increment.mddoc · 4,375 bytesreferences/mysql-migrations/ddl-batching.mddoc · 1,052 bytesreferences/mysql-migrations/ddl-column-changes.mddoc · 1,313 bytesreferences/mysql-migrations/ddl-constraints.mddoc · 782 bytesreferences/mysql-migrations/ddl-operations.mddoc · 1,502 bytesreferences/mysql-migrations/ddl-structural.mddoc · 3,773 bytesreferences/mysql-migrations/ddl-type-alternatives.mddoc · 4,587 bytesreferences/mysql-migrations/full-example.mddoc · 7,518 bytesreferences/mysql-migrations/type-mapping.mddoc · 14,692 bytesreferences/occ-retry-patterns.mddoc · 9,783 bytesreferences/onboarding.mddoc · 14,100 bytesreferences/orm-guides/overview.mddoc · 11,147 bytesreferences/pg-migrations/index-conversion.mddoc · 16,056 bytesreferences/pg-migrations/multi-region.mddoc · 3,004 bytesreferences/pg-migrations/schema-objects.mddoc · 15,379 bytesreferences/pg-migrations/type-mapping.mddoc · 5,442 bytesreferences/query-plan/catalog-queries.mddoc · 8,180 bytesreferences/query-plan/guc-experiments.mddoc · 7,712 bytesreferences/query-plan/plan-interpretation.mddoc · 15,390 bytesreferences/query-plan/query-rewrites-dsql-specific.mddoc · 900 bytesreferences/query-plan/query-rewrites-generic.mddoc · 1,923 bytesreferences/query-plan/query-rewrites/cte-late-materialization.mddoc · 1,464 bytesreferences/query-plan/query-rewrites/flatten-union-all.mddoc · 946 bytesreferences/query-plan/query-rewrites/left-join-to-inner.mddoc · 794 bytesreferences/query-plan/query-rewrites/not-in-to-not-exists.mddoc · 1,476 bytesreferences/query-plan/query-rewrites/or-to-in.mddoc · 889 bytesreferences/query-plan/query-rewrites/propagate-filter.mddoc · 1,024 bytesreferences/query-plan/query-rewrites/push-computation-to-constant.mddoc · 1,027 bytesreferences/query-plan/query-rewrites/push-group-by-into-subquery.mddoc · 1,625 bytesreferences/query-plan/query-rewrites/reltuples-estimate.mddoc · 1,188 bytesreferences/query-plan/query-rewrites/split-large-joins.mddoc · 2,217 bytesreferences/query-plan/query-rewrites/subquery-unnesting-correlated.mddoc · 1,663 bytesreferences/query-plan/query-rewrites/subquery-unnesting-scalar.mddoc · 1,469 bytesreferences/query-plan/query-rewrites/subquery-unnesting-uncorrelated.mddoc · 1,403 bytesreferences/query-plan/report-format.mddoc · 11,118 bytesreferences/query-plan/workflow.mddoc · 9,627 bytesreferences/system-diagnostics/promql-patterns.mddoc · 8,849 bytesreferences/system-diagnostics/wait-events.mddoc · 13,981 bytesreferences/system-diagnostics/workflow.mddoc · 19,844 bytesreferences/troubleshooting.mddoc · 11,982 bytes
Read excerpt
# Amazon Aurora DSQL Skill
Aurora DSQL is a serverless, PostgreSQL-compatible distributed SQL database. This skill covers direct query execution via MCP tools, schema management, migrations, multi-tenant isolation, IAM auth, and bulk data loading via `aurora-dsql-loader`.
---
## Reference Files
Load these files as needed for detailed guidance:
### Core:
| Reference | When to Load | Contains |
| ----------------------------------------------------------------- | --------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------- |