AgentSkillsCN

schema-gen

根据描述生成数据库表结构

SKILL.md
--- frontmatter
name: schema-gen
description: Generate database schemas from descriptions

Schema Generator

Describe your data, get a proper database schema. Supports SQL, Prisma, and Drizzle.

Quick Start

bash
npx ai-schema "e-commerce with users, products, orders, reviews"

What It Does

  • •Generates complete database schema
  • •Adds proper relationships
  • •Includes indexes for common queries
  • •Handles timestamps and soft deletes

Usage Examples

bash
# Generate SQL schema
npx ai-schema "blog with posts, authors, comments, tags"

# Prisma format
npx ai-schema "saas with teams and members" --format prisma

# Drizzle format
npx ai-schema "inventory system" --format drizzle

Output Formats

  • •Raw SQL (PostgreSQL, MySQL)
  • •Prisma schema
  • •Drizzle schema
  • •TypeORM entities
  • •Mongoose models

Includes

  • •Primary keys
  • •Foreign key relationships
  • •Indexes on common fields
  • •Timestamps (created/updated)
  • •Soft delete support
  • •Enum types where appropriate

Requirements

Node.js 18+. OPENAI_API_KEY required.

License

MIT. Free forever.

Built by LXGIC Studios