db-schema

name	db-schema
description	Generate database schemas, migrations, and ERD diagrams from plain English descriptions — supports PostgreSQL, MySQL, SQLite, and MongoDB with proper indexes and constraints.
metadata	{"openclaw":{"emoji":"🗄️","os":["darwin","linux","win32"]}}

DB Schema

Describe your data model in English. Get production-ready schema, migrations, and diagrams.

What It Does

Takes a plain English description of your data and generates:

• SQL schema (CREATE TABLE statements with constraints)
• Migration files (for Prisma, Drizzle, Knex, Alembic, etc.)
• Entity-Relationship diagram (Mermaid or ASCII)
• Indexes (auto-detected from common query patterns)
• Seed data (realistic sample data for development)

Usage

From description:

db-schema "Users have many posts. Posts have many comments. Users can like posts."

With options:

db-schema "E-commerce with products, orders, customers" --dialect postgres --orm prisma

Options:

• --dialect — postgres (default), mysql, sqlite, mongodb
• --orm — raw (default), prisma, drizzle, knex, sqlalchemy, typeorm