dsql
starsforks
How to install dsql?
awslabs/agent-plugins/dsql
$npx -y skills add awslabs/agent-plugins --skill dsqlBuild 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-t
SKILL.md
| 1 | # Amazon Aurora DSQL Skill |
| 2 | |
| 3 | 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`. |
| 4 | |
| 5 | --- |
| 6 | |
| 7 | ## Reference Files |
| 8 | |
| 9 | Load 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, app-layer referential integrity | |
| 16 | | [language.md](references/language.md) | MUST load for language-specific choices | Driver selection, DSQL Connectors, connection code | |
| 17 | | [access-control.md](references/access-control.md) | MUST load for roles, grants, or sensitive data | Scoped role setup, IAM-to-database role mapping | |
| 18 | | [troubleshooting.md](references/troubleshooting.md) | SHOULD load for errors or unexpected behavior | OCC errors, connection failures, cluster state errors, token expiry, DDL rejection causes | |
| 19 | | [dsql-examples.md](references/dsql-examples.md) | Load for implementation examples | Multi-tenant schema examples, batch operations, FK validation patterns, connection pooling | |
| 20 | | [onboarding.md](references/onboarding.md) | User requests "Get started with DSQL" | Interactive step-by-step guide | |
| 21 | | [occ-retry-patterns.md](references/occ-retry-patterns.md) | MUST load for OCC retry code or conflict mitigation | DSQL Connectors, manual retry pattern, idempotent design | |
| 22 | |
| 23 | ### MCP: |
| 24 | |
| 25 | | Reference | When to Load | Contains | |
| 26 | | --------------------------------------- | --------------------------------------------------------------- | ------------------------------------------------------------------ | |
| 27 | | [mcp-setup.md](mcp/mcp-setup.md) | Always for MCP server guidance | Setup instructions, 2 configuration options | |
| 28 | | [mcp-tools.md](mcp/mcp-tools.md) | For MCP tool syntax and examples | Tool parameters, [input validation](mcp/tools/input-validation.md) | |
| 29 | | [dsql-lint.md](references/dsql-lint.md) | MUST load before running `dsql_lint` or processing external SQL | Tool reference, fix statuses, unfixable error resolution | |
| 30 | |
| 31 | ### DDL Migrations: |
| 32 | |
| 33 | | Reference | When to Load | Contains | |
| 34 | | --------------------------------------------------------------------------------------------- | ------------------------------------------------------ | --------------------------------------- | |
| 35 | | [ddl-migrations/o |
People who liked this also viewed
6 picksType
- azure-storageAzure Storage Services including Blob Storage, File Shares, Queue Storage, Table Storage, and Data Lake. Answers questions about storage access tiers (hot, cool, cold, archive), when to use each tier,SkillsJul 2026
- supabase-postgres-best-practicesPostgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.SkillsJul 2026
- supabaseUse when doing ANY task involving Supabase. Triggers: Supabase products (Database, Auth, Edge Functions, Realtime, Storage, Vectors, Cron, Queues); client libraries and SSR integrations (supabase-js, SkillsJul 2026
- convex-quickstartCreates or adds Convex to an app. Use for new Convex projects, npm create convex@latest, frontend setup, env vars, or the first npx convex dev run.SkillsJul 2026
- convex-performance-auditAudits Convex performance for reads, subscriptions, write contention, and function limits. Use for slow features, insights findings, OCC conflicts, or read amplification.SkillsJul 2026
- convex-setup-authSets up Convex auth, identity mapping, and access control. Use for login, auth providers, users tables, protected functions, or roles in a Convex app.SkillsJul 2026
