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 ```bash 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 ```bash # 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. ```bash 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.