sql_query SKILL.md skillA
sql_query from mateaix/mateclaw is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
mdr add mateaix/mateclaw/sql_query@v1.1.0Pins v1.1.0 in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- mateaix/mateclaw
- Path
mateclaw-server/src/main/resources/skills/sql_query/SKILL.md- Versions recorded
- 3
- Latest version
- v1.1.0, committed Apr 6, 2026
- First version recorded
- Apr 6, 2026
- Size
- 3,067 bytes
- Repository stars
- 1,185
- License
- Apache-2.0
当用户提出数据查询需求（如'查数'、'查一下订单量'、'有多少用户'、'帮我跑个SQL'等），使用数据源工具发现表结构，生成并执行只读 SQL 查询。.
Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.
What the file says
# SQL 查询技能 当用户提出与数据查询相关的问题时，按照以下工作流程操作。 ## 工作流程 ### 第一步：发现数据源 调用 `query_datasource(action='list_datasources')` 查看所有可用的外部数据源。 - 如果只有一个数据源，直接使用它 - 如果有多个数据源，根据用户问题推断最相关的数据源；不确定时询问用户 ### 第二步：发现表结构 调用 `query_datasource(action='list_tables', datasourceId=<id>)` 查看数据源中的表列表。 - 根据表名和注释判断与用户问题相关的表 - 不要一次查看所有表的结构，只查看相关的 2-3 张表 ### 第三步：查看列详情 调用 `query_datasource(action='describe_table', datasourceId=<id>, tableName='<表名>')` 查看列名、类型和注释。 - 记住列名和类型，生成 SQL 时必须使用正确的列名 ### 第四步：生成 SQL 根据表结构和用户问题，生成 SELECT SQL。遵循以下规则： **SQL 生成规则：** 1. **仅生成 SELECT 语句**，绝不生成 INSERT/UPDATE/DELETE/DROP 等写操作 2. 多表查询时，所有字段必须用表别名限定（如 `t1.name`） 3. 聚合查询使用 COUNT/SUM/AVG/MAX/MIN 等函数 4. 时间过滤使用数据库对应的日期函数 5. 字符串匹配使用 LIKE 并注意大小写 6. 结果默认按合理的顺序排序（如时间倒序） 7. 系统会自动注入 LIMIT 500，无需手动添加（除非用户指定了数量） **不同数据库的注意事项：** - MySQL：日期用 `DATE_FORMAT()`、`NOW()`，字符串连接用 `CONCAT()` - PostgreSQL：日期用 `TO_CHAR()`、`NOW()`，字符串连接用 `||` - ClickHouse：日期用 `toDate()`、`today()`，注意不支持部分标准 SQL 语法 ### 第五步：执行查询 调用 `execute_sql(datasourceId=<id>, sql='<SQL>')` 执行查询。 ### 第六步：解读结果 - 用自然语言总结查询结果的要点 - 如果结果为空，分析可能的原因（表名/列名/条件有误等） - 如果需要，可以调整 SQL 重新查询 - 如果查询结果包含数值列，系统会自动生成 ECharts 图表，无需你手动生成图表代码 - **重要：不要使用 write_file 工具生成 HTML 图表文件，系统已内置图表渲染能力** ## 错误处理 …
Read the whole file at its exact version.
How to install
mdr add mateaix/mateclaw/sql_query@sha256:0311a56b075d0cb8The line at the top of this page pins the label v1.1.0, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.
[](https://markdownregistry.com/a/art_7i5aqabzwudbv5gb)
4 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 3 versions of this file, all committed on Apr 6, 2026.
| version | committed | commit | size | audit | |
|---|---|---|---|---|---|
| v1.1.0 latest | 2026-04-06 | 9d727c6 | 3,067 B | A | view · diff |
| git:20260406.3940cfd | 2026-04-06 | 3940cfd | 3,050 B | A | view · diff |
| git:20260406.10dfe35 | 2026-04-06 | 10dfe35 | 2,833 B | A | view |
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (3067 bytes)
- pass: No zero-width or bidi control characters
- pass: No instruction hidden inside an HTML comment
- pass: No link to an exfiltration or paste host
- pass: No credential-shaped string
- pass: No instruction to send local credentials anywhere
- pass: No text hidden with inline styles
- pass: No prompt-injection phrasing
- pass: No curl or wget piped into a shell
- pass: No recursive delete of root, home or parent
- pass: No instruction to read or print local credentials
- pass: No base64 blob over 200 characters
- pass: No link to a raw IP address
- pass: No script tag
Source
mateaix/mateclaw · 1,185 stars · license Apache-2.0 · pushed 2026-11-05 · branch dev
API
GET https://markdownregistry.com/api/v1/artifacts/art_7i5aqabzwudbv5gb GET https://markdownregistry.com/api/v1/resolve?ref=mateaix/mateclaw/sql_query GET https://markdownregistry.com/api/v1/blob/0311a56b075d0cb84ad8229289b87f3d14a4effb380ff859a28bb1b42fa3162e
Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.
Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.