vhm24-db-expert

Name: vhm24-db-expert
Availability: InStock
Author: jamsmac

Design and optimize VendHub database schemas with Drizzle ORM and MySQL.

Updated Aug 23, 2026

Search Tags:#typescript #migrations #sql #mysql #drizzle-orm #database-schema #orm-patterns

Ready to run

npx skills add https://github.com/jamsmac/VHM24 --skill vhm24-db-expert

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: vhm24-db-expert
Source: https://github.com/jamsmac/VHM24/tree/main/skills/vhm24-db-expert
Command: npx skills add https://github.com/jamsmac/VHM24 --skill vhm24-db-expert

SYSTEM DOCUMENTATION & REQUIREMENTS

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.

Frequently Asked Questions about vhm24-db-expert

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I design a database schema with Drizzle ORM and generate migrations in TypeScript?▼

Design a database schema with Drizzle ORM by defining tables, relations, and enums in a TypeScript schema file, then use drizzle-kit to generate and apply SQL migrations to MySQL automatically.

What's the best way to model table relations and referential integrity using Drizzle ORM?▼

Model table relations and referential integrity in Drizzle ORM by defining foreign keys and relation mappings directly in your TypeScript schema, ensuring structured, type-safe data connections across MySQL tables.

Does Drizzle ORM support MySQL enums and indexing for high-performance queries?▼

Drizzle ORM supports MySQL enums and indexing, allowing you to define constrained data types and add indexes to your schema to optimize query performance and ensure reliable data retrieval.

How do I add a new module to an existing Drizzle ORM schema and safely evolve the database?▼

Add a new module to a Drizzle ORM schema by defining new tables and relations in db/schema.ts, then run the migration workflow to generate incremental SQL migrations that safely evolve the MySQL database.

When do I need to regenerate migrations after updating a TypeScript database schema?▼

Regenerate migrations whenever you modify tables, relations, enums, or indexes in your TypeScript database schema, ensuring the drizzle-kit migration workflow captures all structural changes for MySQL deployment.