vhm24-db-expert

What problem does it solve?

This Skill guides engineers to design and optimize VendHub's database schema using Drizzle ORM and MySQL, ensuring scalable data models and efficient migrations.

Core Features & Use Cases

• Table design & relations: Create tables, define relations, and ensure referential integrity with Drizzle ORM.
• Migration workflows: Generate and apply migrations to evolve the schema safely.
• Performance-focused patterns: Recommend indexing, enums, and data types for reliable, high-performance queries.
• Use Case: When adding a new module (e.g., inventory or orders), this Skill helps model the schema, define relations, and generate migrations consistently.

Quick Start

Start by inspecting the VendHub database needs, then scaffold schema.ts in src/db/schema.ts and run the migration tool to generate and apply migrations.