prisma-gen

Prisma Gen

Stop hand-writing Prisma schemas. Just describe your data model in plain English and get a complete, production-ready schema.prisma file in seconds. No more googling relation syntax or forgetting @unique decorators.

One command. Zero config. Just works.

Quick Start

npx ai-prisma-gen "a blog with users, posts, comments, and tags"

What It Does

• Generates complete Prisma schema from natural language descriptions
• Handles relations automatically (one-to-many, many-to-many, self-referential)
• Adds proper indexes, constraints, and default values
• Supports all Prisma field types and decorators
• Outputs clean, formatted schema ready to use

Usage Examples

# E-commerce database
npx ai-prisma-gen "e-commerce with products, categories, orders, and user reviews"

# SaaS multi-tenant
npx ai-prisma-gen "multi-tenant saas with organizations, teams, users, and role-based permissions"

# Social app
npx ai-prisma-gen "social network with users, friendships, posts, likes, and direct messages"

# Save to file
npx ai-prisma-gen "task management with projects and assignees" > prisma/schema.prisma

Best Practices

• Be specific about relations - Say "users have many posts" instead of just "users and posts"
• Mention unique fields - Include "email should be unique" if that's what you need
• Include edge cases - Soft deletes, timestamps, status enums. Mention them upfront.
• Review before migrating - The schema is a starting point. Always check the output matches your needs.

When to Use This

• Starting a new project and need a database schema fast
• Prototyping an idea and don't want to waste time on boilerplate
• Learning Prisma and want to see how complex relations should look
• Converting a mental model into actual schema code

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://lxgic.dev

Requirements

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

export OPENAI_API_KEY=sk-...
npx ai-prisma-gen --help

How It Works

Takes your plain English description, sends it to GPT with Prisma-specific prompting, and returns a properly formatted schema.prisma file. The AI understands Prisma conventions like @@index, @relation, and common patterns like soft deletes and timestamps.

License

MIT. Free forever. Use it however you want.