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, FK replacement code generation, OCC retry patterns, ORM migration (Django/EF Core/Hibernate/Rails), DDL operations, query plan explainability, system diagnostics via CloudWatch AAS, SQL compatibility validation, and bulk data loading. Triggers on phrases like: DSQL, Aurora DSQL, distributed SQ
Profile →npx skills add awslabs/agent-plugins --skill dsql --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
What it does
The skill orchestrates Aurora DSQL capabilities to manage schemas, run queries, handle migrations, diagnose query plans and cluster performance, load data, and support application development with a serverless, distributed SQL database. It covers IAM authentication, multi-tenant patterns, schema conversions, FK replacement code generation, OCC retry patterns, ORM migrations, DDL operations, query-plan explainability, and system diagnostics via CloudWatch AAS. It also provides bulk data loading using aurora-dsql-loader and validates SQL compatibility.
How it works
- Provides MCP tools for direct operations: readonly_query (execute SELECT), transact (execute DDL/DML in a transaction), get_schema (retrieve table structure).
- Offers dsql_lint to validate SQL for DSQL compatibility and optionally auto-fix issues.
- Includes documentation tools: dsql_search_documentation, dsql_read_documentation, dsql_recommend.
- Configures and guides usage across references for development, language, access control, troubleshooting, and various migrations (DDL, MySQL, PostgreSQL, ORM).
- Advises on connection paths: use aurora-dsql MCP tools when targeting the correct cluster; otherwise, use the CLI/psql path via scripts/psql-connect.sh.
- Exposes MCP setup and tools usage references, and AWS knowledge limits for operational planning.
When to use it
- When performing schema management, migrations, or query execution against Aurora DSQL.
- When validating SQL compatibility before external execution.
- When performing bulk data loading with aurora-dsql-loader.
- When diagnosing performance, wait events, or query plan explainability-related questions.
What it can touch
- Tools: readonly_query, transact, get_schema, dsql_lint, dsql_search_documentation, dsql_read_documentation, dsql_recommend.
- It references scripts/psql-connect.sh for CLI/psql path usage.
Caveats
- License: Apache-2.0.
- Must load referenced guidance before schema changes or DB operations; explicit references include development-guide.md, language.md, access-control.md, troubleshooting.md, dsql-examples.md, onboarding.md, occ-retry-patterns.md, mcp-setup.md, mcp-tools.md, and various migration and data-loading references.
- No assurances on outcomes beyond what is described in the MCP tools and references.
# 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 | | --------------------------------------------------------- | --------------------------------------------------- | ------------------------------------------------------------------------------------------ | | [development-guide.md](references/development-guide.md) | ALWAYS before schema changes or DB operations | Best practices, DDL rules, transaction limits, app-layer referential integrity | | [language.md](references/language.md) | MUST load for language-specific choices | Driver selection, DSQL Connectors, connection code | | [access-control.md](references/access-control.md) | MUST load for roles, grants, or sensitive data | Scoped role setup, IAM-to-database role mapping | | [troubleshooting.md](references/troubleshooting.md) | SHOULD load for errors or unexpected behavior | OCC errors,
- Reference Files
- Core:
- MCP:
- DDL Migrations:
- MySQL Migrations:
- PostgreSQL Migrations:
- ORM Guides:
- Data Loading:
- System Diagnostics:
- Query Plan Explainability:
- Choosing How to Connect: MCP vs CLI/psql
- MCP Tools Available
- AWS Knowledge MCP (awsknowledge)
- CLI Scripts Available
What does the dsql skill do?
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, FK replacement code generation, OCC retry patterns, ORM migration (Django/EF Core/Hibernate/Rails), DDL operations, query plan explainability, system diagnostics via CloudWatch AAS, SQL compatibility validation, and bulk data loading. Triggers on phrases like: DSQL, Aurora DSQL, distributed SQ
How do I install it?
Run `npx skills add awslabs/agent-plugins --skill dsql --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From awslabs/agent-plugins, a repository with 850 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.