prisma-gen

Included with Lifetime

$97 forever

Generate Prisma schema from plain English. Use when you need database models fast without writing boilerplate.

Writing & Docs

What this skill does

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

Files: 1

Size: 2.8 KB

Complexity: 5/100

Category: Writing & Docs

Source: https://github.com/thinkfleetai/thinkfleet-engine/tree/main/skills/prisma-gen

Related in Writing & Docs

jax-development

Included

Use this skill when the user is writing, debugging, profiling, refactoring, reviewing, benchmarking, parallelising, exporting, or explaining JAX code, or when they mention JAX, jax.numpy, jit, grad, value_and_grad, vmap, scan, lax, random keys, pytrees, jax.Array, sharding, Mesh, PartitionSpec, NamedSharding, pmap, shard_map, Pallas, XLA, StableHLO, checkify, profiler, or the JAX repo. It helps turn NumPy or PyTorch-style code into pure functional JAX, fix tracer/control-flow/shape/PRNG bugs, remove recompiles and host-device syncs, choose transforms and sharding strategies, inspect jaxpr/lowering/IR, and benchmark compiled code correctly.

Writing & Docsscripts

nature-article-writer

Included

Drafts, rewrites, diagnostically critiques, and style-calibrates primary research manuscripts for Nature and Nature Portfolio journals. Use when the user wants a Nature-style title, summary paragraph or abstract, introduction, results, discussion, methods, figure legends, presubmission enquiry, cover letter, reviewer response, or when a scientific draft sounds generic, jargon-heavy, structurally weak, or AI-ish and needs precise, broad-reader-friendly prose without inventing data, analyses, or references. Best for primary research articles and letters rather than reviews or press releases unless explicitly adapting one.

Writing & Docsscripts

deckrd

Included

Document-driven framework that derives requirements, specifications, implementation plans, and executable tasks from goals through structured AI dialogue. Use when user says "write requirements", "create spec", "plan implementation", "derive tasks", "structure this feature", "break down into tasks", or "document this module". Also use for reverse engineering existing code into docs (/deckrd rev). Do NOT use for direct code writing — use /deckrd-coder after tasks are generated. Do NOT use when the user only wants to run or fix existing code without planning.

Writing & Docsscripts

clinical-decision-support

Included

Generate professional clinical decision support (CDS) documents for pharmaceutical and clinical research settings, including patient cohort analyses (biomarker-stratified with outcomes) and treatment recommendation reports (evidence-based guidelines with decision algorithms). Supports GRADE evidence grading, statistical analysis (hazard ratios, survival curves, waterfall plots), biomarker integration, and regulatory compliance. Outputs publication-ready LaTeX/PDF format optimized for drug development, clinical research, and evidence synthesis.

Writing & Docsscripts

handling-sf-data

Included

Salesforce data operations with 130-point scoring. Use this skill to create, update, delete, bulk import/export, generate test data, and clean up org records using sf CLI and anonymous Apex. TRIGGER when: user creates test data, performs bulk import/export, uses sf data CLI commands, needs data factory patterns for Apex tests, or needs to seed/clean records in a Salesforce org. DO NOT TRIGGER when: SOQL query writing only (use querying-soql), Apex test execution (use running-apex-tests), or metadata deployment (use deploying-metadata).

Writing & Docsscripts

accelint-ac-to-playwright

Included

Convert and validate acceptance criteria for Playwright test automation. Use when user asks to (1) review/evaluate/check if AC are ready for automation, (2) assess if AC can be converted as-is, (3) validate AC quality for Playwright, (4) turn AC into tests, (5) generate tests from acceptance criteria, (6) convert .md bullets or .feature Gherkin files to Playwright specs, (7) create test automation from requirements. Handles both bullet-style markdown and Gherkin syntax with JSON test plan generation and validation.

Writing & Docsscripts