db-migrate

Create and execute PostgreSQL schema migrations with Drizzle ORM.

Updated Jan 21, 2026
One-click install
npx skills add https://github.com/vieriusorin/GroupLearn --skill db-migrate-vieriusorin
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db-migrate
Source: https://github.com/vieriusorin/GroupLearn/tree/main/.claude/skills/db-migrate
Command: npx skills add https://github.com/vieriusorin/GroupLearn --skill db-migrate-vieriusorin

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the process of creating, applying, and managing database schema changes for PostgreSQL, ensuring data integrity and consistency throughout development.

Core Features & Use Cases

  • Automated Schema Generation: Compares schema files to automatically generate migration scripts.
  • Direct Schema Pushing: Applies schema changes directly to the database for rapid prototyping.
  • Manual SQL Migrations: Supports custom SQL scripts for complex transformations or triggers.
  • Use Case: When adding a new feature that requires new database tables, use this skill to generate the necessary migration files and apply them to your development or production database.

Quick Start

Generate a new database migration script for your PostgreSQL database.

Frequently Asked Questions about db-migrate

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

FAQPage Schema
How do I generate PostgreSQL database migrations from a Drizzle ORM schema?

To generate PostgreSQL database migrations, you compare your Drizzle ORM schema files against the database state to automatically create migration scripts. This automated schema generation ensures your database structure stays synchronized with your TypeScript definitions without manual SQL writing.

What is the best way to apply rapid schema changes to PostgreSQL during prototyping?

The best way to apply rapid schema changes to PostgreSQL during prototyping is direct schema pushing. This approach applies changes straight to the database, bypassing migration file generation for faster iteration when testing schema patterns and foreign key constraints.

Can I use manual SQL scripts for complex database migrations in PostgreSQL?

Yes, you can use manual SQL scripts for complex PostgreSQL database migrations. This approach supports custom transformations, triggers, and intricate operations that go beyond automated schema generation, ensuring data integrity during complex schema management tasks.

Does Drizzle Kit support automated generation of migration scripts for PostgreSQL?

Yes, Drizzle Kit supports automated generation of migration scripts for PostgreSQL databases. It compares your schema files to automatically generate the necessary migration scripts, streamlining the creation and execution of database schema changes for development and production.

When do I need to use manual SQL scripts instead of automated schema generation?

You need to use manual SQL scripts instead of automated schema generation when handling complex database transformations or triggers. Automated generation handles standard schema patterns, but manual SQL ensures data consistency for operations requiring custom logic in your PostgreSQL database.