Backend

Web crawling and scraping with analysis. Use for crawling websites, security scanning, and extracting information from web pages.

Create and manage database schema migrations following best practices for versioning, reversibility, and zero-downtime deployments. Use this skill when creating or modifying database migration files, Alembic migrations, Django migrations, Rails migrations, or any schema change scripts. Use this skill when working with database schema evolution, implementing rollback strategies, managing indexes on large tables, or separating schema changes from data migrations. Use this skill when working with files in migrations/, db/migrate/, alembic/versions/, or similar migration directories. Use this skill when creating new tables, modifying columns, adding indexes, establishing foreign key relationships, or managing database versioning in development and production environments.

WHEN: Android Kotlin code review, Jetpack Compose patterns, Coroutines/Flow checks, ViewModel structure analysisWHAT: Compose best practices + Coroutines patterns + State management + Memory leak detection + Performance optimizationWHEN NOT: KMP shared code → kotlin-multiplatform-reviewer, Backend → kotlin-spring-reviewer

Stripe Checkout for one-time payments with Express.js. Auto-creates products if not configured.

Advanced persistent context management system for web development work that never loses context between Claude Desktop sessions. Automatically tracks, saves, and restores all work context, session history, decisions, and progress across multiple sessions and projects.

Complete FastAPI development including framework fundamentals, architecture patterns (Clean Architecture, Hexagonal Architecture, DDD), dependency injection, async patterns, and best practices. Use when implementing FastAPI endpoints, architecting backend systems, or applying architectural patterns to FastAPI applications.

Automates semantic versioning and releases using Node.js semantic-release v25+ for all languages. Use when setting up automated releases, creating shareable configs, or configuring GitHub Actions.

Decode BSV transaction hex into human-readable format using WhatsOnChain API. Shows inputs, outputs, scripts, and transaction details.

Enforce proper error handling patterns. Use when writing async code, API calls, or user-facing features. Covers try-catch, error boundaries, graceful degradation, and user feedback.

Profile and optimize Python backend code using cProfile, memory profilers, and performance best practices. Use when debugging slow FastAPI code, optimizing bottlenecks, or improving application performance.

Skill for creating and editing PHP tests following Prowi conventions. Use when creating tests, updating test files, or refactoring tests. Applies proper structure, naming, factory usage, and Laravel/PHPUnit best practices.

Spec-First Development with OpenSpec for Spring Boot.Align on specifications before implementation begins.

Expert SQL Server / T-SQL developer for stored procedures, functions, query optimization, and database programming. Use for .sql files, stored procedures, functions, views, or when user mentions SQL Server, T-SQL, or database queries.

Web and code search with Exa MCP. Use for current documentation, API references, code examples, latest library info, or when the user mentions "exa", "web search", "docs", or "current API".

Write idiomatic Go code using Go 1.22+, net/http, goroutines, channels, and standard library. Use for Go files (.go), microservices, HTTP APIs, CLIs, concurrent systems, or cloud-native applications.

This skill should be used when the user asks to "detect asyncpg usage", "find asyncpg patterns", "scan for asyncpg imports", or "identify asyncpg database code in FastAPI projects". It automatically scans Python files to identify asyncpg imports, connection patterns, and query execution methods that need conversion to SQLAlchemy.

Implement comprehensive input validation on server-side with complementary client-side validation for user experience, using allowlists, type checking, and sanitization to prevent injection attacks. Use this skill when validating user inputs, form data, API requests, file uploads, query parameters, or any external data entering the application. Apply this skill when implementing server-side validation as the primary security layer, adding client-side validation for immediate user feedback, validating data types and formats, checking ranges and required fields, sanitizing inputs to prevent SQL injection and XSS attacks, using allowlists over blocklists, providing field-specific error messages, or enforcing business rules at appropriate application layers. This skill ensures validation happens at all entry points consistently, security is never dependent on client-side checks alone, users receive helpful immediate feedback, and data integrity is maintained through multiple layers of validation.

Build Telegram bots in Node.js. Use when a request mentions Telegram bot, BotFather, bot token, webhook, long polling, commands, inline keyboards, callback queries, or handling Telegram Bot API updates.

Provides a complete solution for JWT-based authentication in FastAPI applications. Use this skill when a user wants to add secure token-based authentication to their FastAPI project. This skill handles JWT creation, decoding, signature and expiration verification, password hashing, and custom claims. It includes patterns for login endpoints, protected routes using dependencies, role-based access control decorators, token refresh mechanisms, and middleware-based validation.

Implement proven backend architecture patterns including Clean Architecture, Hexagonal Architecture, and Domain-Driven Design. Use when architecting complex backend systems or refactoring existing applications for better maintainability.