dsql

Migrate MySQL or PostgreSQL schemas to Aurora DSQL with IAM authentication.

19|3|Updated May 17, 2026
One-click install
npx skills add https://github.com/cline/skills --skill dsql
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dsql
Source: https://github.com/cline/skills/tree/main/skills/dsql
Command: npx skills add https://github.com/cline/skills --skill dsql

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

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.

Frequently Asked Questions about dsql

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I migrate PostgreSQL schemas to Aurora DSQL?

PostgreSQL schema migration to Aurora DSQL involves converting existing table definitions to DSQL-compatible structures and managing DDL operations. The workflow supports multi-tenant isolation patterns and ORM migration workflows for frameworks like Django, Hibernate, or Rails.

How do I optimize query plans and interpret EXPLAIN ANALYZE in Aurora DSQL?

Query plan diagnosis in Aurora DSQL requires interpreting EXPLAIN ANALYZE output to identify performance bottlenecks. You can apply targeted index strategies based on the diagnostic results to optimize distributed SQL query execution.

Can I use IAM authentication to connect my application to Aurora DSQL?

IAM authentication is supported for connecting applications to Aurora DSQL clusters. You can implement secure application integration using IAM credentials alongside optimistic concurrency control retry patterns for distributed database operations.

What is the best way to load bulk CSV or Parquet data into Aurora DSQL?

Loading bulk CSV, TSV, or Parquet data into Aurora DSQL is best handled using the aurora-dsql-loader utility. This tool enables efficient bulk data loading for serverless distributed SQL databases without manual pipeline construction.

Does Aurora DSQL support multi-tenant isolation patterns?

Aurora DSQL supports multi-tenant isolation patterns through specific schema designs and DDL operations. You can implement tenant isolation within the serverless distributed SQL database structure during the schema migration process.

Why do I need optimistic concurrency control retry patterns for Aurora DSQL?

Optimistic concurrency control retry patterns are required for Aurora DSQL to handle transaction conflicts in distributed environments. Implementing OCC retries ensures application resilience during concurrent writes to the serverless database.