Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Get Started Free →

MySQL自然周数据汇总函数生成 — measured AI agent skill | DecimalAI

ecnu-icalk/MySQL自然周数据汇总函数生成

NewSkillScoreMaintained

编写MySQL函数，根据指定的日期范围和字段，按自然周汇总数据并返回特定格式的字符串结果。

Databy ecnu-icalk

Links this skill to your agents and keeps it current with the author’s updates.

Automatic

Coding pack

1 · One-time — install the CLI (docs ↗)

pip install decimalai

2 · Get the skill — writes .claude/skills/ecnu-icalk-mysql-07a90e/SKILL.md

decimalai skills pull ecnu-icalk-mysql-07a90e --out .claude/skills/

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/ecnu-icalk-mysql-07a90e/SKILL.md https://app.decimal.ai/s/ecnu-icalk-mysql-07a90e/SKILL.md

Raw file: /s/ecnu-icalk-mysql-07a90e/SKILL.md ↗ · machine-readable summary at /s/ecnu-icalk-mysql-07a90e.json ↗

In productionGlobal

how this skill behaves on real traffic · last 30 days

No production data for this skill yet — usage numbers appear here once agents start running it.

Anonymized aggregate across every org using this skill — proof from real production use, not a demo.

Does this skill help? · Benchmark: with vs. withoutsign in to run this on your agents

22 test cases from the publisher’s eval.yaml · each run twice on gemini-3.6-flash — with the skill injected, then without · last run 3h ago

Yes — +5% lift · at higher cost+29% tokens0% turns86% of whole cases pass with skill (19/22)

Test case	Without → With	Effect	Δ tokens	Δ turns
case-03	✗→✓	▲ Improved	36%	0%
case-22	✗→✓	▲ Improved	31%	0%
case-05	✓→✗	▼ Worse	-13%	0%
case-04	✓→✓	＝ Same ✓	28%	0%
case-06	✓→✓	＝ Same ✓	-7%	0%

Showing 5 of 22 cases

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/3/2026

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

ecnu-icalk / autoskill

SkillBank/ConvSkill/chinese_gpt3.5_8/mysql%E8%87%AA%E7%84%B6%E5%91%A8%E6%95%B0%E6%8D%AE%E6%B1%87%E6%80%BB%E5%87%BD%E6%95%B0%E7%94%9F%E6%88%90/SKILL.md

View on GitHub ↗

Imported 8/3/2026Version v1

Skill contents

SKILL.md

MySQL自然周数据汇总函数生成

编写MySQL函数，根据指定的日期范围和字段，按自然周汇总数据并返回特定格式的字符串结果。

Prompt

Role & Objective

你是一个MySQL数据库开发专家。你的任务是根据用户提供的日期范围和字段名，编写一个SQL函数，用于统计该日期范围内按自然周分组的数据总和。

Operational Rules & Constraints

函数入参必须包含：起始日期 (dateStart, String类型)、结束日期 (dateEnd, String类型)、统计字段名 (tableColumn, String类型)。
函数逻辑应遍历起始日期到结束日期之间的每一周。
每一周的统计逻辑为：计算该周内指定字段 (tableColumn) 的总和 (SUM)。
返回结果必须严格按照以下格式拼接字符串：“第一周：sum(tableColumn) | 第二周：sum(tableColumn) | .....”。
假设日期存储在名为 date_column 的列中（或根据上下文调整），表名为 your_table（或根据上下文调整）。

Communication & Style Preferences

输出完整的函数创建语句 (CREATE FUNCTION ...)，包含必要的 DELIMITER 设置。

Triggers

写一个sql函数汇总自然周数据
mysql函数按周统计并格式化输出
获取两个日期之间的自然周字段汇总

Want to see if ecnu-icalk/MySQL自然周数据汇总函数生成 would activate on your phrasing? Try it before you install — no LLM call, no signup.

Other measured skills in the registry, with their headline benchmark lift.