skills.rest
andrewn6
andrewn6COMMUNITY
Explore all skills by this author →
GitHub

db-migration

Generate Drizzle ORM SQL migrations for Encore.ts PostgreSQL schemas.

Updated Aug 23, 2026
Search Tags:#database#postgresql#backend#schema#migration#drizzle orm
One-click install
npx skills add https://github.com/andrewn6/traceway --skill db-migration-andrewn6
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-migration
Source: https://github.com/andrewn6/traceway/tree/main/.claude/skills/db-migration
Command: npx skills add https://github.com/andrewn6/traceway --skill db-migration-andrewn6

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the process of updating your application's database schema, ensuring consistency and preventing data integrity issues.

Core Features & Use Cases

  • Schema Modification: Add, remove, or alter database tables, columns, and indexes.
  • Automated Migration Generation: Generates SQL migration scripts based on schema definitions in TypeScript.
  • Use Case: When you need to add a new user_settings table with columns for theme and notifications to your PostgreSQL database, this skill will handle the schema definition and migration generation.

Quick Start

Use the db-migration skill to create a new database migration for the backend application.

Frequently Asked Questions about db-migration

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

FAQPage Schema
How do I generate a PostgreSQL database migration using Drizzle ORM?▼

To generate a PostgreSQL database migration, you define your schema in TypeScript and use a tool like drizzle-kit to automatically generate the SQL scripts for your backend application.

How do I add a new table to my database schema in Encore.ts?▼

To add a new database table, you update your TypeScript schema definitions and use the db-migration skill to generate the SQL migration script for your Encore.ts backend.

What's the best way to alter database columns without losing data?▼

The best way to alter database columns safely is to generate automated SQL migration scripts from your TypeScript schema definitions, ensuring consistency and preventing data integrity issues.

Do I need a specific schema file path to generate database migrations?▼

Yes, you need your schema definitions located in a specific TypeScript file path, such as backend/app/core/schema.ts, for the migration tool to read and generate SQL scripts.

Can I modify database indexes automatically from my TypeScript code?▼

Yes, you can modify database indexes by updating your TypeScript schema definitions and running the migration generator to automatically create the necessary SQL scripts.

Why does my database schema update require automated migration generation?▼

Automated migration generation is required to streamline updating your database schema and generating SQL scripts, ensuring consistency across your PostgreSQL database and preventing data integrity issues.

Related Skills

Explore More Software Engineering Skills→
getsentrygetsentry
78

db-migrate

Generate Drizzle Kit migrations from schema.ts changes for TypeScript projects.

Official
Intermediate
arrowInkneeeeearrowInkneeeee
1

db-migration-generator

Generate SQL migration scripts for schema changes across multiple databases.

Community
Intermediate
qazuorqazuor

drizzle-patterns

Standardize PostgreSQL schema, relations, and queries with Drizzle ORM.

Community
Advanced
RyoOsakaRyoOsaka

migration

Generate and apply Drizzle ORM database migrations from TypeScript schema changes.

Community
Intermediate