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

Database Management

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

About

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.

Key Features

Automated migration generation and execution workflow
Integrated database seeding and initialization scripts
Optimized indexing patterns for time-based rate limiting
Standardized schema management via Drizzle ORM
Database-driven configuration for visa rules and templates
0 GitHub stars

Use Cases

Converting hardcoded application logic into database-driven rulesets
Updating database tables, enums, or indexes for new features
Maintaining consistent database versions across multiple development agents

About

Key Features

Automated migration generation and execution workflow
Integrated database seeding and initialization scripts
Optimized indexing patterns for time-based rate limiting
Standardized schema management via Drizzle ORM
Database-driven configuration for visa rules and templates
0 GitHub stars

Use Cases

Converting hardcoded application logic into database-driven rulesets
Updating database tables, enums, or indexes for new features
Maintaining consistent database versions across multiple development agents