ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
Debug issues by investigating logs, database state, and git history
Django architecture patterns, REST API design with DRF, ORM best practices, caching, signals, middleware, and production-grade Django apps.
Pythonic idioms, PEP 8 standards, type hints, and best practices for building robust, efficient, and maintainable Python applications.
Fix a GitHub issue following the standard workflow.
Query video analytics data and metrics from Elastic search via the VA-MCP server (port 9901).
Extracts audio, background music, and voiceovers from local videos and social media links into MP3 or WAV formats.
Generates and prompts video clips on the filmmaking canvas.
Use when planning video content strategy, writing video scripts, optimizing YouTube channels, building short-form video pipelines (Reels…
Streamlines the video production lifecycle by providing expert guidance on scripting, storyboarding, and automated editing workflows.
Download videos from YouTube and other platforms for offline viewing, editing, or archival with support for various formats and quality options.
Edit videos locally using ffmpeg. Trim, concat, resize, speed, overlay, extract audio, compress, and convert. Use when: (1) Trimming or…
AI-assisted video editing workflows for cutting, structuring, and augmenting real footage.
Extract frames or short clips from videos using ffmpeg.
Generate AI videos using varg SDK React engine.
Generate videos using local AI models (ComfyUI/Stable Video Diffusion) and auto-publish to social media platforms.
This skill should be used when the user asks to "make a GIF", "convert to GIF", "create a GIF from this video", "export as GIF", "turn…
Optimize prompts for AI video generation platforms including Sora, Runway, Pika, and Kling
Write compelling video scripts with voiceover and visual directions
Create video scripts and publishing materials for YouTubers/UP主.
Use when the user wants to write a video script for a product demo, feature walkthrough, launch video, or social media video about a…