Backend

Provides concrete guidance for writing secure and performant database queries. Covers parameterized queries to prevent SQL injection, eager loading to avoid N+1 problems, selective column fetching, indexing strategies, transactions, timeouts, and caching. Includes specific code examples in Python and JavaScript with ORMs like SQLAlchemy and Sequelize.

This skill provides detailed guidance for building Next.js App Router API routes. It covers HTTP methods, request/response handling, streaming, error management, and includes practical examples like a blog API with Prisma and Zod validation. It addresses common needs like authentication and rate limiting.

Provides ready-to-use authentication and authorization patterns for backend applications, including JWT, session-based auth, OAuth 2.0, password security, RBAC, ABAC, and security best practices with TypeScript examples. Covers token storage, rate limiting, account lockout, MFA, and refresh token rotation.

Provides concrete guidelines for defining database models across multiple ORMs, covering naming conventions, data types, constraints, relationships, and validation. Includes specific examples for SQLAlchemy, Prisma, and ActiveRecord patterns with practical checklists.

Provides concrete Go patterns for building backend services, including project structure, error handling, HTTP handlers, repositories, context usage, middleware, configuration, and testing. Shows actual code examples for common tasks like graceful shutdown and worker pools.

This skill provides step-by-step instructions for adding new admin API endpoints to the Ghost CMS. It includes detailed reference material covering controller structure, request flow, validation, and error handling. The guide walks through file placement, routing, and testing procedures specific to Ghost's framework.

A comprehensive Python backend skill providing production-ready FastAPI patterns with clean architecture, async database operations, and repository pattern implementation.

Provides Java patterns for integrating Qdrant vector database with Spring Boot and LangChain4j. Covers client setup, collection management, vector operations, and RAG implementations. Includes Docker deployment, dependency configuration, and practical code examples for semantic search and retrieval systems.

This skill provides concrete patterns for building REST APIs with Spring Boot. It covers URL design, HTTP methods, status codes, DTOs, validation, error handling, and pagination. Includes ready-to-use Java code examples for controllers, DTOs, and global exception handlers. Focuses on separating API contracts from domain models and applying consistent architectural layers.

A comprehensive and well-structured guide for implementing the Saga Pattern in Spring Boot microservices, covering both choreography and orchestration approaches with practical considerations.

Provides structured guidance for building backend systems, covering technology selection, API design, security practices, and deployment strategies. Includes decision matrices, implementation checklists, and detailed reference files for common backend development tasks.

Provides concrete SQL and TypeScript examples for common database patterns including normalization, indexing strategies, query optimization, repository pattern implementation, and transaction handling. Covers both relational and NoSQL approaches with practical code snippets.