How do I install the Query Tech Support Issues skill?

Run npx skillmds@latest add huruizhi/query-tech-support-issues in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Query Tech Support Issues safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Query Tech Support Issues?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Query Tech Support Issues free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Query Tech Support Issues?

huruizhi (@huruizhi) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Query Tech Support Issues

Name: Query Tech Support Issues
Author: huruizhi

Use when a weekly technical-support Issue list needs structured MySQL timelog data for a natural-week date range, including customer, engineer, KA status, title, URL, and time spent.

huruizhi Updated Sep 22, 2026

Docs & Writing

Install

Press C to copy

$ npx skillmds@latest add huruizhi/query-tech-support-issues

Installs into ~/.claude/skills (or .claude/skills inside a project). Restart Claude Code to pick it up.

Download .zip

＋ Add to plugin

README badge

[![SkillMD](https://skillmd.com/badge/huruizhi/query-tech-support-issues.svg)](https://skillmd.com/skills/huruizhi/query-tech-support-issues)

Trust & safety

Audits pending

Not yet audited · commit 123e30b

Works with: Claude Code Claude.ai OpenAI Codex +

File contents

Query Technical-Support Issues

Query the previous natural week in Asia/Shanghai and return a JSON object containing period, the eight-engineer roster, and items.

python3 implementation.py --output /tmp/weekly-report/01-issues.json
python3 implementation.py --date 2026-07-20 --output /tmp/weekly-report/01-issues.json
python3 implementation.py --start-date 2026-07-13 --end-date 2026-07-20

Treat --end-date as exclusive. Aggregate timeSpent by Issue and engineer. Do not filter Task_type.

Require WEEKLY_REPORT_DB_HOST, WEEKLY_REPORT_DB_USER, and WEEKLY_REPORT_DB_PASSWORD. Accept WEEKLY_REPORT_DB_PORT and WEEKLY_REPORT_DB_NAME as optional configuration.

Return 内部任务 for internal-service, cross-department, and daily-task Issues without requiring customer mapping. Return 客户未关联 for customer work that cannot be associated with customer master data.

huruizhi/codex-skills/tree/main/skills/personal/weekly-report-generator/query-tech-support-issues commit 123e30b4ce

Frequently asked questions

npx skillmds@latest add huruizhi/query-tech-support-issues