dsql

Manage Aurora DSQL clusters with schema migrations and scoped IAM roles.

2|Updated Mar 29, 2026

Search Tags:#database #postgresql #serverless #migration #iam #aurora #dsql

Ready to run

npx skills add https://github.com/NagyVikt/codex-plugins --skill dsql-nagyvikt

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: dsql
Source: https://github.com/NagyVikt/codex-plugins/tree/main/plugins/aws/databases-on-aws/skills/dsql
Command: npx skills add https://github.com/NagyVikt/codex-plugins --skill dsql-nagyvikt

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires uv, psql, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This skill addresses the complexity of managing serverless, distributed SQL databases by providing a unified interface for schema management, migration, and secure database interactions.

Core Features & Use Cases

Database Operations: Execute ad-hoc queries and DDL/DML statements directly via MCP tools.
Migration Support: Follows safe, batched migration patterns for schema evolution and MySQL-to-DSQL transitions.
Multi-tenant Security: Implements robust tenant isolation and scoped IAM-based role access control.

Quick Start

Use the dsql skill to list all tables in the current database using the readonly query tool.

Frequently Asked Questions about dsql

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

FAQPage Schema

How do I manage schema migrations for an Aurora DSQL cluster?▼

You can manage schema migrations for an Aurora DSQL cluster by executing structured DDL workflows and batched migration patterns via MCP tools. This facilitates safe schema evolution and supports MySQL-to-DSQL transitions.

How does IAM role scoping work for multi-tenant serverless PostgreSQL databases?▼

IAM role scoping for multi-tenant serverless PostgreSQL databases works by implementing structured tenant isolation and scoped role-based access controls. This ensures secure query execution and restricts data access to authorized tenant boundaries within the distributed SQL database.

Do I need an MCP server to execute transactional queries on Aurora DSQL?▼

Yes, you need to integrate with the Aurora DSQL MCP server to perform transactional database operations and documentation lookups. This connection is required to execute ad-hoc queries and DDL or DML statements securely.

Can I run ad-hoc queries on a serverless distributed SQL database using psql?▼

Yes, you can run ad-hoc queries on a serverless distributed SQL database using psql as a dependency. The skill leverages psql alongside uv to execute readonly queries and manage direct database interactions through MCP tools.

What is the best way to migrate data from MySQL to a serverless distributed SQL database?▼

The best way to migrate data from MySQL to a serverless distributed SQL database is by following safe, batched migration patterns. This approach supports structured schema evolution and ensures data integrity during the MySQL-to-DSQL transition process.