OpenClaw

schema-builder

Database schema designer. Design table structures, generate SQL DDL, migration scripts, seed data, ER diagrams, optimization reports, NoSQL schemas, and schema diffs. Commands: design, sql, migrate, seed, erd, optimize, nosql, compare. Use for database design, table structure, SQL generation.

ckchzh0 来源安装数☆ 0 仓库 Stars

查看来源 ↗安装与使用 SKILL.md ↗

安装与使用

请根据来源仓库和你的 AI 工具说明安装此技能。先阅读技能文件和依赖要求，再添加到工作流。

SkillHub CLI

skillhub install ckchzh/schema-builder

打开来源仓库，查看说明和兼容环境后，按来源提供的命令或步骤安装。

将来源链接提供给你的 Agent，让它先读取说明、核对依赖，并向你说明将执行的安装步骤。

查看来源 ↗使用指南

技能说明

🗃️ Schema Builder

From requirement to complete database structure in one step.

Usage

bash scripts/schema.sh <command> <table_name> [options]

Command Matrix

┌──────────┬──────────────────────────────┬───────────────┐
│ Command  │ Description                  │ Output        │
├──────────┼──────────────────────────────┼───────────────┤
│ design   │ Design schema from name      │ Field layout  │
│ sql      │ Generate CREATE TABLE DDL    │ SQL statement │
│ migrate  │ Generate migration script    │ Migration     │
│ seed     │ Generate test/seed data      │ INSERT stmts  │
│ erd      │ ASCII ER diagram             │ Relationship  │
│ optimize │ Index & perf recommendations │ Report        │
│ nosql    │ MongoDB schema               │ JSON schema   │
│ compare  │ Diff two schemas             │ Diff report   │
└──────────┴──────────────────────────────┴───────────────┘

Typical Flow

design → sql → migrate → seed
         ↓
       optimize
         ↓
        erd

design users — plan fields and relations
sql users — generate executable SQL
migrate users — versioned migration
seed users — populate test data
optimize users — check index suggestions

Supported Databases

Relational: MySQL, PostgreSQL, SQLite
NoSQL: MongoDB, Redis (via nosql command)

来源信息

Source: github
Repository: openclaw/skills
Path: skills/ckchzh/schema-builder
Version: —
Commit: 3d4e91d633bc03bb7511d7ef90f538eb81dea1a9
分类来源: rules
状态: active
可见性: public

这些信息来自收录时的来源分析，可能滞后；使用前请核对最新来源文件。

来源内容

SKILL.md

# 🗃️ Schema Builder

From requirement to complete database structure in one step.

## Usage

```bash
bash scripts/schema.sh <command> <table_name> [options]
```

## Command Matrix

```
┌──────────┬──────────────────────────────┬───────────────┐
│ Command  │ Description                  │ Output        │
├──────────┼──────────────────────────────┼───────────────┤
│ design   │ Design schema from name      │ Field layout  │
│ sql      │ Generate CREATE TABLE DDL    │ SQL statement │
│ migrate  │ Generate migration script    │ Migration     │
│ seed     │ Generate test/seed data      │ INSERT stmts  │
│ erd      │ ASCII ER diagram             │ Relationship  │
│ optimize │ Index & perf recommendations │ Report        │
│ nosql    │ MongoDB schema               │ JSON schema   │
│ compare  │ Diff two schemas             │ Diff report   │
└──────────┴──────────────────────────────┴───────────────┘
```

## Typical Flow

```
design → sql → migrate → seed
         ↓
       optimize
         ↓
        erd
```

1. `design users` — plan fields and relations
2. `sql users` — generate executable SQL
3. `migrate users` — versioned migration
4. `seed users` — populate test data
5. `optimize users` — check index suggestions

## Supported Databases

- Relational: MySQL, PostgreSQL, SQLite
- NoSQL: MongoDB, Redis (via `nosql` command)

搜索