---

name: prisma-gen description: Generate Prisma schema from plain English. Use when starting a database schema.

Prisma Generator

Designing database schemas means thinking about relations, indexes, and constraints. Describe your data and get a complete Prisma schema.

One command. Zero config. Just works.

Quick Start

npx ai-prisma-gen "e-commerce with users, products, and orders"

What It Does

• Generates complete Prisma schema from descriptions
• Sets up proper relations and constraints
• Includes common fields (createdAt, updatedAt)
• Handles enums and indexes

Usage Examples

# E-commerce schema
npx ai-prisma-gen "e-commerce with users, products, orders"

# SaaS schema
npx ai-prisma-gen "SaaS with organizations, users, and subscriptions"

# Social app
npx ai-prisma-gen "social app with users, posts, likes, and follows"

Best Practices

• Use relations - let Prisma handle joins
• Add indexes - for frequently queried fields
• Consider soft deletes - deletedAt instead of actual delete
• Review and refine - AI gets 80%, you add the rest

When to Use This

• Starting a new database design
• Learning Prisma schema syntax
• Rapid prototyping
• Getting a baseline to customize

Part of the LXGIC Dev Toolkit

This is one of 110+ free developer tools built by LXGIC Studios. No paywalls, no sign-ups, no API keys on free tiers. Just tools that work.

Find more:

• GitHub: https://github.com/LXGIC-Studios
• Twitter: https://x.com/lxgicstudios
• Substack: https://lxgicstudios.substack.com
• Website: https://lxgicstudios.com

Requirements

No install needed. Just run with npx. Node.js 18+ recommended. Needs OPENAI_API_KEY environment variable.

npx ai-prisma-gen --help

How It Works

Takes your plain English description of data models and relationships, then generates valid Prisma schema syntax with proper types, relations, and indexes.

License

MIT. Free forever. Use it however you want.