← Back to Skills Marketplace
ckchzh

Schema Builder

by BytesAgain2 · GitHub ↗ · v3.0.0 · MIT-0
cross-platform ⚠ suspicious
559
Downloads
0
Stars
2
Active Installs
11
Versions
Install in OpenClaw
/install schema-builder
Description
Build database schemas with SQL generation and relationship modeling. Use when designing databases.
Usage Guidance
This skill appears to be a local schema-generation utility and is internally consistent with its description. Before installing or permitting autonomous execution: 1) note that there are two scripts—script.sh (documented) and schema.sh (undocumented commands) — both generate text only and do not contact external servers; 2) the tool will create ~/.local/share/schema-builder for its outputs; 3) the shell scripts have minor quoting bugs (harmless but could produce incorrect output), so run them in an isolated environment (or inspect/patch them) if you plan to run on production systems; and 4) because the skill can be invoked autonomously by the agent, restrict autonomous execution if you are uncomfortable with any code running locally without supervision.
Capability Analysis
Type: OpenClaw Skill Name: schema-builder Version: 3.0.0 The skill bundle contains a shell injection vulnerability in `scripts/script.sh` within the `cmd_validate` function, where the second argument is used unquoted in a shell command (`[ -f $2 ]`), allowing for arbitrary command execution if a malicious filename is provided. Furthermore, `scripts/script.sh` is poorly implemented with broken variable interpolation (using single quotes for shell variables) and contains a large block of empty comment lines, a technique often used to hide malicious code from quick visual inspection. While no explicit evidence of data exfiltration or intentional malice was found, the combination of critical vulnerabilities and suspicious coding patterns warrants a suspicious classification.
Capability Assessment
Purpose & Capability
The declared purpose (database schema building) matches the included scripts: both scripts/schema.sh and scripts/script.sh produce schema designs, SQL, migrations, seeds and ER diagrams. Minor inconsistency: SKILL.md documents commands that call scripts/script.sh, while scripts/schema.sh contains additional commands (design, sql, migrate, seed, erd, etc.) that are not listed in SKILL.md. All functionality is still within the domain of schema generation.
Instruction Scope
SKILL.md instructs running scripts/script.sh and states data is stored in ~/.local/share/schema-builder. The scripts only create that directory and print/generated SQL/text; they do not read other system configuration or send data externally. Small issues: scripts/script.sh uses some unquoted shell variables (e.g., [ -f $2 ]) and echoes literal $2/$3 in single quotes (likely a bug), which are operational bugs but not secret-exfiltration behavior.
Install Mechanism
No install spec is present (instruction-only plus included scripts). No downloads, package installs, or archive extraction are performed by the skill bundle.
Credentials
The skill declares no required environment variables or credentials. The scripts use $HOME to create a local data directory (~/.local/share/schema-builder), which is proportional and expected for a local CLI-style tool.
Persistence & Privilege
always is false and the skill does not request elevated or persistent platform privileges. It only creates a directory within the user's home for storing its outputs; it does not modify other skills or system-wide config.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install schema-builder
  3. After installation, invoke the skill by name or use /schema-builder
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v3.0.0
v3.0.0: rewrite
v2.0.1
update
v2.0.0
v2.5 standard: Use-when desc, homepage, source, security fix
v2.3.4
yaml-fix+quality
v2.3.3
yaml-fix+quality
v2.3.2
Quality upgrade
v2.3.1
Quality upgrade: custom functionality
v2.3.0
Quality fixes: removed third-party references, aligned docs with implementation
v2.2.0
Enhanced descriptions for better AI triggering
v1.0.1
Add runtime declaration + security compliance
v1.0.0
- Initial release of schema-builder: a database schema designer with multiple features. - Supports designing table structures, generating SQL DDL, migration scripts, seed data, ER diagrams, optimization reports, NoSQL schemas, and schema diffs. - Provides commands: design, sql, migrate, seed, erd, optimize, nosql, compare. - Compatible with MySQL, PostgreSQL, SQLite, MongoDB, and Redis.
Metadata
Slug schema-builder
Version 3.0.0
License MIT-0
All-time Installs 2
Active Installs 2
Total Versions 11
Frequently Asked Questions

What is Schema Builder?

Build database schemas with SQL generation and relationship modeling. Use when designing databases. It is an AI Agent Skill for Claude Code / OpenClaw, with 559 downloads so far.

How do I install Schema Builder?

Run "/install schema-builder" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is Schema Builder free?

Yes, Schema Builder is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does Schema Builder support?

Schema Builder is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created Schema Builder?

It is built and maintained by BytesAgain2 (@ckchzh); the current version is v3.0.0.

💬 Comments