skills.rest
jamsmac
jamsmacCOMMUNITY
Explore all skills by this author →
GitHub

vhm24-db-expert

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
One-click install
npx skills add https://github.com/jamsmac/VHM24 --skill vhm24-db-expert
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
jieni777jieni777
1

database

Connect to PostgreSQL or MySQL databases to execute SQL queries and inspect schema.

Community
Intermediate
mgd34msumgd34msu
4

drizzle

Develop type-safe database applications with Drizzle ORM in TypeScript.

Community
Intermediate
lciaccilciacci

supabase-nextjs

Build Next.js App Router apps with Supabase auth and Drizzle ORM.

Community
Intermediate
legions-developerlegions-developer
885

drizzle-orm

Define PostgreSQL schemas and run type-safe queries with Drizzle ORM.

Community
Advanced