# Schema Gen

> Generate database schemas from descriptions

- Skill: `kbarbel640-del/schema-gen` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add kbarbel640-del/schema-gen`
- Raw SKILL.md: https://api.skillmd.com/api/skills/kbarbel640-del/schema-gen/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: kbarbel640-del (https://skillmd.com/u/kbarbel640-del)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/kbarbel640-del/schema-gen

---


# Schema Generator

Describe your data, get a proper database schema. Supports SQL, Prisma, and Drizzle.

## Quick Start

```bash
npx ai-schema "e-commerce with users, products, orders, reviews"
```

## What It Does

- Generates complete database schema
- Adds proper relationships
- Includes indexes for common queries
- Handles timestamps and soft deletes

## Usage Examples

```bash
# Generate SQL schema
npx ai-schema "blog with posts, authors, comments, tags"

# Prisma format
npx ai-schema "saas with teams and members" --format prisma

# Drizzle format
npx ai-schema "inventory system" --format drizzle
```

## Output Formats

- Raw SQL (PostgreSQL, MySQL)
- Prisma schema
- Drizzle schema
- TypeORM entities
- Mongoose models

## Includes

- Primary keys
- Foreign key relationships
- Indexes on common fields
- Timestamps (created/updated)
- Soft delete support
- Enum types where appropriate

## Requirements

Node.js 18+. OPENAI_API_KEY required.

## License

MIT. Free forever.

---

**Built by LXGIC Studios**

- GitHub: [github.com/lxgicstudios/ai-schema](https://github.com/lxgicstudios/ai-schema)
- Twitter: [@lxgicstudios](https://x.com/lxgicstudios)