database-skill

Manage database schema modifications and data migrations with TypeORM and db-migrate.

6|5|Updated Dec 16, 2022
One-click install
npx skills add https://github.com/6529-Collections/6529seize-backend --skill database-skill-6529-collections
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-skill
Source: https://github.com/6529-Collections/6529seize-backend/tree/main/.agentconf/skills/database-skill
Command: npx skills add https://github.com/6529-Collections/6529seize-backend --skill database-skill-6529-collections

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill streamlines the process of managing database changes, ensuring consistency and reliability in schema updates, data migrations, and application logic interacting with the database.

Core Features & Use Cases

  • Schema Management: Define and update database schemas using TypeORM entities.
  • Data Migration: Execute data migrations using the db-migrate tool.
  • Query Optimization: Implement efficient and typed database queries within repository patterns.
  • Use Case: When developing a new feature that requires adding new tables and columns to the database, use this skill to define the entities and create the necessary migrations.

Quick Start

Use the database-skill to create a new migration named 'add_user_email_index'.

Frequently Asked Questions about database-skill

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

FAQPage Schema
How do I manage database schema changes with TypeORM?

You can manage database schema changes by defining and updating schemas using TypeORM entities. This skill enforces strict rules for entity definitions to ensure consistency and reliability across schema updates and application logic.

What is the best way to run data migrations in a Node.js application?

The best way to run data migrations is using the db-migrate tool within a controlled environment. This skill executes data migrations while enforcing strict transaction management and migration execution rules for reliable database updates.

Does this database migration approach support Aurora MySQL?

Yes, this database migration approach supports Aurora MySQL and MySQL 8+. It provides a local development environment using Docker while enforcing repository patterns and transaction management for interacting with these database platforms.

How do I enforce strict transaction management during database migrations?

You enforce strict transaction management during database migrations by following the rules defined in this skill. It manages schema modifications and data migrations within a TypeORM and db-migrate environment, ensuring reliable transaction execution.

Why use repository patterns for database queries in TypeORM?

Using repository patterns for database queries in TypeORM implements efficient and typed data access. This skill enforces repository patterns to streamline database interactions and maintain consistency between application logic and schema definitions.

Can I use Docker for local database schema development?

Yes, you can use Docker for local database schema development. This skill supports Docker to provide a local development environment for managing MySQL 8+ and Aurora MySQL schema modifications and data migrations.