← 返回 Skills 市场
23396599

Report Sql

作者 23396599 · GitHub ↗ · v1.0.0 · MIT-0
cross-platform ⚠ suspicious
110
总下载
0
收藏
1
当前安装
1
版本数
在 OpenClaw 中安装
/install report-sql
功能描述
Define and validate SQL template variables and blocks for report-service with zero tolerance, supporting safe injection, conditional fragments, loops, and da...
安全使用建议
This skill is a detailed design document for a SQL templating protocol — it does not include an implementation. It does not request credentials or install anything, so there's no direct exfiltration risk from the package itself. However, the SKILL.md repeatedly claims the templates are 'safe' and 'injection-proof' but offers no runtime or enforcement code. Before using this in production, do the following: 1) Confirm the actual template engine or code that will render these templates implements parameter binding or proper escaping (do not rely on string concatenation). 2) Request example implementation code or tests from the author that prove block-removal semantics and escaping behavior (including edge cases and malicious inputs). 3) Run unit tests with attacker-controlled inputs to verify no SQL injection and that empty/partial blocks are removed safely. 4) Prefer parameterized queries (driver-level placeholders) over textual substitution where possible. 5) Review how the system logs queries and variables to avoid leaking PII/credentials. If you cannot obtain an implementation or confident tests, treat these instructions as a spec only and do not assume they protect you from injection.
能力评估
Purpose & Capability
The name/description and the SKILL.md both describe a SQL template protocol and transform rules for a 'report-service'. There are no unrelated required binaries, env vars, or install steps. The requested surface is proportionate for a templating specification.
Instruction Scope
SKILL.md prescribes variable syntax, block mechanics (${...}, loops, etc.) and repeatedly asserts '空安全' and '天然防 SQL 注入' (safe from SQL injection). However, this is purely a specification: there is no code or runtime provided that actually enforces escaping, parameterization, or block removal. If an agent or developer implements these templates by directly substituting user-supplied strings into SQL without a safe engine, SQL injection and syntax errors are possible. The instructions also give the agent broad discretion to emit SQL fragments; those emissions could be dangerous unless the executing environment provides binding/escaping.
Install Mechanism
Instruction-only skill with no install spec and no code files. This minimizes disk/write/install risk.
Credentials
The skill requires no environment variables, credentials, or config paths. Nothing asks for unrelated secrets or elevated access.
Persistence & Privilege
Metadata shows always:false and no special privileges. The skill does not request permanent presence or modify other skills' configs.
如何使用
  1. 确保已安装 OpenClaw(本地或 Docker 部署)
  2. 在对话框中输入安装命令:/install report-sql
  3. 安装完成后,直接呼叫该 Skill 的名称或使用 /report-sql 触发
  4. 根据 Skill 的参数说明提供必要输入,即可获得结构化输出
版本历史
v1.0.0
- Initial release of the `report-sql` skill. - Defines a strict SQL variable templating protocol for `report-service`, supporting precise, safe, and namespaced variable injection. - Introduces block-level variable syntax (`${...}`) for conditional SQL fragments with "empty-safe" rendering. - Adds common SQL snippet patterns: fuzzy matching, date range queries, array variable loops (`$@... -> OR { ... }`), and complex EXISTS subqueries. - Details best practices to ensure SQL syntax integrity, including strict namespace and boundary rules for dynamic blocks. - Documents a structured JSON-based data transformation pipeline for SQL query results, supporting initialization, conditional assignment, object mapping, left joins, and complex response assembly.
元数据
Slug report-sql
版本 1.0.0
许可证 MIT-0
累计安装 1
当前安装数 1
历史版本数 1
常见问题

Report Sql 是什么?

Define and validate SQL template variables and blocks for report-service with zero tolerance, supporting safe injection, conditional fragments, loops, and da... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件,目前累计下载 110 次。

如何安装 Report Sql?

在 OpenClaw 或 Claude Code 对话框中运行命令「/install report-sql」即可一键安装,无需额外配置。

Report Sql 是免费的吗?

是的,Report Sql 完全免费,采用 MIT-0 许可证,可自由下载、安装和使用。

Report Sql 支持哪些平台?

Report Sql 跨平台运行,可在任意部署了 OpenClaw / Claude Code 的环境中使用(cross-platform)。

谁开发了 Report Sql?

由 23396599(@23396599)开发并维护,当前版本 v1.0.0。

💬 留言讨论