FerranGuardia
32 verified skills
webapp-testing
Toolkit for interacting with and testing local web applications using Playwright. Supports verifying frontend functionality, debugging UI behavior, capturing browser screenshots, and viewing browser logs.
tools
subagent-driven-development
Use when executing implementation plans with independent tasks in the current session
development
hmac-auth
HMAC-SHA256 custom authentication for ASP.NET Web API 2. Request signing, nonce replay protection, timestamp validation, API key management, timing-safe comparison.
development
next-best-practices
Next.js best practices - file conventions, RSC boundaries, data patterns, async APIs, metadata, error handling, route handlers, image/font optimization, bundling
development
shadcn-ui
Expert guidance for integrating and building applications with shadcn/ui components, including component discovery, installation, customization, and best practices.
development
ci-cd-pipelines
CI/CD pipeline patterns for GitHub Actions, GitLab CI, testing strategies, and deployment automation
tools
aspnet-mvc5-webapi2
ASP.NET MVC 5 + Web API 2 patterns for .NET Framework 4.7. Routing, controllers, filters, model binding, DI, error handling, CORS, configuration. NOT ASP.NET Core.
development
systematic-debugging
Use when encountering any bug, test failure, or unexpected behavior, before proposing fixes
development
skills/backend/database-designer
# Database Designer - POWERFUL Tier Skill ## Overview A comprehensive database design skill that provides expert-level analysis, optimization, and migration capabilities for modern database systems. This skill combines theoretical principles with practical tools to help architects and developers create scalable, performant, and maintainable database schemas. ## Core Competencies ### Schema Design & Analysis - **Normalization Analysis**: Automated detection of normalization levels (1NF throug
tools
skills/backend/database-schema-designer
# Database Schema Designer **Tier:** POWERFUL **Category:** Engineering **Domain:** Data Architecture / Backend --- ## Overview Design relational database schemas from requirements and generate migrations, TypeScript/Python types, seed data, RLS policies, and indexes. Handles multi-tenancy, soft deletes, audit trails, versioning, and polymorphic associations. ## Core Capabilities - **Schema design** — normalize requirements into tables, relationships, constraints - **Migration genera
development
differential-review
Performs security-focused differential review of code changes (PRs, commits, diffs). Adapts analysis depth to codebase size, uses git history for context, calculates blast radius, checks test coverage, and generates comprehensive markdown reports. Automatically detects and prevents security regressions.
development
entity-framework-6
Entity Framework 6 Code-First patterns for .NET Framework 4.7. DbContext, migrations, querying, relationships, performance, bulk operations, Dapper coexistence. NOT EF Core.
development
ferran-e2e
Ferran's E2E testing methodology for Playwright. Investigative debugging, self-cleaning data patterns, systematic issue classification. Part of the Ferran series: /ferran-task (task protocol), /ferran-plan (project planning).
development
ferran-plan
Ferran's project planning protocol. Structured interview to sharpen project direction, define scope, set priorities, and produce documentation + task backlog. Use when starting a new project, redefining direction, or when the user says 'let's plan'. Part of the Ferran series: /ferran-e2e (testing), /ferran-task (task protocol).
testing
ferran-task
Ferran's task protocol. Creates well-structured, scoped task files — the atomic unit of work for one agent session. Part of the Ferran series: /ferran-e2e (testing), /ferran-plan (project planning).
testing
frontend-design
Create distinctive, production-grade frontend interfaces with high design quality. Use this skill when the user asks to build web components, pages, artifacts, posters, or applications (examples include websites, landing pages, dashboards, React components, HTML/CSS layouts, or when styling/beautifying any web UI). Generates creative, polished code and UI design that avoids generic AI aesthetics.
development
vercel-composition-patterns
React composition patterns that scale. Use when refactoring components with boolean prop proliferation, building flexible component libraries, or designing reusable APIs. Triggers on tasks involving compound components, render props, context providers, or component architecture. Includes React 19 API changes.
development
security-hardening
Application security covering input validation, auth, headers, secrets management, and dependency auditing
testing
sql-server-dapper
SQL Server patterns + Dapper + ADO.NET for .NET Framework 4.7. Connection management, parameterized queries, query optimization, indexes, transactions, stored procedures, connection pooling, maintenance.
development
supabase-postgres-best-practices
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
data-ai
frontend-craft
Unified frontend development for production-grade Next.js applications with shadcn/ui + Tailwind CSS. Use when building web apps, creating UI components, implementing design systems, styling with Tailwind, setting up Next.js projects, running visual QA tests, or coordinating frontend implementation teams.
development
typescript-advanced
Advanced TypeScript patterns including generics, conditional types, mapped types, template literals, and type guards
development
unity-di
Unity 5.x dependency injection container for .NET Framework 4.7. Container setup, lifetime managers, MVC 5 + Web API 2 integration, registration patterns. NOT Microsoft.Extensions.DependencyInjection.
tools
skills/testing/vitest-api-testing
# API Test Suite Builder **Tier:** POWERFUL **Category:** Engineering **Domain:** Testing / API Quality --- ## Overview Scans API route definitions across frameworks (Next.js App Router, Express, FastAPI, Django REST) and auto-generates comprehensive test suites covering auth, input validation, error codes, pagination, file uploads, and rate limiting. Outputs ready-to-run test files for Vitest+Supertest (Node) or Pytest+httpx (Python). --- ## Core Capabilities - **Route detection** — scan
development
web-design-guidelines
Review UI code for Web Interface Guidelines compliance. Use when asked to "review my UI", "check accessibility", "audit design", "review UX", or "check my site against best practices".
development
quartz-scheduling
Quartz.NET 3.x job scheduling for .NET Framework 4.7. Scheduler setup, job/trigger patterns, cron expressions, persistent job store, ASP.NET integration, CrystalQuartz dashboard.
development
senior-frontend
Frontend development skill for React, Next.js, TypeScript, and Tailwind CSS applications. Use when building React components, optimizing Next.js performance, analyzing bundle sizes, scaffolding frontend projects, implementing accessibility, or reviewing frontend code quality.
development
dotnet-logging
log4net + ELMAH logging and error tracking for .NET Framework 4.7. Configuration, appenders, Web API integration, error filtering, dashboard security.
development
next-upgrade
Upgrade Next.js to the latest version following official migration guides and codemods
development
next-cache-components
Next.js 16 Cache Components - PPR, use cache directive, cacheLife, cacheTag, updateTag
tools
vercel-react-best-practices
React and Next.js performance optimization guidelines from Vercel Engineering. This skill should be used when writing, reviewing, or refactoring React/Next.js code to ensure optimal performance patterns. Triggers on tasks involving React components, Next.js pages, data fetching, bundle optimization, or performance improvements.
development
test-driven-development
Use when implementing any feature or bugfix, before writing implementation code
development