Dsql
Skill Verified ActiveBuild with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.
To enable users to effectively manage and utilize Aurora DSQL for their database needs, from initial setup and querying to complex schema migrations and performance optimization.
Features
- Schema management and DDL operations
- Direct SQL query execution via MCP tools
- Data migration from MySQL and other sources
- Query plan analysis for performance tuning
- IAM authentication and role-based access control
Use Cases
- Managing Aurora DSQL database schemas and objects
- Executing ad-hoc SQL queries and transactions
- Migrating existing databases to Aurora DSQL
- Optimizing slow-running SQL queries
- Implementing multi-tenant patterns and access control
Non-Goals
- Automating Aurora DSQL cluster provisioning beyond initial setup
- General-purpose SQL linting for non-DSQL databases
- Providing development frameworks not directly related to database interaction
Installation
npx skills add awslabs/mcpRuns the Vercel skills CLI (skills.sh) via npx — needs Node.js locally and at least one installed skills-compatible agent (Claude Code, Cursor, Codex, …). Assumes the repo follows the agentskills.io format.
Quality Score
VerifiedTrust Signals
Similar Extensions
DBHub Database Query Guide
100Guide for querying databases through DBHub MCP server. Use this skill whenever you need to explore database schemas, inspect tables, or run SQL queries via DBHub's MCP tools (search_objects, execute_sql). Activates on any database query task, schema exploration, data retrieval, or SQL execution through MCP — even if the user just says "check the database" or "find me some data." This skill ensures you follow the correct explore-first workflow instead of guessing table structures.
Sql Optimization
100Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.
Migrate Create
99Create a new sequentially numbered database migration with up/down SQL files
Supabase Postgres Best Practices
99Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
Cloud Architect
100Designs cloud architectures, creates migration plans, generates cost optimization recommendations, and produces disaster recovery strategies across AWS, Azure, and GCP. Use when designing cloud architectures, planning migrations, or optimizing multi-cloud deployments. Invoke for Well-Architected Framework, cost optimization, disaster recovery, landing zones, security architecture, serverless design.
Migrate Validate
100Validate pending migrations for foreign key consistency, rollback safety, and best practices