“EN-07-AI-Native-Games-LiveOps”

Music MV Auto-Generation System

音乐 MV 自动生成系统，输入音频/歌词，自动生成匹配节拍、情绪、歌词意象的视觉 MV。

Vertical Short Video Template Engine

竖屏短视频模板引擎，面向 MCN/品牌方，提供可复用的竖屏视频模板与参数化批量渲染能力。

Video Super-Resolution + Restoration + Enhancement Toolchain

视频超分、修复与增强工具链，支持分辨率提升、去噪去模糊、插帧、老片修复、HDR 转换与画质增强。

Automated Penetration Testing Orchestration (Authorized & Compliant)

构建合规授权的自动化渗透测试编排流水线，按阶段执行验证并设置人工审批门控；仅限已签署授权的客户资产，禁止任何未授权利用。

Prompt Injection Defense Engineering

为大模型应用设计并验证提示词注入纵深防护体系；注入测试仅在书面授权的指定测试端点或授权红队环境中进行，目标为防御…

Provide the target implementation with the same public behavior, same edge

末日倒计时客服

skill测试

OWASP Top 10 Self-Audit Checklist for an Endpoint

Quick but rigorous per-endpoint security check during development — paste the handler code and get a vulnerability verdict per OWASP category.

JWT / Session Implementation Reviewer

Deep review of token-based auth: signing, expiry, rotation, revocation, and storage — catches the classic JWT mistakes.

SQL Injection / NoSQL Injection Defense Coder

Hardens data-access code and verifies every dynamic query path is parameterized.

XSS / Output Encoding & CSP Hardener

Eliminates XSS sinks in a codebase and configures a real CSP with nonce strategy.

File Upload Security Reviewer

Hardens uploads against executable content, decompression bombs, polyglots, and SSRF in import-from-URL features.

Secrets Detection & Incident Response for Leaked Keys

When credentials hit git/logs/chat: immediate containment, rotation, and remediation — executed in the right order.

PostgreSQL DBA — Schema, Indexes, Vacuum

Operational Postgres expertise: health diagnostics, indexing, vacuum/ bloat, connections, and replication.

Transaction & Isolation Level Consultant

Chooses correct locking/transaction patterns for specific race conditions; maps anomalies to concrete business bugs.

NoSQL/DynamoDB/Firestore Data Modeling

Designs access-pattern-first single-table/denormalized models — the opposite habit from relational design.

Redis / Caching Patterns & Pitfalls Consultant

Correct Redis usage: cache patterns, distributed locks done properly, rate limiters, and failure behavior.

High-Concurrency API Performance Tuning

End-to-end latency optimization for an API using flamegraphs + query analysis + caching; includes capacity math.

Frontend Performance / Core Web Vitals Specialist

Field-data-driven web performance: LCP/INP/CLS diagnosis with framework-specific fixes.

Node.js/Python/Go Runtime Tuning (Event Loop/GIL/Goroutines)

Runtime-specific performance: event-loop blocking, GC, worker pools, and profiling tools.