Does this skill help with performance optimization?

Yes, it encourages the use of explicit indexes, particularly for fields like userId and createdAt to optimize queries used in rate-limiting windows.

What is the primary purpose of the VKC Drizzle skill?

It standardizes the workflow for modifying database schemas, generating migrations, and seeding data specifically for the Viet K-Connect project using Drizzle ORM.

Where should I define my database schema?

According to the skill's hard rules, the database schema must reside in src/lib/db/schema.ts.

Why does this skill forbid hardcoding visa rulesets?

The skill enforces a DB-driven configuration pattern to ensure that complex rules and templates remain flexible and maintainable within the database rather than static code.

How are migrations generated and applied?

Migrations are handled via drizzle-kit using 'npm run db:generate' to create them and 'npm run db:migrate' to apply them to the database.

Drizzle Schema & Migration Manager

Name: Drizzle Schema & Migration Manager
Author: LEE-SANG-BOK

byLEE-SANG-BOK

0•

データベース管理

Standardizes and automates the Drizzle ORM schema management, migration generation, and database seeding workflow.

The VKC Drizzle Schema Migration skill provides a structured framework for managing database evolutions within the Viet K-Connect ecosystem. It enforces a database-first approach for configuration data, ensuring that visa rulesets and document templates are stored in tables rather than hardcoded in TypeScript. By streamlining the workflow from schema definition in src/lib/db/schema.ts to migration generation and local application, this skill maintains database integrity and prevents concurrent modification conflicts during the development process.

主な機能

01Automated migration generation and execution workflow

02Integrated database seeding and initialization scripts

03Optimized indexing patterns for time-based rate limiting

04Standardized schema management via Drizzle ORM

05Database-driven configuration for visa rules and templates

060 GitHub stars

ユースケース

01Converting hardcoded application logic into database-driven rulesets

02Updating database tables, enums, or indexes for new features

03Maintaining consistent database versions across multiple development agents

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lee-sang-bok/vkc-2- vkc-drizzle-schema-migration

For use in Claude.ai and ChatGPT

Download Skill