Skill UI

A comprehensive guide to configuring and utilizing ShellCheck for static analysis of shell scripts (Bash, sh, POSIX). This tool detects common programming pitfalls, enforces best practices, and helps ensure script reliability and portability. Ideal for setting up linting in CI/CD pipelines, pre-commit hooks, or maintaining code quality standards across a development team.

Provides systematic steps for using Shodan’s web, CLI, and API tools to enumerate exposed hosts, services, and vulnerabilities during penetration tests, with guidance on filtering, scanning, and exporting data for follow-up analysis.

A comprehensive guide and setup for building a fast, reliable local development workflow for language learning applications. It includes setting up mock tutor responses for offline testing, generating audio test fixtures using TTS, and implementing a debug mode for detailed pronunciation scoring analysis. Ideal for engineers setting up a new Speak-based integration or refining existing test pipelines.

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.

This expert skill acts as a dedicated business analyst for early-stage companies (pre-seed to Series A). It provides comprehensive, actionable analysis covering market sizing (TAM/SAM/SOM), rigorous financial modeling (LTV, CAC, cash flow), competitive strategy, and organizational planning. Use it to develop investor-ready reports and guide critical strategic decisions for founders and entrepreneurs.

This skill generates a comprehensive, investor-ready business case document. It guides users through creating detailed sections covering market analysis (TAM/SAM/SOM), solution development, competitive positioning, financial projections, go-to-market strategy, and team structure. It is essential for founders undergoing fundraising or strategic corporate planning.

Build comprehensive 3-5 year financial models essential for startup planning and fundraising. This skill meticulously projects revenue using cohort-based methods, details cost structures (COGS, S&M, R&D, G&A), plans headcount, and performs detailed cash flow analysis. It calculates critical metrics like LTV, CAC, and burn rate, providing three scenarios (conservative, base, optimistic) for robust strategic decision-making.

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.

Build comprehensive 3-5 year financial models crucial for early-stage startups. This guide covers revenue projections using cohort-based methods, detailed cost structuring (COGS, S&M, R&D, G&A), robust cash flow analysis, and multi-scenario planning (Conservative, Base, Optimistic). It provides the quantitative foundation needed for fundraising, strategic planning, and investor presentations.

This skill provides a structured approach to systematically identify security threats by applying the STRIDE methodology (Spoofing, Tampering, Repudiation, Information Disclosure, Denial of Service, Elevation of Privilege). It is crucial for conducting thorough threat modeling sessions, analyzing system architectures, reviewing security design decisions, and creating robust security documentation for compliance and auditing purposes.