← 返回 Skills 市场
Video Content Analyzer (Fixed)
作者
terrycarter1985
· GitHub ↗
· v1.0.1
· MIT-0
87
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install video-content-analyzer-fixed
功能描述
Analyze videos by extracting frames every 10s, searching web references, storing metadata in Supabase, and generating Feishu Wiki reports.
安全使用建议
This skill contains working code that requires several secrets (Supabase service role key, Google API key, Feishu app secret) but the registry metadata incorrectly lists no required env vars — treat that as a red flag. Most important: do NOT provide SUPABASE_SERVICE_ROLE_KEY unless you fully trust the source; that key bypasses row-level security and can read/modify your entire database. Prefer running the code in an isolated environment and: 1) review the source yourself (you have it) before providing secrets; 2) use a least-privilege Supabase key (a restricted service account or per-user token) instead of service_role where possible; 3) create and test with throwaway/test Supabase and Feishu projects to confirm behavior; 4) verify the Feishu app and Google CSE are yours and have appropriate scopes/quotas; 5) be cautious about the AGENTS.md/BOOTSTRAP.md guidance — those files instruct an agent to read and persist local memory files and to commit/push changes, which could expose local data if followed. If you can't audit the code or provide restricted credentials, avoid installing or run it only in an isolated container/VM.
功能分析
Type: OpenClaw Skill
Name: video-content-analyzer-fixed
Version: 1.0.1
The skill bundle provides a legitimate video analysis workflow that integrates ffmpeg for frame extraction, Google Custom Search for content referencing, Supabase for metadata storage, and Feishu Wiki for reporting. The code in src/main.py and its modules is well-structured, follows the stated purpose, and includes appropriate error handling. While the DatabaseClient (src/modules/database_client.py) utilizes a high-privilege Supabase Service Role Key to manage user profiles and assets, this behavior is explicitly documented in the SKILL.md and aligned with the workflow's requirements. The included framework files (AGENTS.md, SOUL.md) contain proactive security instructions for the agent, such as explicit prohibitions against data exfiltration and unauthorized external actions.
能力标签
能力评估
Purpose & Capability
The code implements the described features (ffmpeg extraction, Google Custom Search, Supabase storage, Feishu publishing) so functionality matches the description. However the package/registry metadata claims 'Required env vars: none' while SKILL.md and the code require multiple secrets (SUPABASE_URL, SUPABASE_SERVICE_ROLE_KEY, GOOGLE_API_KEY, GOOGLE_SEARCH_ENGINE_ID, FEISHU_APP_ID, FEISHU_APP_SECRET). Requiring a Supabase SERVICE_ROLE key is especially high privilege and not clearly necessary for normal per-user inserts (it bypasses row-level security). This mismatch between declared requirements and actual needs is incoherent and risky.
Instruction Scope
SKILL.md's runtime instructions are focused on processing a local video and publishing results. That scope matches the code. But repository includes workspace guidance files (AGENTS.md / BOOTSTRAP.md / SOUL.md / TOOLS.md) that instruct an agent to read local memory files, auto-update MEMORY.md, and 'commit and push your own changes' without explicit consent. Those additional agent-oriented instructions broaden the operational scope of the bundle beyond the stated skill and could cause an agent to access or transmit unrelated local data if followed.
Install Mechanism
There is no remote install/download step and dependencies are standard Python packages listed in requirements.txt. No external ad-hoc downloads or archive extraction are present in the manifest. Having source files included (Python modules) means code will run locally, but install mechanism itself is low risk.
Credentials
The skill requests multiple secrets in SKILL.md and the code expects them: SUPABASE_URL + SUPABASE_SERVICE_ROLE_KEY (high privilege), GOOGLE_API_KEY + GOOGLE_SEARCH_ENGINE_ID, and FEISHU_APP_ID + FEISHU_APP_SECRET. The registry metadata, however, declares no required env vars — an inconsistency. The SUPABASE_SERVICE_ROLE_KEY is particularly concerning because it grants full DB privileges and can bypass RLS, which is more access than a video-processor ordinarily needs. The number and sensitivity of secrets is high relative to the simple video-analysis description.
Persistence & Privilege
The skill is not set as always:true and uses normal autonomous invocation defaults. That is expected. However, combining autonomous invocation with the requested high-privilege SUPABASE_SERVICE_ROLE_KEY increases the potential blast radius if the skill runs autonomously or is compromised. The skill does not modify other skills or system-wide configs.
如何使用
- 确保已安装 OpenClaw(本地或 Docker 部署)
- 在对话框中输入安装命令:
/install video-content-analyzer-fixed - 安装完成后,直接呼叫该 Skill 的名称或使用
/video-content-analyzer-fixed触发 - 根据 Skill 的参数说明提供必要输入,即可获得结构化输出
版本历史
v1.0.1
Video Content Analyzer - v1.0.1
- Fixed Feishu Wiki search references rendering issues.
- Resolved Supabase metadata storage bugs.
- Improved video metadata handling for edge cases.
- Added comprehensive logging throughout the workflow.
元数据
常见问题
Video Content Analyzer (Fixed) 是什么?
Analyze videos by extracting frames every 10s, searching web references, storing metadata in Supabase, and generating Feishu Wiki reports. 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件,目前累计下载 87 次。
如何安装 Video Content Analyzer (Fixed)?
在 OpenClaw 或 Claude Code 对话框中运行命令「/install video-content-analyzer-fixed」即可一键安装,无需额外配置。
Video Content Analyzer (Fixed) 是免费的吗?
是的,Video Content Analyzer (Fixed) 完全免费,采用 MIT-0 许可证,可自由下载、安装和使用。
Video Content Analyzer (Fixed) 支持哪些平台?
Video Content Analyzer (Fixed) 跨平台运行,可在任意部署了 OpenClaw / Claude Code 的环境中使用(cross-platform)。
谁开发了 Video Content Analyzer (Fixed)?
由 terrycarter1985(@terrycarter1985)开发并维护,当前版本 v1.0.1。
推荐 Skills