← Back to Skills Marketplace
terrycarter1985

Video Content Analyzer (Fixed)

by terrycarter1985 · GitHub ↗ · v1.0.1 · MIT-0
cross-platform ⚠ suspicious
87
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install video-content-analyzer-fixed
Description
Analyze videos by extracting frames every 10s, searching web references, storing metadata in Supabase, and generating Feishu Wiki reports.
Usage Guidance
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.
Capability Analysis
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.
Capability Tags
requires-oauth-token
Capability Assessment
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.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install video-content-analyzer-fixed
  3. After installation, invoke the skill by name or use /video-content-analyzer-fixed
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
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.
Metadata
Slug video-content-analyzer-fixed
Version 1.0.1
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 1
Frequently Asked Questions

What is Video Content Analyzer (Fixed)?

Analyze videos by extracting frames every 10s, searching web references, storing metadata in Supabase, and generating Feishu Wiki reports. It is an AI Agent Skill for Claude Code / OpenClaw, with 87 downloads so far.

How do I install Video Content Analyzer (Fixed)?

Run "/install video-content-analyzer-fixed" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is Video Content Analyzer (Fixed) free?

Yes, Video Content Analyzer (Fixed) is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does Video Content Analyzer (Fixed) support?

Video Content Analyzer (Fixed) is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created Video Content Analyzer (Fixed)?

It is built and maintained by terrycarter1985 (@terrycarter1985); the current version is v1.0.1.

💬 Comments