Menu
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
A direct command skips the review prompt. Inspect the source before running it.
npx skills add https://github.com/zrt-ai-lab/opencode-skills --skill smart-queryThe command stays on one line. Scroll horizontally to inspect it before copying.
Prefer a local copy? Download the files currently available to SkillsMP.
Based on SOC occupation classification
Showing SKILL.md
| name | smart-query |
| description | 智能数据库查询技能。通过SSH隧道连接线上数据库，支持自然语言转SQL、执行查询、表结构探索。当用户需要查询数据库、问数据、看表结构时使用此技能。 |
通过 SSH 隧道安全连接线上数据库，支持自然语言查询和 SQL 执行。
python .opencode/skills/smart-query/scripts/db_connector.py
python .opencode/skills/smart-query/scripts/query.py "SELECT * FROM table_name LIMIT 10"
python .opencode/skills/smart-query/scripts/query.py "SHOW TABLES"
python .opencode/skills/smart-query/scripts/query.py "DESC table_name"
参数：
-n 50：限制返回行数-f json：JSON格式输出--raw：输出原始结果（含元信息）python .opencode/skills/smart-query/scripts/schema_loader.py
生成 references/schema.md，包含所有表结构信息。
references/schema.md 了解表结构query.py 执行配置文件：config/settings.json
{
"ssh": {
"host": "SSH跳板机地址",
"port": 22,
"username": "用户名",
"password": "密码",
"key_file": null
},
"database": {
"type": "mysql",
"host": "数据库内网地址",
"port": 3306,
"database": "库名",
"username": "数据库用户",
"password": "数据库密码"
}
}
smart-query/ 目录config/settings.json.example 为 settings.jsonpip install paramiko sshtunnel pymysqlconfig/settings.json 包含敏感信息，不要提交到 Gitconfig/settings.json 加入 .gitignorepip install paramiko sshtunnel pymysql
| 脚本 | 用途 |
|---|---|
scripts/db_connector.py | SSH隧道+数据库连接，可单独运行测试连接 |
scripts/query.py | 执行SQL查询，支持表格/JSON输出 |
scripts/schema_loader.py | 加载表结构，生成 schema.md |
| 文档 | 说明 |
|---|---|
references/schema.md | 数据库表结构（运行 schema_loader.py 生成） |