Claude Skills by muzhicaomingwang

小程序页面设计与代码生成工作流。 触发场景：用户提到"修改页面"、"更新UI"、"添加组件"、"调整布局"、"生成代码"、"小程序设计"。 适用于：TeamVenture 小程序的页面设计迭代、UI 组件开发、样式调整。

使用 Playwright 浏览器自动化快速创建和完善 Notion 文档。 触发场景：用户提到"Notion"、"完善文档"、"创建页面"、"填充内容"、"notion文档"。 适用于：创建新页面、修改标题、粘贴 Markdown 内容、格式化文档。

Obsidian 知识库整理工作流。 触发场景：用户提到"整理Obsidian"、"清理文件夹"、"知识库混乱"、"目录太多"、"合并分类"。 适用于：个人知识管理、笔记整理、文件夹重组。

自动发布每日科技早报播客到小宇宙平台。 触发场景：用户提到"发布播客"、"小宇宙播客"、"自动发布"、"播客上传"、"RSS发布"。 适用于：将生成的播客音频自动发布到RSS.com，并通过RSS订阅同步到小宇宙，同时发送飞书通知。

MySQL DBA skill for schema design review, indexing, query performance tuning (EXPLAIN), transaction/isolation issues, replication/high availability, backup/restore, and operational checklists. Use for tasks like diagnosing slow queries, designing keys/indexes, partitioning strategy, and safe online schema changes.

PostgreSQL DBA skill for schema design review, indexing, query tuning (EXPLAIN/ANALYZE), vacuum/autovacuum, concurrency/locking, partitioning, backup/restore, replication/HA, and safe migrations. Use for tasks like diagnosing slow queries, designing indexes and constraints, and operating Postgres in production.

Redis DBA skill for cache/data-structure design, performance tuning, memory optimization, persistence (RDB/AOF), replication/cluster, high availability (Sentinel), and operational troubleshooting. Use for tasks like diagnosing latency spikes, eviction issues, hot keys, and designing safe cache patterns.

Build, review, and refactor Next.js (App Router) frontend projects with TypeScript. Use for tasks like creating pages/layouts, routing, server components vs client components, data fetching patterns, UI component structure, forms/validation, auth integration points, env vars, linting/testing, and production deployment readiness.

Build, review, and refactor WeChat Mini Program (微信小程序) frontends. Use for tasks like WXML/WXSS/JS/TS structure, page routing, componentization, state management patterns, API requests, login/openid flows integration points, performance optimization (setData), security/privacy compliance, and release/QA checklists.

QA workflow for software projects. Use for tasks like writing test plans, deriving test cases from PRDs, risk-based testing, API testing, UI testing, test data design, defect reporting, release checklists, and setting up automation strategy (unit/integration/e2e) with clear entry/exit criteria.

UI/UE (user interface & user experience) skill for designing and reviewing interfaces. Use for tasks like creating UI specs, interaction states, component guidelines, visual hierarchy, responsive layouts, accessibility, design tokens, and handoff-ready requirements for engineers.

Review and fix PRD/BP/tech design Markdown that includes PostgreSQL table DDL and API examples. Use to enforce these conventions: no auto-increment primary keys, no foreign keys, avoid join-based designs, unique constraints written with UNIQUE (not CREATE UNIQUE INDEX), detailed COMMENTs for tables/columns, and entity/aggregate-root tables include create_time and update_time.

Build, review, and refactor Java backend services (Spring Boot). Use for tasks like REST API design, controllers/services/repositories, PostgreSQL persistence (JPA/MyBatis), migrations, configuration, security (Spring Security), observability, testing, performance tuning, and production hardening.

Build, review, and refactor Python backend services. Use for tasks like FastAPI/Flask service setup, API design, request/response schemas, database access (PostgreSQL), migrations, background jobs, observability (logging/metrics/tracing), authentication, configuration, testing, and production hardening.

Prometheus ops skill for metrics instrumentation, scraping configuration, alerting (Alertmanager), dashboarding (Grafana), SLO/SLA monitoring, and troubleshooting missing/incorrect metrics. Use for tasks like designing alert rules, improving observability, and building production monitoring runbooks.

Product strategy skill for defining positioning, ICP/JTBD, competitive analysis, moat hypotheses, pricing/packaging, GTM planning, and roadmap prioritization. Use for tasks like turning ideas into a strategy memo, writing OKRs, creating TAM/SAM/SOM, and making trade-off decisions.

Product management UX skill for designing user journeys, information architecture, interaction flows, wireframe-level specs, usability heuristics, and experiment-driven iteration. Use for tasks like refining PRDs with UX requirements, defining success metrics, writing microcopy, accessibility considerations, and conducting user testing plans.

PMO project management skill for planning and tracking delivery across teams. Use for tasks like creating project charters, WBS, timelines, RAID logs, RACI, sprint plans, status reports, risk management, stakeholder communication, and release coordination with clear milestones and acceptance criteria.

**Description**: Generate a daily technology news podcast with AI voice synthesis, covering latest tech/business news from Chinese sources. **Tags**: `audio`, `podcast`, `ai`, `tts`, `news` **Category**: Content Generation ---

Use when refactoring TeamVenture domains/architecture; enforces migration order (Planning→Authorization→Identity→Infrastructure) and preferred steps (split classes before moving packages).

Extract Xiaohongshu (小红书) noteId from shared note text or URLs, including xhslink.com short links and xiaohongshu.com/discovery/item/<noteId> links. Use when the user asks for “noteId/笔记ID”, provides a 小红书 share message, or pastes an xhslink short URL that needs redirect expansion.