sql_query

A procedure for answering data questions with read-only SQL queries, such as counting users or orders. It first finds the available data source and relevant tables, then checks their columns before running a query.

In plain words
What is it for?
Use it to discover database structure, generate and run SELECT queries, filter and aggregate records, sort results, and explain the returned data.
Why use it?
It reduces errors caused by guessing table or column names and prevents write operations such as changing or deleting data. Results are summarized in plain language, with charts generated automatically when suitable.

Skill for Claude CodeCodex

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add skills/mateaix/mateclaw/sql_query
Any agent
npx skills add mateaix/mateclaw --skill sql_query
Clone the repo
git clone --depth 1 https://github.com/mateaix/mateclaw

Made for: Claude Code, Codex.

Per session 54 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 807 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5 $0.00054 $0.00807
Opus 5 $0.00027 $0.00404
Sonnet 5 $0.00011 $0.00161
Haiku 4.5 $0.00005 $0.00081

Measured yesterday against content hash 0311a56b075d, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

sql_query scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured yesterday.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

mateclaw-server/src/main/resources/skills/sql_query/SKILL.md · 72 lines

What it actually 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 图表文件,系统已内置图表渲染能力

错误处理

如果 SQL 执行失败:

  1. 仔细阅读错误信息
  2. 常见原因:列名拼写错误、类型不匹配、语法错误
  3. 根据错误修正 SQL 并重试一次
  4. 如果仍然失败,向用户说明错误原因

安全须知

  • 本工具仅支持只读查询(SELECT),写操作会被系统拒绝
  • 查询结果默认限制为 500 行
  • 查询超时为 30 秒
  • 如果用户要求执行写操作,应礼貌拒绝并说明这是安全限制
Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. yesterday First seen · 72 lines · 54 tokens per session scan A 0311a56b075d

Subscribe to this mod's changes

sql_query is a skill published in the GitHub repository mateaix/mateclaw (1,061 stars, last pushed yesterday), licensed Apache-2.0. It adds 54 tokens to every session and 807 once invoked, about $0.0003 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other skills, from other repositories

make-skill

Use this skill when sedimenting a session into a reusable workspace skill. Triggers when the user wants to turn the current conversation, workflow, or troubleshooting path into a SKILL.md. Phrases like 'turn this into a skill', 'remember how I did X', 'save this workflow', 'make a skill from this', and any /make-skill…

agentscope-ai/QwenPaw · 85 tokens

make-skill

用于把当前会话沉淀为可复用的 workspace skill。当用户希望把当前对话、工作流或排错路径写成 SKILL.md 时触发。触发表达包括「把这个变成 skill」「记住我是怎么做 X 的」「保存这个工作流」「make a skill from this」以及任何 /make-skill 调用。.

agentscope-ai/QwenPaw · 84 tokens

terraform-skill

Use when working with Terraform or OpenTofu - creating modules, writing tests (native test framework, Terratest), setting up CI/CD pipelines, reviewing configurations, choosing between testing approaches, debugging state issues, implementing security scanning (trivy, checkov), or making infrastructure-as-code…

agentscope-ai/QwenPaw · 62 tokens

docx

Use this skill whenever the user wants to create, read, edit, or manipulate Word documents (.docx files). Triggers include: any mention of "Word doc", "word document", ".docx", or requests to produce professional documents with formatting like tables of contents, headings, page numbers, or letterheads. Also use when…

agentscope-ai/QwenPaw · 168 tokens

docx

当用户需要创建、读取、编辑或处理 Word 文档(.docx)时,使用此技能。触发场景包括提到“Word 文档”、“.docx”,或要求生成带目录、标题、页码、信头等格式的专业文档;也包括提取或重组 .docx 内容、插入或替换图片、在 Word 文件中查找替换、处理修订或批注,以及将内容整理为正式 Word 文档。如果用户要求生成“报告”“备忘录”“信函”“模板”等 Word / .docx 交付物,也应使用此技能。不要用于 PDF、电子表格、Google Docs,或与文档生成无关的一般编程任务。.

agentscope-ai/QwenPaw · 161 tokens

multi_agent_collaboration

Use this skill when another agent's expertise or context is needed, or when the user explicitly asks to involve another agent. First list agents, then use qwenpaw agents chat for two-way communication with replies.

agentscope-ai/QwenPaw · 47 tokens