What problem does it solve?
This Skill solves the complexity of adopting Aurora DSQL by providing comprehensive guidance on schema design, migrations, query optimization, and application integration for a serverless distributed SQL database.
Core Features & Use Cases
- Schema & Migration Management: Convert MySQL/PostgreSQL schemas to DSQL, handle DDL operations, and implement multi-tenant patterns.
- Query Optimization: Diagnose query plans, interpret EXPLAIN ANALYZE output, and apply index strategies.
- Application Integration: Connect using IAM auth, implement OCC retry patterns, and migrate ORMs (Django, Hibernate, Rails).
- Bulk Data Loading: Load CSV/TSV/Parquet files efficiently using aurora-dsql-loader.
Quick Start
Use the dsql skill to create a multi-tenant table with proper indexes and IAM authentication for your Aurora DSQL cluster.