skills.rest
kozyszoo
kozyszooCOMMUNITY
Explore all skills by this author →
GitHub

database

Generate and apply SQL migrations from TypeScript schemas using Drizzle ORM.

1|Updated Mar 3, 2026
Search Tags:#typescript#database#migrations#schema management#sql#drizzle orm
One-click install
npx skills add https://github.com/kozyszoo/antigravity-handson --skill database-kozyszoo
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/kozyszoo/antigravity-handson/tree/main/.claude/skills/database
Command: npx skills add https://github.com/kozyszoo/antigravity-handson --skill database-kozyszoo

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires drizzle-orm, pnpm, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides a structured and automated approach to managing database schemas and applying migrations using Drizzle ORM, preventing manual errors and ensuring consistency.

Core Features & Use Cases

  • Automated Schema Management: Define your database schema in TypeScript (schema.ts).
  • Migration Generation: Automatically generate SQL migration files based on schema changes.
  • Runtime Migrations: Ensure the database is up-to-date automatically when the application starts.
  • Use Case: When adding a new feature that requires new database tables or columns, this Skill ensures the database schema is updated correctly and safely across all environments.

Quick Start

Use the database skill to generate a new migration file for your schema changes.

Frequently Asked Questions about database

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

FAQPage Schema
How do I generate SQL migrations from a TypeScript schema using Drizzle ORM?▼

To generate SQL migrations with Drizzle ORM, you define your database schema in a TypeScript file and use this Skill's pnpm command-line interface to automatically create the corresponding SQL migration files based on those schema changes.

What is the best way to automate database migrations when starting a TypeScript application?▼

Automating database migrations on application startup is handled by this Skill through runtime migrations, which ensure your SQLite or compatible database schema is automatically updated and consistent when the app launches.

Does this database migration approach support SQLite environments?▼

Yes, this database migration approach supports SQLite and other compatible databases by defining the schema in TypeScript and applying the generated SQL migrations through the Drizzle ORM interface.

How do I manage database schema changes across development and production environments?▼

Managing database schema changes across environments is achieved by generating SQL migration files from your TypeScript definitions and applying them consistently to ensure data integrity in both development and production.

Do I need pnpm to run Drizzle ORM schema migrations?▼

Yes, you need pnpm installed to run these Drizzle ORM schema migrations, as the command-line interface for generating and applying the SQL files relies on pnpm for execution and dependency management.

Related Skills

Explore More Software Engineering Skills→
theslashdojotheslashdojo

drizzle-schema

Define type-safe database schemas in TypeScript for Drizzle ORM.

Official
Intermediate
paleoterrapaleoterra
2

sqlite-test-validator

Validate SQLite migrations and schemas with sqlite_validator.py CLI commands.

Community
Intermediate
luyi985luyi985

codegen-over-complex-types

Generate TypeScript types from OpenAPI, GraphQL, or database schemas.

Community
Advanced
4lerman4lerman

sql-database-assistant

Generate SQL queries, introspect schemas, optimize performance, and create migration scripts.

Community
Advanced