How does the skill handle database versioning?

It uses semver versioning that matches your project's package.json, ensuring that database changes are synchronized with your application's release cycle.

What is the difference between migrations.ts and procedures.ts?

migrations.ts is used for schema changes (DDL) like altering tables or adding indexes. procedures.ts is reserved for programmable objects like stored procedures, functions, and triggers.

Can I use this for non-PostgreSQL databases?

No, this skill is specifically optimized for PostgreSQL as used within the Aurora tools bounded context.

Do I need another skill to use aurora-tools-scripts?

Yes, this skill must be used together with the 'postgresql' skill. While this skill defines where and how to structure files, the postgresql skill defines how to write the actual SQL statements.

Does it support idempotent SQL scripts?

Yes, the skill enforces patterns like 'IF EXISTS' and 'IF NOT EXISTS' to ensure that scripts can be executed multiple times without causing errors.

Aurora Tools Database Manager

Name: Aurora Tools Database Manager
Author: avvale

byavvale

データベース管理

Manages PostgreSQL migrations, stored procedures, and triggers using standardized Aurora framework patterns.

概要

This skill streamlines the management of PostgreSQL database schemas and programmable objects within the Aurora ecosystem. It enforces strict naming conventions and file structures for migrations and procedures, ensuring consistency across development environments. By automating the generation of idempotent SQL scripts and handling complex patterns like rowId identity columns, it reduces the risk of deployment errors and simplifies the evolution of complex database architectures while working in tandem with the core PostgreSQL skill.

主な機能

Standardized SQL migration management for schema modifications (DDL)
Built-in support for the specialized Aurora 'rowId' identity column pattern
0 GitHub stars
Programmable object orchestration for stored procedures, functions, and triggers
Automated UUID generation and semver-based version tracking
Enforcement of Aurora-specific naming conventions and file structures

ユースケース

Standardizing database versioning across multiple environments using migrations.ts
Implementing and maintaining complex database triggers and business logic functions
Adding new columns, indexes, or constraints to existing PostgreSQL tables

概要

主な機能

Standardized SQL migration management for schema modifications (DDL)
Built-in support for the specialized Aurora 'rowId' identity column pattern
0 GitHub stars
Programmable object orchestration for stored procedures, functions, and triggers
Automated UUID generation and semver-based version tracking
Enforcement of Aurora-specific naming conventions and file structures

ユースケース

Standardizing database versioning across multiple environments using migrations.ts
Implementing and maintaining complex database triggers and business logic functions
Adding new columns, indexes, or constraints to existing PostgreSQL tables