Ready to supercharge your AI agents?

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

Get Started Free →

MySQL自然周数据汇总函数生成 · ecnu-icalk | DecimalAI

databy ecnu-icalk

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

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

Source ecnu-icalk/autoskill ↗License Not recorded

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

SkillScore86Maintained

Automatic

Coding pack

Last verified 8/18/2026

What it changes

Passed 19 of 22 test cases with the skill, and 18 of 22 without it.

Without skill82%

With skill86%

Checks it passed that the model alone missed

Creates a MySQL FUNCTION structure rather than a PROCEDURE
Emits complete valid MySQL script including DELIMITER and CREATE FUNCTION statement

2 fixed17 passed either way2 still failing1 broke

Pass-rate lift: +5 pp
Tokens: +29%
Agent turns: 0%
Response time: +25%

Model gemini-3.6-flashMeasured 8/18/2026v119 of 22 cases passed with skill

Tokens, turns and time describe resource use, not a dollar price.

Use this skill

Save it into your project's skills folder. Claude Code picks it up in its next session.

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

Want it pinned and updatable? pip install "decimalai>=0.15", then decimalai skills add ecnu-icalk-mysql-07a90e, and start Claude Code with claude --plugin-dir "$(git rev-parse --show-toplevel)/.agents"

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

pip install "decimalai>=0.15"

2 · Get the skill — writes .agents/skills/ecnu-icalk-mysql-6243df/ and pins it in .decimal/skills.lock

decimalai skills add ecnu-icalk-mysql-07a90e

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

curl -fsSL --create-dirs -o .claude/skills/ecnu-icalk-mysql-6243df/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 ↗

Safety checks: 3 of 3 passed

Code scan CleanIntent PassedContent Clean

See it in action

One of 2 test cases the skill fixed. Same model, same prompt, with and without the skill.

1 of 2

Prompt

请帮我编写一个 MySQL 存储函数，用于处理指定时间范围的数据。调用时输入开始时间、结束时间及列名，函数内部按每周统计该列的总和，最终返回格式化好的周数据汇总字符串。

What was checked, without and with the skill
Checked	Without skill	With skill
Creates a MySQL FUNCTION structure rather than a PROCEDURE	Missed	Passed
Includes DELIMITER definitions surrounding the function creation body	Passed	Passed
Formats output strings using Chinese week prefix labels like 第一周	Passed	Passed

case-03 · gemini-3.6-flash · 8/18/2026 · answers are capped and redacted

What's inside

The instructions your model reads when the skill loads.

SKILL.md24 linessingle file

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函数按周统计并格式化输出
获取两个日期之间的自然周字段汇总

Track record

Benchmark

19 / 22

test cases passed, vs 18 / 22 without

Adoption

Users: 0
Times used: 0

Safety and source details

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

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

View 15 scanner checks

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

More skills from the same source and nearby in the registry, with their headline benchmark lift.

Ready to supercharge your AI agents?

See it in action

What's inside

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

Prompt

Role & Objective

Operational Rules & Constraints

Communication & Style Preferences

Triggers

Track record

Benchmark

Adoption

SkillSafety

Source

Related skills