tsql-master

Expert bash/shell scripting system with Bash 5.3 features, 2025 security-first practices, advanced array patterns, parallel processing, and comprehensive cross-platform support. PROACTIVELY activate for: (1) ANY bash/shell script task, (2) Windows Git Bash path conversion (MSYS_NO_PATHCONV, cygpath), (3) Bash 5.3 features (${ } in-shell substitution, ${| } REPLY syntax, BASH_TRAPSIG, GLOBSORT, fltexpr, BASH_MONOSECONDS), (4) Security-first patterns (input validation, command injection prevention), (5) ShellCheck v0.11.0 validation (SC2327/SC2328, POSIX.1-2024), (6) Advanced arrays (mapfile, readarray, associative arrays, set operations), (7) Parallel processing (GNU Parallel, xargs -P, job pools, worker patterns), (8) Process substitution and FIFOs (coprocesses, named pipes, streaming), (9) String manipulation mastery (parameter expansion, regex, pattern matching), (10) Modern automation (containers/CI/CD/cloud), (11) Scripts under 50 lines (Google Style), (12) Debugging and profiling (tracing, performance optimization), (13) DevOps/deployment automation. Provides: bash-expert agent for complex tasks, /bash-analyze for script analysis, /bash-template for production-ready templates, /bash-optimize for performance optimization, utility scripts (parallel-runner, shellcheck-batch, script-profiler), comprehensive skills for array patterns, process substitution, parallel processing, and string manipulation. Ensures secure, optimized, cloud-native scripts following 2025 standards.

Complete Azure Data Factory expertise for pipeline JSON development, validation, and optimization (2025-2026). This plugin should be used for ADF pipeline creation, activity configuration, linked services, datasets, triggers, expressions, CI/CD, Microsoft Fabric integration, Databricks orchestration, ML pipeline patterns, and debugging.

Complete Unity game development expertise. Covers C# scripting, MonoBehaviour lifecycle, UI systems (UGUI, UI Toolkit), physics, animation, networking (Netcode, Mirror, Photon), modding support, ECS/DOTS, shader development (ShaderLab, HLSL, Shader Graph), editor scripting, performance optimization, build pipelines, and Unity Gaming Services integration.

Complete Vitest 4.0 Playwright 1.56 MSW 2.x testing system with 2025 best practices and Windows/Git Bash support. PROACTIVELY activate for: (1) ANY testing task (unit/integration/E2E/visual), (2) Browser Mode testing (Vitest 4.0 stable release Oct 2025), (3) Visual regression testing (toMatchScreenshot), (4) Playwright AI Test Agents (planner/generator/healer), (5) Test annotation and metadata (Vitest 3.2+), (6) Mutation testing for quality assurance, (7) Test creation and scaffolding, (8) Playwright Traces debugging with titlePath, (9) Coverage analysis and optimization, (10) MSW 2.x mock management with happy-path-first patterns, (11) Role-based locator patterns, (12) CI/CD test setup, (13) Multi-project test architecture, (14) Line-number filtering, (15) Windows/Git Bash cross-platform testing. Provides: Vitest 4.0 features (stable browser mode, visual regression with toMatchScreenshot, Playwright trace integration, toBeInViewport matcher), Playwright 1.56 features (AI agents - Planner/Generator/Healer, VS Code 1.105+ integration, titlePath hierarchy, Debian 13), MSW 2.x best practices (Fetch API primitives, domain-based handlers), Windows/Git Bash path conversion awareness and shell detection, mutation testing capabilities, intelligent test running, auto-scaffolding with boilerplate, coverage gap analysis, advanced snapshot management, parallel execution optimization, and comprehensive cross-platform 2025-compliant test infrastructure. Ensures production-ready testing with latest patterns across all platforms including Windows Command Prompt, PowerShell, Git Bash, macOS, and Linux.

Complete FFmpeg expertise system with comprehensive coverage of FFmpeg 8.0.1 (2025-11-20) features, VIRAL VIDEO CREATION for TikTok/YouTube Shorts/Instagram Reels/Twitter, KINETIC CAPTIONS (word-grow karaoke, bounce, pop, elastic, spring physics), hardware acceleration (NVIDIA NVENC, Intel QSV, AMD AMF, VAAPI, Vulkan), Docker/container usage, Modal.com serverless containers (CPU/GPU), Cloudflare Workers/WebAssembly (ffmpeg.wasm), CI/CD runner optimization (GitHub Actions), live streaming (RTMP/HLS/DASH/SRT/WebRTC/WHIP), audio processing and normalization, encoding optimization (CRF, presets, quality tuning), FFmpeg + OpenCV integration, PyAV Python bindings (FFmpeg 8.0+ compatible), and common gotchas/troubleshooting. PROACTIVELY activate for: (1) ANY FFmpeg task (encoding, transcoding, streaming, filtering), (2) VIRAL VIDEO creation (TikTok, YouTube Shorts, Instagram Reels, Twitter/X), (3) Short-form vertical video (9:16 aspect ratio), (4) Auto-captions and animated subtitles (CapCut-style), (5) KINETIC CAPTIONS with word-grow, bounce, pop, elastic effects, (6) Karaoke-style word highlighting with animations, (7) Video hook optimization (first 3 seconds), (8) Multi-platform batch export, (9) Social media video optimization, (10) Video format conversion (MP4, WebM, MKV, AVI), (11) Hardware acceleration setup (NVENC, CUDA, QSV, VAAPI, AMF, Vulkan), (12) Docker container FFmpeg usage (jrottenberg/ffmpeg, linuxserver/ffmpeg), (13) Modal.com serverless video processing (GPU/CPU containers, parallel processing, volumes), (14) Browser/WebAssembly FFmpeg (ffmpeg.wasm), (15) Cloudflare Workers video processing, (16) GitHub Actions/CI pipeline video processing, (17) Live streaming setup (RTMP ingest, HLS/DASH/WHIP/WebRTC delivery), (18) Audio encoding/normalization (AAC, MP3, loudnorm, EBU R128), (19) Quality optimization (CRF, bitrate, presets), (20) FFmpeg debugging and error resolution, (21) VVC/H.266, AV1, HEVC encoding, (22) Filter graphs and complex filtergraphs, (23) Batch processing and automation, (24) Whisper AI subtitle generation, (25) Content creator workflows, (26) FFmpeg to OpenCV frame handoff, (27) cv2.VideoCapture vs ffmpeg subprocess, (28) BGR RGB color format conversion gotchas, (29) Frame dimension order img[y,x] vs img[x,y], (30) ffmpegcv GPU-accelerated video I/O, (31) VidGear multi-threaded streaming, (32) Decord batch video loading for ML, (33) PyAV frame-level processing (av.open, VideoFrame, AudioFrame, filter graphs), (34) Pipe frames between FFmpeg and OpenCV, (35) OpenCV + FFmpeg + Modal parallel processing, (36) PyAV installation on Ubuntu 20.04/22.04/24.04, (37) Building PyAV against custom FFmpeg, (38) PyAV FFmpeg 8.0+ compatibility and features. Provides: KINETIC CAPTIONS skill (word-grow karaoke, spring physics, elastic bounce, platform-specific timing), VIRAL VIDEO skills (platform specs, hook templates, animated captions, batch social export), PyAV integration skill (installation guides, FFmpeg 8.0+ compatibility, av.open patterns, VideoFrame/AudioFrame NumPy conversion, filter graphs, encoding/decoding, seeking, RTSP streaming, memory management, thread safety, error handling), FFmpeg 8.0.1 patch release features, FFmpeg 8.0 Huffman features (Whisper AI filter, Vulkan compute codecs for FFv1/ProRes RAW/AV1/VP9, APV codec, VVC VA-API/QSV decoding, WHIP muxer for WebRTC, colordetect/pad_cuda/scale_d3d11 filters, ProRes RAW decoder, RealVideo 6.0, G.728), FFmpeg 7.1 LTS features (VVC decoder, MV-HEVC for Apple Vision Pro, xHE-AAC, Vulkan H.264/H.265), hardware acceleration guides, Docker best practices, Modal.com parallel processing patterns, WebAssembly limitations and workarounds, CI/CD optimization strategies, streaming protocol guidance, audio processing workflows, encoding presets and recommendations, systematic debugging approaches, FFmpeg + OpenCV integration patterns, BGR/RGB color conversion, ffmpegcv/VidGear/Decord/PyAV library guidance, and production-ready 2025-2026 configurations for all platforms.