aurora-tools-scripts

Manage PostgreSQL SQL migrations and stored procedures within the tools bounded context.

Updated Jan 26, 2023
One-click install
npx skills add https://github.com/avvale/aurora-back --skill aurora-tools-scripts
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: aurora-tools-scripts
Source: https://github.com/avvale/aurora-back/tree/main/.claude/skills/aurora-tools-scripts
Command: npx skills add https://github.com/avvale/aurora-back --skill aurora-tools-scripts

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the management of database schema changes and stored logic for PostgreSQL, ensuring consistency and maintainability.

Core Features & Use Cases

  • SQL Migrations: Define and apply schema changes (DDL) like adding columns, indexes, or constraints.
  • Stored Logic: Create and manage stored procedures, functions, and triggers for complex database operations.
  • Use Case: When adding a new feature that requires a new table and a function to populate it, use this skill to define both the table structure (migration) and the function logic (procedure).

Quick Start

Use the aurora-tools-scripts skill to create a new migration for adding a 'status' column to the 'tasks' table.

Frequently Asked Questions about aurora-tools-scripts

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

FAQPage Schema
How do I manage PostgreSQL migrations and stored procedures together?

You can manage PostgreSQL migrations and stored procedures together by defining schema changes and programmable objects within specific file structures to ensure consistency and maintainability across your database bounded context.

What is the best way to create a PostgreSQL migration for adding a new column?

The best way to create a PostgreSQL migration for adding a new column is to define the DDL schema change using the required file structures and object definitions to apply the update consistently.

Can I use this approach to manage both database triggers and sequences in PostgreSQL?

Yes, you can manage database triggers and sequences in PostgreSQL because the skill handles triggers for creating migrations, procedures, functions, triggers, and sequences within its bounded context.

When do I need to define file structures for SQL schema changes?

You need to define specific file structures for SQL schema changes when adding new features that require tables, functions, or DDL modifications, ensuring object definitions maintain schema consistency and maintainability.

Does this method support creating stored logic like functions and triggers for complex database operations?

Yes, this method supports creating stored logic like functions and triggers for complex database operations by managing programmable objects alongside DDL migrations to streamline logic deployment.

Why use a specific bounded context for managing database schema changes and stored logic?

Using a specific bounded context for managing database schema changes and stored logic enforces adherence to specific file structures and object definitions, ensuring schema changes and programmable objects remain consistent and maintainable.