← Back to Skills Marketplace
querydb-skill
by
squidtestgary
· GitHub ↗
· v1.0.0
· MIT-0
94
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install querydb-skill
Description
数据库查询 Skill。当用户需要连接 MySQL/PostgreSQL 等数据库执行 SQL 查询、获取测试数据、验证接口返回数据时使用此 Skill。
Usage Guidance
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.
Capability Analysis
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.
Capability Assessment
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.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install querydb-skill - After installation, invoke the skill by name or use
/querydb-skill - Provide required inputs per the skill's parameter spec and get structured output
Version History
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.
Metadata
Frequently Asked Questions
What is querydb-skill?
数据库查询 Skill。当用户需要连接 MySQL/PostgreSQL 等数据库执行 SQL 查询、获取测试数据、验证接口返回数据时使用此 Skill。 It is an AI Agent Skill for Claude Code / OpenClaw, with 94 downloads so far.
How do I install querydb-skill?
Run "/install querydb-skill" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is querydb-skill free?
Yes, querydb-skill is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does querydb-skill support?
querydb-skill is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created querydb-skill?
It is built and maintained by squidtestgary (@squidtestgary); the current version is v1.0.0.
More Skills