Skill UI

A comprehensive skill to diagnose and fix excessive Postgres egress (network data transfer) that leads to high cloud database bills. It guides the user through using `pg_stat_statements` to identify the most data-intensive queries. Key fixes include limiting selected columns (avoiding SELECT *), implementing pagination (LIMIT/OFFSET), and identifying high-frequency data sources for caching.

This comprehensive guide serves as a detailed reference for psql, the feature-rich interactive terminal for PostgreSQL. It covers connection methods (CLI flags, environment variables, ~/.pgpass), executing SQL queries, inspecting database objects using commands like \d, and managing data operations such as importing and exporting.

This guide provides a comprehensive reference and usage guide for the Redis Command Line Interface (redis-cli). It covers connecting, executing commands in different modes, and offers detailed cheat sheets for all core Redis data structures (Strings, Hashes, Lists, Sets, Sorted Sets). Crucially, it also includes important security considerations and best practices, ensuring users can manage and troubleshoot Redis databases safely from the command line.

Provides championship-grade repository hygiene and health checks. It systematically audits critical areas, including dependency health, CI/CD pipeline alignment, documentation synchronization, and detecting stray artifacts. The tool generates a prioritized, actionable cleanup plan and offers auto-fix capabilities to keep codebases pristine and production-ready.

This skill provides a structured, multi-step workflow for resolving conflicts encountered during in-progress Git merges or rebases. It guides users through analyzing conflict origins, preserving original development intents, resolving conflicting code hunks without introducing new behavior, and executing comprehensive automated checks (typechecking, testing, formatting) to ensure the resulting codebase is stable and functional.

A comprehensive guide for developers working with Supabase. Covers best practices for database interaction, robust authorization using Row Level Security (RLS), secure authentication (Auth), and integrating various Supabase products (Storage, Realtime, Edge Functions). Essential for preventing common security vulnerabilities like BOLA/IDOR and ensuring data integrity across your application stack.

A fast, grep-based linter that checks for common design system violations in CSS and component code, such as hardcoded colors, raw pixel values, and deprecated syntax. It provides immediate automated feedback to ensure code adheres to established design tokens and best practices.

Generates championship-grade, F1-inspired test suites based on the WJTTC methodology. This skill enforces a 'tests first' philosophy, analyzing the codebase to define structured test plans. It covers standard industry unit tests (Layer 1) and deep expert edge cases (Layer 2). Furthermore, it includes Signal Integrity Audits to ensure the test suite's reliability is paramount, guiding development toward maximum code quality.

A constraint-based protocol designed to professionalize existing code by normalizing comments and performing safe, non-semantic cleanup. This skill converts informal, outdated, or missing documentation into clear, concise, and professional standards without altering the core logic or behavior. Ideal for preparing code for code review, open-sourcing, or formal documentation.

A comprehensive guide detailing industry-standard best practices for building scalable and maintainable Flutter/Dart applications. This skill covers architectural patterns (MVVM, feature-based design), state management, coding standards (modern Dart features, widget usage), and testing methodologies. Use it for planning, structuring new features, reviewing existing codebases, or refactoring complex logic into robust, testable components.