What database systems does this skill support?

This skill is specifically optimized for PostgreSQL environments using Drizzle ORM as the primary interface.

Does it integrate with other parts of the codebase?

Yes, it includes a verification checklist to ensure that Zod validation schemas and backend API routes are updated in tandem with database changes.

What is the benefit of the 'make db-reset' command?

It automates the process of deleting volumes, applying the latest schema, and re-injecting seed data to provide a clean state for development.

How does this skill handle schema changes?

It guides you through a structured 3-step process: editing the schema, updating seed files, and running a database reset to ensure environment consistency.

Can I use this for production migrations?

Yes, it includes specialized commands for using Drizzle Kit to generate and run migrations safely in production environments without resetting data.

Drizzle Database Operations

Name: Drizzle Database Operations
Author: bayamasa

bybayamasa

Database Management

Manages Drizzle ORM database schemas, migrations, and seeding tasks for PostgreSQL environments.

About

This skill streamlines database management workflows by providing automated commands and structured checklists for schema updates, migrations, and seed data injection. It is specifically designed for developers using Drizzle ORM and PostgreSQL, ensuring consistency between database schemas, Zod validation models, and backend API routes while simplifying local development through automated reset and seeding procedures.

Key Features

Automated schema synchronization and database reset workflows
Cross-file consistency checks for Zod schemas and API endpoints
0 GitHub stars
Production-ready migration generation and execution using Drizzle Kit
Visual data exploration support via Drizzle Studio integration
Integrated seed data management for development testing

Use Cases

Synchronizing local development environments with fresh test data
Preparing and deploying safe database migrations for production
Modifying application data models with new tables or columns

About

Key Features

Automated schema synchronization and database reset workflows
Cross-file consistency checks for Zod schemas and API endpoints
0 GitHub stars
Production-ready migration generation and execution using Drizzle Kit
Visual data exploration support via Drizzle Studio integration
Integrated seed data management for development testing

Use Cases

Synchronizing local development environments with fresh test data
Preparing and deploying safe database migrations for production
Modifying application data models with new tables or columns