← Back to Skills Marketplace
Sql Generator
by
BytesAgain2
· GitHub ↗
· v2.3.7
· MIT-0
904
Downloads
1
Stars
7
Active Installs
11
Versions
Install in OpenClaw
/install sql-generator
Description
SQL生成器。自然语言转SQL、SQL解释、性能优化、建表语句、测试数据生成、数据库迁移、SQL速查表。SQL generator from natural language, explainer, optimizer, DDL creator, mock data, migration scripts, che...
README (SKILL.md)
SQL Generator
SQL生成器。自然语言转SQL、SQL解释、性能优化、建表语句、测试数据生成、数据库迁移、SQL速查表。SQL generator from natural language, explainer, optimizer, DDL creator, mock data, migration scripts, cheatsheet. SQL、数据库、MySQL。
常见问题
Q: 这个工具适合谁用？ A: 任何需要sql generator的人，无论是个人还是企业用户。
Q: 输出格式是什么？ A: 主要输出Markdown格式，方便复制和编辑。
可用命令
- query — query
- explain — explain
- optimize — optimize
- create — create
- mock — mock
- migrate — migrate
- cheatsheet — cheatsheet
专业建议
- SELECT/WHERE/ORDER BY
- INSERT/UPDATE/DELETE
- 基本聚合（COUNT/SUM/AVG）
- GROUP BY + HAVING
- JOIN（INNER/LEFT/RIGHT/FULL）
SQL Generator by BytesAgain
💬 Feedback & Feature Requests: https://bytesagain.com/feedback Powered by BytesAgain | bytesagain.com
Examples
# Show help
sql-generator help
# Run
sql-generator run
Commands
Run sql-generator help to see all available commands.
Usage Guidance
This skill appears to do what it claims: generate SQL, DDL, mock data and tips. Before running, review the two included bash scripts to confirm they match expectations (they are plain shell that emits SQL and writes logs). Be aware the scripts create a data directory (SQL_GENERATOR_DIR or ~/.local/share/sql-generator) and write data.log/history.log — avoid feeding real production credentials or sensitive database connection strings to the tool. If you plan to execute the scripts, run them in a non-privileged or isolated environment (container/VM) the first time to confirm behavior.
Capability Analysis
Type: OpenClaw Skill
Name: sql-generator
Version: 2.3.7
The skill bundle is a SQL generation and data management toolkit. The scripts (script.sh and sql.sh) provide templates for SQL tables, queries, and mock data, and maintain a local activity log in a standard data directory (~/.local/share/sql-generator). No evidence of data exfiltration, unauthorized remote execution, or malicious prompt injection was found.
Capability Assessment
Purpose & Capability
Name/description (SQL generator, DDL, mock data, migration, explain, optimize) align with provided assets: SKILL.md, tips.md, and two bash scripts (scripts/sql.sh and scripts/script.sh) that produce SQL, DDL templates and a small CLI. No unrelated credentials or binaries are requested.
Instruction Scope
SKILL.md instructs use of the included sql.sh tool and documents commands (query, explain, optimize, create, mock, migrate, cheatsheet). The scripts operate locally and only read/write files under a data directory; they do not request arbitrary system files or instruct the agent to exfiltrate data.
Install Mechanism
No install spec (instruction-only), but the package includes executable bash scripts. Running the skill will execute those local scripts; review them before running. There is no network download/install step in the package.
Credentials
The skill requires no environment variables or credentials. The scripts create and use a data directory (SQL_GENERATOR_DIR or XDG_DATA_HOME or ~/.local/share/sql-generator) and write files (data.log, history.log). This persistent local storage is proportional to a CLI tool but users should be aware logs may contain queries or examples.
Persistence & Privilege
always is false and the skill does not request system-wide or other-skills configuration. Its persistence is limited to creating files under the user's data directory; it does not modify other skills or agent configs.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install sql-generator - After installation, invoke the skill by name or use
/sql-generator - Provide required inputs per the skill's parameter spec and get structured output
Version History
v2.3.7
v2.5 standard: Use-when desc, homepage, source, security fix
v2.3.6
retry-fix-token
v2.3.5
yaml-fix+quality
v2.3.4
Quality upgrade
v2.3.3
Quality upgrade: custom functionality
v2.3.2
Standards compliance: unique content, no template text
v2.3.1
Quality improvement: better docs, examples, cleaner text
v2.3.0
Quality fixes: removed third-party references, aligned docs with implementation
v2.2.0
Enhanced descriptions for better AI triggering
v2.0.0
Complete rewrite with real functionality
v1.0.0
Initial release of SQL Generator.
- Converts natural language to SQL queries.
- Explains SQL statements.
- Suggests performance optimizations.
- Generates table creation (DDL) statements.
- Creates mock/test data and migration scripts.
- Provides an SQL syntax cheatsheet.
- Supports outputs in Markdown format for easy copying and editing.
Metadata
Frequently Asked Questions
What is Sql Generator?
SQL生成器。自然语言转SQL、SQL解释、性能优化、建表语句、测试数据生成、数据库迁移、SQL速查表。SQL generator from natural language, explainer, optimizer, DDL creator, mock data, migration scripts, che... It is an AI Agent Skill for Claude Code / OpenClaw, with 904 downloads so far.
How do I install Sql Generator?
Run "/install sql-generator" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Sql Generator free?
Yes, Sql Generator is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Sql Generator support?
Sql Generator is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Sql Generator?
It is built and maintained by BytesAgain2 (@ckchzh); the current version is v2.3.7.
More Skills