schema-gen

✓Verified·Scanned 2/18/2026

Generate database schemas from descriptions

from clawhub.ai·v3864f8d·1.2 KB·0 installs
Scanned from 1.0.1 at 3864f8d · Transparency log ↗
$ vett add clawhub.ai/lxgicstudios/schema-gen

Schema Generator

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

Quick Start

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

# 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