Tooluck logoTooluck
SKILL.md

dsql

Agent skill fromawslabs/agent-plugins

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

How to install dsql

install dsql
# install the agent-plugins pack with the skills CLI
npx skills add awslabs/agent-plugins

# or add only this skill to Claude Code: copy the folder

plugins/databases-on-aws/skills/dsql/

# into

~/.claude/skills/dsql/ (all projects)

.claude/skills/dsql/ (one project)

plugins/databases-on-aws/skills/dsql/SKILL.md

Apache-2.0Full file
1# Amazon Aurora DSQL Skill
2
3Aurora 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`.
4
5---
6
7## Reference Files
8
9Load these files as needed for detailed guidance:
10
11### Core:
12
13| Reference | When to Load | Contains |
14| ----------------------------------------------------------------- | --------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------- |
15| [development-guide.md](references/development-guide.md) | ALWAYS before schema changes or DB operations | Best practices, DDL rules, transaction limits, foreign key constraints |
16| [foreign-keys.md](references/foreign-keys.md) | MUST load for foreign key operations or migrations | FK syntax, actions, validation, tenant keys |
17…

Excerpt shown under the repository's Apache-2.0 license.

More skills in agent-plugins

Keep exploring

Similar skill repositories

Newsletter

Join the Community

Subscribe to our newsletter for the latest news and updates