How are database migrations handled?

The skill provides a structured CLI workflow to generate SQL migrations based on schema changes, review the generated files, and apply them using the Bun runtime.

Does this skill support other databases besides PostgreSQL?

Currently, this skill is specifically optimized for PostgreSQL using Drizzle ORM configurations and pg-core types.

Can I access the database directly using Drizzle's select or insert methods?

No, this skill strictly enforces that all database interactions occur through repository classes to maintain architectural integrity and prevent direct database leaks into the service layer.

What is the primary benefit of the repository pattern in this skill?

It ensures that database access logic is centralized and decoupled from business logic, making the code more maintainable, testable, and preventing inconsistent data access patterns.

Drizzle ORM Database Management

Name: Drizzle ORM Database Management
Author: umate

byumate

•

데이터베이스 관리

Manages PostgreSQL databases using Drizzle ORM through a strict repository pattern and schema-first workflow.

This skill provides a standardized framework for building robust, scalable database layers in PostgreSQL using Drizzle ORM. It enforces high-quality architectural patterns, specifically requiring a Repository layer to abstract data access from business logic and prevent direct database leakage. By automating schema definitions, migration workflows, and common query patterns, it ensures consistency across database operations while adhering to best practices like snake_case naming conventions, UUID primary keys, and mandatory timestamp tracking.

주요 기능

01Strict Repository Pattern enforcement for decoupled data access

02Standardized PostgreSQL schema definitions using Drizzle ORM

03Type-safe query building with complex filtering, ordering, and relations

04Comprehensive migration management workflow (Generate, Review, Apply)

05Pre-configured singleton database client and connection pooling setup

064 GitHub stars

사용 사례

01Refactoring legacy codebases to move from direct database queries to clean Repository patterns

02Managing complex database schema evolutions and migrations within a Bun-based development environment

03Building a type-safe data access layer for a new PostgreSQL backend application

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add umate/foundry db

For use in Claude.ai and ChatGPT