什么是 Prisma Gen？

Prisma Gen 是一款以开发者为中心的实用工具，旨在消除与数据库建模相关的重复性手动工作。通过集成 Openclaw Skills 目录中的这款工具，开发者可以用简单的英语描述数据需求，并获得完整的 schema.prisma 文件。它负责处理复杂的语法，确保关系、唯一约束和字段类型均按照 Prisma 最佳实践正确实现。

对于希望加速开发生命周期的团队来说，这项技能尤其宝贵。用户无需搜索关系语法或手动添加装饰器，只需专注于应用逻辑，由 AI 处理 Schema 构建。它是概念模型与可执行代码之间的桥梁，是任何现代开发者工具箱中必不可少的补充。

下载入口:https://github.com/openclaw/skills/tree/main/skills/lxgicstudios/prisma-gen

安装与下载

1. ClawHub CLI

从源直接安装技能的最快方式。

2. 手动安装

将技能文件夹复制到以下位置之一

优先级：工作区 > 本地 > 内置

3. 提示词安装

将此提示词复制到 OpenClaw 即可自动安装。

Prisma Gen 应用场景

• 为新项目或 MVP 快速引导数据库 Schema
• 为社交网络或多租户 SaaS 平台等复杂关系结构建模
• 通过观察 AI 如何将描述转换为有效的 Schema 代码来学习 Prisma 语法
• 生成标准化的数据库模板，避免手动输入错误

1. 用户通过包含数据模型自然语言描述的 CLI 命令启动工具。
2. 该工具将描述传输至经过 Prisma 特定提示逻辑优化的专用 LLM。
3. AI 解析需求以识别实体、关系（一对多、多对多）和特定约束。
4. 工具返回一个有效的、格式化的 schema.prisma 字符串，可直接输出到项目文件中。

Prisma Gen 配置指南

要使用此技能，请确保已安装 Node.js 18+。您还必须在环境中配置有效的 OpenAI API 密钥。

# 导出您的 API 密钥
export OPENAI_API_KEY=sk-...

# 直接生成 Schema 到文件
npx ai-prisma-gen "a blog with users, posts, and comments" > prisma/schema.prisma

Prisma Gen 数据架构与分类体系

输出遵循官方 Prisma Schema Language (PSL) 结构。此 Openclaw Skills 工具将数据组织为以下组件：

name: prisma-gen
description: Generate Prisma schema from plain English. Use when you need database models fast without writing boilerplate.

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.