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