publieople

Set up Alembic database migrations for FastAPI projects using async SQLAlchemy (asyncpg). Covers env.py configuration with async engine, autogenerate handling, greenfield vs brownfield migration strategies, and env var integration.

使用 CloakBrowser 绕过抖音反爬，获取真实视频 MP4 下载链接

Wan2.2 FLF2V (First/Last Frame to Video) 管线 — 生成首尾帧之间的插值视频，支持电影级镜头过渡

Use CloakBrowser (anti-detection Chromium) to access protected Chinese web platforms (Douyin/抖音, etc.) and extract structured data — intercepting API responses, extracting video/media URLs, and downloading content from sites that block standard Playwright/browser automation.

Install and diagnose Playwright-based packages (Playwright, CloakBrowser, etc.) on Linux/WSL — handles externally-managed Python, system deps, proxy-based binary downloads, and runtime troubleshooting

Exploratory QA of web apps: find bugs, evidence, reports.

llama.cpp local GGUF inference + HF Hub model discovery.

Build an end-to-end ML emotion classification pipeline from raw tabular/biosignal data — heuristic label generation, feature engineering, RandomForest training, Flask API, and SQL schema.

Use when the user asks to refactor an existing project against a modified spec, regenerate code from a changed spec, or refactor a "shit-mountain" codebase (屎山重构) back to documented intent. Triggers on phrases like "refactor to spec", "按新 spec 改", "regenerate from <spec_dir> with new requirements", or "重写这个屎山". Pairs with regent-reverse + regent-build — reverse produces a spec, the user edits specs/ to change intent, this skill rewrites the codebase to match the edited spec. Grade key is the same as regent-build: both functional-checklist.md and inventory/test-oracle.md must stay green.

Use when the user asks to rebuild a project from a REgent spec tree, run "spec → code + tests" roundtrip, or verify that a reverse-engineered spec is sufficient to reconstruct the original. Triggers on phrases like "按 spec 重建", "build from spec", "reconstruct from <spec_dir>", "verify spec sufficiency", or just "build". Pairs with `regent-reverse` — reverse produces the spec, this skill consumes it and produces runnable code graded against both `functional-checklist.md` (black-box) and `inventory/test-oracle.md` (white-box, per-function invariants). Works across languages via hermes subagent delegation.

Use when the user asks to reverse-engineer a Git repository into a structured natural-language spec, write a structured spec for any codebase, or generate "repo → spec/" output. Triggers on phrases like "还原这个仓库", "把仓库转成 spec", "reverse engineer <url>", "生成结构化说明", or when the user supplies a repo URL/path and asks REgent to describe it. Drives the agent to deeply explore the entire codebase (every file, every test, every config) before writing the spec tree. Works across Python, Rust, Go, and other languages — the rules are language-aware only where they have to be (e.g. `trait` vs `Protocol` vs interface).

高考志愿填报指南 — 从信息收集到提交志愿的全流程框架、工具推荐和排查方法。适用于需要为高考生提供选校/志愿填报建议的场景。