Menu
用于从MySQL表的文本列中提取特定URL参数（如loc）的域名，并统计每个域名的出现次数，按降序排列。
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/ECNU-ICALK/AutoSkill --skill mysqlurlThe 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
| id | f6082de5-780b-4fd8-83bd-2b3cd55cf6ee |
| name | MySQL提取URL参数域名并统计 |
| description | 用于从MySQL表的文本列中提取特定URL参数（如loc）的域名，并统计每个域名的出现次数，按降序排列。 |
| version | 0.1.0 |
| tags | ["mysql","sql","url解析","数据统计","日志分析"] |
| triggers | ["mysql提取loc域名","统计url参数域名","mysql提取参数并统计","cloak_logs分析","提取url参数域名"] |
用于从MySQL表的文本列中提取特定URL参数（如loc）的域名，并统计每个域名的出现次数，按降序排列。
你是一个MySQL数据分析专家。你的任务是根据用户提供的表名、列名和URL参数名，编写SQL语句。你需要从包含URL路径及参数的文本列中，提取出指定参数值中的域名，并统计每个域名的重复次数，最后按次数降序输出。
SUBSTRING_INDEX 函数从URL字符串中提取目标参数的值。
...¶m=value&...。param= 之后的部分。& 之前的部分（即参数值）。SUBSTRING_INDEX 去除协议部分（://）。SUBSTRING_INDEX 提取第一个 / 之前的部分作为域名。GROUP BY 对提取出的域名进行分组。COUNT(*) 统计每个域名的出现次数。ORDER BY count DESC 按照次数降序排列。cloak_logs，列名为 parameter，参数名为 loc。直接输出可执行的SQL查询语句，包含必要的注释解释关键步骤。
Manage personal local Agent Skill files as an installable skill manager. Proactively and periodically detect reusable user-specific, team-specific, or broadly reusable skill material during or after meaningful sessions; run non-blocking extraction checks; offer candidate skill titles or accept a user-supplied topic when extraction direction is ambiguous; preserve the appropriate output language; search local and external skill ecosystems for similar skills; score candidates by evidence, recurrence, personal value, and portability; fully draft proposed skills or diffs before asking for approval; then, after explicit user approval, discard, improve, merge, or create `SKILL.md` folders.
布置结构化家庭作业，引导求助者记录现实互动事件、自动思维及情绪反应，并设计简易验证行动（如主动询问、观察反证），用于检验投射性认知偏差。适用于已识别出具体非理性信念（如‘别人肯定不喜欢我’）且情绪稳定者。
结构化8次CBT咨询流程，按评估性会谈→咨询性会谈→巩固性会谈三阶段推进，整合悬搁接地技术与认知行为策略，专用于强迫症伴轻度抑郁状态、具自省力与作业执行力的成年来访者。