Backend

Master database technologies including SQL, PostgreSQL, MongoDB, Redis. Learn schema design, optimization, indexing, and data modeling strategies.

Introduce test-driven development to beginners with simple Flask/Sinatra test examples and TDD concepts

PHP 8.4+ best practices with PHPUnit 11, Composer, PSR-12 standards, and web frameworks (Laravel, Symfony).

Handles deprecated APIs, types, and modules by applying safe migration patterns. Use when encountering deprecation warnings, migrating from deprecated code, updating dependencies with breaking changes, or modernizing legacy code to use current APIs.

TypeScript SDKとzodバリデーション、Express統合を使用したModel Context Protocol (MCP) サーバー構築のガイド。TypeScriptベースのMCPサーバーの作成、デバッグ、最適化を行う際に使用してください。

Create structured use case documentation with sequence diagrams for backend systems. Use when documenting API endpoints, service interactions, event flows, or system behaviors. Triggers on requests like "document this use case", "create use case for X endpoint", "write flow documentation", or "explain how X feature works".

Build robust backend systems with modern technologies (Node.js, Python, Go, Rust), frameworks (NestJS, FastAPI, Django), databases (PostgreSQL, MongoDB, Redis), APIs (REST, GraphQL, gRPC), authentication (OAuth 2.1, JWT), testing strategies, security best practices (OWASP Top 10), performance optimization, scalability patterns (microservices, caching, sharding), DevOps practices (Docker, Kubernetes, CI/CD), and monitoring. Use when designing APIs, implementing authentication, optimizing database queries, setting up CI/CD pipelines, handling security vulnerabilities, building microservices, or developing production-ready backend systems.

Dockerizes backend projects with auto-detection, latest base images via web search, Dockerfile generation, and Makefile with port override support.

Mocks APIs with Mock Service Worker including request handlers, server/browser setup, and testing integration. Use when mocking APIs in tests, developing without backend, or simulating network conditions.

Generate code in SLOP (Symbolic LLM-Optimized Programming), a language designed forminimal human involvement in coding. Use when: (1) User asks for SLOP code, (2) Needstrong contracts and range types, (3) Creating code with typed holes for incrementalgeneration, (4) Generating efficient C code. SLOP uses S-expression syntax and transpiles to C.

Expert RP2350 development with MicroPython, covering Pimoroni Presto hardware, touchscreen interfaces, RGB lighting control, BLE server implementation, and display rendering. Use when developing for RP2350 boards, implementing touch UI, managing BLE communication, or working with RGB backlights.

Maintaining code quality and standards in StickerNest. Use when refactoring code, checking file sizes, splitting large files, reviewing code structure, or when files exceed length limits. Covers file length limits, refactoring patterns, code organization, and the "check existing code first" principle.

Generate C++ and Python code from Protocol Buffer definitions. Use when user asks to generate proto files, compile protos, regenerate gRPC code, or mentions protobuf/gRPC generation.

Bootstraps complete backend with Apso, including API setup, database configuration, and testing. Triggers when user needs to create backend, setup API, or initialize server.

Official NestJS starter with modular architecture and Jest testing.

This skill should be used when the user asks "what plugins are available", "list data science tools", "what MCP servers can I use", "enable code intelligence", or needs to discover available plugins like serena, context7, or data access skills like wrds and lseg-data.

Kotlin best practices with Android development, Spring Boot backend, and modern coroutines for 2025

Format code using dotnet format, prettier, and other formatting tools. Use when task involves code style fixes, formatting consistency, or preparing code for commit.

Design and implement end-to-end type-safe APIs using tRPC with proper router organization, procedure definitions, input validation with Zod schemas, context management, and middleware. Use this skill when creating or modifying tRPC router files like server/routers/*.ts, src/server/api/routers/*.ts, *.router.ts, or any files containing tRPC procedure definitions, queries, and mutations. Use this when defining tRPC routers with .query() for read operations and .mutation() for write operations, implementing input validation using Zod schemas with .input(z.object({...})) for type-safe runtime validation of all procedure parameters, creating and organizing reusable sub-routers by feature or domain (user router, post router, comment router) and composing them into a main app router using mergeRouters or router nesting, setting up tRPC context in createContext functions to provide request-scoped data like user sessions, database connections, or authentication state to all procedures, implementing tRPC middleware wit

Expert skill for implementing JWT-based authentication in FastAPI applications. Handles token generation, verification, user authentication, protected routes, and security best practices. Includes setup for password hashing, OAuth2 schemes, and user data isolation. Use when implementing JWT authentication in FastAPI applications, securing API endpoints with token-based authentication, or implementing user registration and login functionality.