← 返回 Skills 市场
106
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install skylv-sql-helper
功能描述
SQL query builder and optimizer. Generates queries, explains execution plans, and optimizes slow queries. Triggers: sql query, database query, sql optimization.
使用说明 (SKILL.md)
SQL Helper
Overview
Helps write, optimize, and debug SQL queries.
When to Use
- User asks to "write a SQL query" or "optimize this query"
- Debugging slow database operations
Pagination
SELECT * FROM users ORDER BY id LIMIT 20 OFFSET 40;
Join with Aggregation
SELECT u.name, COUNT(o.id) as order_count FROM users u LEFT JOIN orders o ON u.id = o.user_id GROUP BY u.id;
Optimization Rules
- Add indexes on WHERE/JOIN columns
- Avoid SELECT * - specify columns
- Use EXPLAIN to analyze execution plan
- Optimize JOIN order (small table first)
- Add LIMIT for pagination
Anti-Patterns to Avoid
- SELECT * in production code
- Nested subqueries (use JOINs or CTEs)
- OR in WHERE clause (use IN or UNION)
安全使用建议
This skill is advisory only and will not connect to or run queries against your databases. If you need automated execution or EXPLAIN plans run against live systems, expect a different skill to request database credentials or network access — treat that credential request as sensitive. Proceed if you only want query-writing and optimization advice; if a future version asks for secrets or installs code, review those requests carefully before granting access.
功能分析
Type: OpenClaw Skill
Name: skylv-sql-helper
Version: 1.0.0
The skill is a standard SQL query helper and optimizer. The SKILL.md file contains only educational content, SQL templates, and best practices for database optimization. There is no executable code, network activity, or evidence of prompt injection or malicious intent.
能力评估
Purpose & Capability
Name and description (SQL query builder/optimizer) match the SKILL.md content: example queries, optimization rules, and anti-patterns. The skill does not claim or require database access, cloud credentials, or unrelated capabilities.
Instruction Scope
SKILL.md stays within the stated purpose (writing and optimizing SQL). It is purely advisory — it provides patterns, examples, and rules but does not include instructions to connect to databases, read files, or send data externally. Note: because it doesn't provide connection/execution steps, it will not run EXPLAIN or modify databases on its own; if you expect automated execution, a different skill that requests DB credentials would be required.
Install Mechanism
No install spec and no code files — lowest-risk instruction-only skill. Nothing is downloaded or written to disk.
Credentials
The skill declares no environment variables, credentials, or config paths, which is proportional to an advisory SQL helper that only provides examples and guidance.
Persistence & Privilege
Defaults are used (not always:true, not requesting permanent presence). The skill does not attempt to modify other skills or system-wide settings.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install skylv-sql-helper - 安装完成后，直接呼叫该 Skill 的名称或使用
/skylv-sql-helper触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v1.0.0
Initial release.
- SQL query builder and optimizer: generates, explains, and optimizes queries.
- Helps write, debug, and speed up SQL queries.
- Offers best practices and common anti-patterns to avoid.
- Provides examples for pagination and joins with aggregation.
- Activated with “sql-helper” trigger.
元数据
常见问题
Skylv Sql Helper 是什么？
SQL query builder and optimizer. Generates queries, explains execution plans, and optimizes slow queries. Triggers: sql query, database query, sql optimization. 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 106 次。
如何安装 Skylv Sql Helper？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install skylv-sql-helper」即可一键安装，无需额外配置。
Skylv Sql Helper 是免费的吗？
是的，Skylv Sql Helper 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。
Skylv Sql Helper 支持哪些平台？
Skylv Sql Helper 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 Skylv Sql Helper？
由 SKY-lv（@sky-lv）开发并维护，当前版本 v1.0.0。
推荐 Skills