Skill UI

Guidance for Spring Boot TDD covering JUnit 5, Mockito, MockMvc, Testcontainers, JaCoCo and coverage enforcement, ideal for adding endpoints, fixing bugs, or refactoring with high confidence.

Structured pre-PR verification loop for Spring Boot projects that runs fast-build checks, static analysis, tests with coverage, security scans, formatting gates, and diff reviews to catch issues before deployment.

This skill provides systematic patterns and best practices for transforming slow database queries into high-performance operations. It covers techniques like proper indexing, query plan analysis (e.g., using EXPLAIN), schema design improvements, and resolving common issues like N+1 query problems. Use it to debug performance bottlenecks, reduce database load, and ensure scalable application backends.

A comprehensive skill for optimizing complex SQL queries, designing robust database schemas, and troubleshooting performance bottlenecks across various dialects (PostgreSQL, MySQL, etc.). Use this when queries are slow, complex set-based logic is needed (CTEs, Window Functions), or when structuring/migrating a database schema. It provides detailed query plan analysis, advanced indexing strategies, and industry best practices.

Guides analysts through automated SQL injection discovery and exploitation with SQLMap, covering enumeration, table/column mapping, data dumping, and advanced targeting across MySQL, PostgreSQL, MSSQL, Oracle, and other databases during authorized penetration tests.

Automates Sslmate Cert Spotter API workflows through Composio’s toolkit via Rube MCP, guiding you to search tool schemas, manage connections, and execute multi-tool calls while handling memory, session reuse, and pagination.

This skill guides users through a comprehensive, structured process for calculating and analyzing market opportunities for startups. It provides detailed methodologies, including bottom-up and top-down market sizing, to determine the Total Addressable Market (TAM), Serviceable Available Market (SAM), and Serviceable Obtainable Market (SOM). Use this when developing business plans, conducting feasibility studies, or assessing market potential for a new product or service.

Scans Substrate/Polkadot FRAME pallets for seven critical vulnerabilities such as arithmetic overflow, panic DoS, incorrect weights, unsigned validation issues, bad randomness, and origin flaws, making it ideal for runtime audits and pre-launch security assessments.

A comprehensive guide for deep PostgreSQL diagnostics, designed for advanced troubleshooting when standard methods fail. Covers using pg_stat_statements for identifying slow queries, analyzing lock contention with pg_locks, detecting connection leaks, debugging RLS policy conflicts, and profiling Edge Function cold starts. Essential for performance regression investigation and escalating issues to support.

This tool collects a comprehensive, redacted diagnostic bundle from a Supabase project. It systematically tests connectivity, authentication (Auth), Realtime capabilities, Storage buckets, and Row-Level Security (RLS) policies. The resulting archive is designed for sharing with support teams to accelerate troubleshooting of complex issues like connection failures or misconfigurations.

Implements a robust, enterprise-grade Role-Based Access Control (RBAC) system for Supabase. This skill teaches how to store custom roles (e.g., admin, editor, viewer) in JWT claims (`app_metadata`), enforce granular permissions, and scope access at the row level using PostgreSQL RLS policies. It covers organization scoping, role hierarchy management, and API key protection.

A comprehensive guide for structured incident response when a Supabase-backed application fails. This runbook guides users through triaging issues, verifying platform status, inspecting connection pools, debugging stuck queries using pg_stat_activity, and analyzing Edge Function logs. Essential for root cause analysis and escalating issues to support.