← 返回 Skills 市场
querydb-skill
作者
squidtestgary
· GitHub ↗
· v1.0.0
· MIT-0
94
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install querydb-skill
功能描述
数据库查询 Skill。当用户需要连接 MySQL/PostgreSQL 等数据库执行 SQL 查询、获取测试数据、验证接口返回数据时使用此 Skill。
安全使用建议
This skill appears to do what it says (query DBs and generate test cases), but it ships with hardcoded, usable credentials and a taxpayer ID inside SKILL.md and examples. Before installing or running it: (1) treat the embedded host/username/password as sensitive — do not assume they are safe or public; (2) verify with your organization whether that DB and credentials are legitimate and allowed to be used; (3) do not run the skill on networks where access to that host would leak data; (4) remove or replace any hardcoded credentials with environment variables or a secrets manager and update metadata to declare required creds; (5) review and sandbox any SQL you or the skill runs (it permits arbitrary queries); (6) if these credentials are real and were exposed unintentionally, rotate them and audit access. If you cannot validate the provenance of the embedded DB details, avoid using the skill or run it in an isolated test environment only.
功能分析
Type: OpenClaw Skill
Name: querydb-skill
Version: 1.0.0
The skill bundle contains hardcoded database credentials (host, user, password) for a MySQL instance at 10.115.96.247 within both SKILL.md and scripts/db_query.py. While the code appears to function as a legitimate database query and test case generation tool, the inclusion of plaintext credentials and specific local file paths represents a significant security risk, though no clear evidence of intentional malicious exfiltration or remote control was found.
能力评估
Purpose & Capability
Name/description, runtime instructions, and the included Python code all implement a DB query/test-case generator for MySQL/Postgres — this is coherent with the stated purpose. However, the skill ships with concrete connection details (IP, database name, username, password, buyer tax number) in the SKILL.md examples and examples use them directly, which is not necessary for delivering the skill and is questionable as a default.
Instruction Scope
SKILL.md instructs the agent to connect to a specific host (10.115.96.247) with a clear-text username/password and to run arbitrary SQL queries against bw_jms_main1. While running queries is expected, the instructions embed and promote using those specific credentials and a taxpayer number (BUYER_TAXNO), increasing risk of unauthorized access or data exposure. The instructions do not instruct exfiltration to external endpoints, but they allow arbitrary SQL execution on that host.
Install Mechanism
No install spec or remote downloads are present; this is an instruction-only skill with a single Python module. That reduces supply-chain risk.
Credentials
The skill declares no required environment variables or credentials in metadata, yet SKILL.md and examples include hardcoded credentials (host, user, password, database) and a specific buyer tax number. Embedding concrete secrets in the skill is disproportionate and sensitive. There are no unrelated third-party credentials requested, but the included secrets themselves are problematic.
Persistence & Privilege
always is false, skill is user-invocable and allows autonomous invocation (default). The skill does not request system-wide config changes or other skills' credentials and does not require persistent installation steps.
如何使用
- 确保已安装 OpenClaw(本地或 Docker 部署)
- 在对话框中输入安装命令:
/install querydb-skill - 安装完成后,直接呼叫该 Skill 的名称或使用
/querydb-skill触发 - 根据 Skill 的参数说明提供必要输入,即可获得结构化输出
版本历史
v1.0.0
Initial release of QueryDB Skill for database query and test case generation.
- Provides MySQL/PostgreSQL querying via DatabaseClient class.
- DbFixture supports injecting real DB data into test case templates.
- TestCaseGenerator automates generation of API test cases from DB scenarios.
- Includes sample SQL, mapping rules, and invoice type logic for various invoice categories.
- Documentation covers usage patterns and best practices for practical integration.
元数据
常见问题
querydb-skill 是什么?
数据库查询 Skill。当用户需要连接 MySQL/PostgreSQL 等数据库执行 SQL 查询、获取测试数据、验证接口返回数据时使用此 Skill。 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件,目前累计下载 94 次。
如何安装 querydb-skill?
在 OpenClaw 或 Claude Code 对话框中运行命令「/install querydb-skill」即可一键安装,无需额外配置。
querydb-skill 是免费的吗?
是的,querydb-skill 完全免费,采用 MIT-0 许可证,可自由下载、安装和使用。
querydb-skill 支持哪些平台?
querydb-skill 跨平台运行,可在任意部署了 OpenClaw / Claude Code 的环境中使用(cross-platform)。
谁开发了 querydb-skill?
由 squidtestgary(@squidtestgary)开发并维护,当前版本 v1.0.0。
推荐 Skills