Skill UI

A comprehensive guide to PostgreSQL best practices, covering advanced indexing (GIN, BRIN, Partial), schema design, performance tuning, and security implementation (RLS). It details optimizing common SQL patterns like cursor pagination and UPSERT, essential for building high-performance, reliable database systems.

This utility is designed to reconcile the ADR (Architecture Decision Record) index when source files have been deleted or modified, preventing the accumulation of stale or dangling reference rows. Unlike simple upserts, this tool performs a hard purge of the entire index namespace (adr-patterns and adr-edges) and then fully rebuilds the index from the files currently present on disk. It is crucial for maintaining data integrity after deletions.

A specialized skill for analyzing client-side persistence mechanisms, including cookies, localStorage, sessionStorage, IndexedDB, and Service Workers. It is crucial for security testing and CTF environments where application behavior or critical decision branches are determined by stored session state, cached data, or local client-side variables. Use this to trace the smallest stateful sequence leading to a decisive outcome.

This skill performs a static, read-only audit of a finished .ppmplugin bundle. It acts as a crucial verification gate, ensuring the bundle is structurally sound and ready for runtime deployment. It checks archive layout, manifest schema integrity, DEX/iOS structure, and adherence to native contract rules. By identifying critical failures locally, it dramatically speeds up the development cycle and prevents difficult-to-discover runtime deployment errors.

This skill compiles the Android Kotlin source code (Module.kt) into a runtime-loadable DEX binary required for a .ppmplugin. It executes the heavy-duty Gradle build process, managing toolchain dependencies (JDK 17+, Android SDK Build-Tools 35.0.0) and verifying manifest and package alignment. It outputs the actionable DEX binary, marking a critical step in the plugin creation workflow.

Analyze binaries with radare2/r2 from the command line, including reverse engineering, disassembly, function analysis, imports/strings inspection, patching, binary diffing, hex inspection, and r2 scripting. Supports PE/ELF/Mach-O/DEX/WASM files and sub-tools like rabin2, rasm2, radiff2, and r2pipe.

Guided onboarding wizard for Ouroboros that converts users into power users. Handles runtime configuration, environment detection, Python 3.12 setup, GitHub star prompts, and multi-backend support (Claude Code, Codex, Copilot).

This comprehensive wizard guides users through setting up various AI agent clients (e.g., Claude Code, Codex, CodeBuddy) to connect with a Memory Proxy. It handles configuration scanning, gathering necessary credentials (Proxy URL, User Key), selecting the specific agent, and validating connectivity via live API health checks for multiple protocols (Anthropic, OpenAI, etc.) before writing the final configuration.

This skill manages the update process for Ouroboros. It checks the current version against the latest stable release and provides guided steps for upgrading. It strictly uses the native updater to ensure the upgrade process respects the existing execution environment, configuration profiles, and installed integrations (like Claude/Codex), minimizing risk and maintaining system integrity.

This document defines the critical architectural contract for standardizing advisory transport across diverse AI code review runtimes (e.g., Claude Code, OpenCode, Codex). It mandates that all integrations adhere to a shared Go contract, governing how review results, evidence, and validation are processed. This is essential for ensuring system integrity, managing architectural transitions, and preventing the creation of isolated, proprietary review systems.

This skill automatically scans all defined user and project skills (from SKILL.md files) to create a comprehensive, centralized index. It manages skill paths, triggers, descriptions, and scopes, ensuring that downstream agents and delegators always have an up-to-date source of truth for available functionalities. It is crucial for maintaining system integrity and avoiding redundant skill definitions.

This skill allows delegating self-contained coding tasks to assistants like Codex or Claude Code via non-interactive background processes. It supports feature development, code review, and refactoring. Use OpenSquilla's exec_command and process tools to manage sessions, poll output, and send inputs without blocking the main workflow. Ideal for tasks requiring substantial file exploration.