skills.rest
awslabs
awslabsOFFICIAL
Explore all skills by this author →
WebsiteGitHub

distributed sql

Manage Amazon Aurora Distributed SQL databases for schema design, queries, and migrations.

9.6k|1.7k|Updated Mar 21, 2025
Search Tags:#database#migrations#multi-tenancy#schema management#sql#aurora dsql
One-click install
npx skills add https://github.com/awslabs/mcp --skill distributed-sql
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: distributed sql
Source: https://github.com/awslabs/mcp/tree/main/src/aurora-dsql-mcp-server/skills/distributed-sql-skill
Command: npx skills add https://github.com/awslabs/mcp --skill distributed-sql

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies the management of Amazon Aurora Distributed SQL (DSQL) databases, enabling efficient schema design, query execution, and data migration for scalable and distributed applications.

Core Features & Use Cases

  • Database Interaction: Execute SQL queries, manage schemas, and handle migrations directly.
  • Scalability & Multi-tenancy: Supports building applications that require high scalability and robust multi-tenant isolation patterns.
  • Use Case: Develop a new feature for a multi-tenant SaaS application by creating a new table with proper tenant isolation and indexing, ensuring data security and performance.

Quick Start

Use the distributed sql skill to create a new table named 'users' with columns 'user_id' and 'tenant_id' using the transact tool.

Frequently Asked Questions about distributed sql

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

FAQPage Schema
How do I manage schema migrations in Aurora DSQL?▼

Amazon Aurora DSQL supports scalable, distributed applications and multi-tenant architectures, providing high scalability through direct database interaction and robust tenant isolation patterns.

How do I create a multi-tenant table in a distributed SQL database?▼

You can execute SQL queries and manage schemas directly using the transact tool to create tables with required columns like 'user_id' and 'tenant_id' for tenant isolation.

Does Aurora DSQL require IAM-based authentication for database access?▼

Yes, Aurora DSQL requires IAM-based authentication to securely manage database interactions, ensuring access is controlled through AWS identity and access management policies.

What are the limitations when evolving schemas in Aurora DSQL?▼

Evolving schemas in Aurora DSQL requires adherence to DSQL constraints and specific migration patterns to ensure safe schema evolution without disrupting distributed applications.

Can I execute standard SQL queries directly against Aurora DSQL?▼

Yes, you can execute standard SQL queries directly against Aurora DSQL to manage schemas and handle data migrations efficiently through direct database interaction.

Related Skills

Explore More Software Engineering Skills→
NagyViktNagyVikt
2

dsql

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

Community
Advanced
awslabsawslabs
9.6k

dsql-skill

Manage Amazon Aurora DSQL schemas, queries, and migrations.

Official
Intermediate
awslabsawslabs
9.6k

distributed postgres

Manage Amazon Aurora DSQL databases with schema manipulation, queries, and migrations.

Official
Advanced
awslabsawslabs
9.6k

aurora dsql

Manage Amazon Aurora DSQL databases with schema definition, query execution, and migrations.

Official
Advanced