# Prisma Gen

> Generate Prisma schema from plain English. Use when starting a database schema.

- Skill: `kernel8901/prisma-gen` (Agent Skill, multi-file: 8 files)
- Install (CLI): `npx skillmds@latest add kernel8901/prisma-gen`
- Raw SKILL.md: https://api.skillmd.com/api/skills/kernel8901/prisma-gen/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: kernel8901 (https://skillmd.com/u/kernel8901)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/kernel8901/prisma-gen

---


# 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

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

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

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