symfony-skapi-service
Create or modify API services extending BaseService. Use for business logic.
Create or modify API services extending BaseService. Use for business logic.
Comprehensive guide for working with SQLModel, PostgreSQL, and SQLAlchemy in FastAPI projects. Use when working with database operations in FastAPI including: (1) Defining SQLModel models and relationships, (2) Database connection and session management, (3) CRUD operations, (4) Query patterns and filtering, (5) Database migrations with Alembic, (6) Testing with SQLite, (7) Performance optimization and connection pooling, (8) Transaction management and error handling, (9) Advanced features like cascading deletes, soft deletes, and event listeners, (10) FastAPI integration patterns. Covers both basic and advanced database patterns for production-ready FastAPI applications.
Analyze Go REST API projects using Echo, Gin, Chi, Fiber, or standard net/http. Use when onboarding to Go web APIs, understanding routing patterns, analyzing middleware chains, reviewing handler implementations, examining request/response handling, identifying authentication patterns, and generating API endpoint documentation.
Gestione del backend Node.js (Express, Firebase, Middleware).
Implement type-safe IPC communication in Electron using Hono RPC. Use when creating API routes between main and renderer processes, setting up typed clients, or implementing request/response IPC patterns. Provides HTTP-like semantics over Electron IPC.
Standard procedure for creating robust API endpoints
Use this skill when implementing real-time features with WebSockets, including connection lifecycle management, pub/sub event patterns, state synchronization between client and server, event broadcasting, and integration with frontend state management (React Query, SWR, etc.). Covers FastAPI/Node.js/Express backends and React/Next.js/Vue frontends with fallback strategies and error recovery.
Parses and validates a handoff artifact into canonical JSON.
Create new ORPC API routes with contracts, routers, and client integration. 创建新的 ORPC API 路由,包含合约、路由器和客户端集成。 Use when: - Adding new API endpoints - Creating CRUD operations for a new entity - User mentions "new API", "add endpoint", "create route", "新增接口", "添加 API"
Extend Vendure GraphQL schema with custom types, queries, mutations, and resolvers. Handles RequestContext threading, permissions, and dual Shop/Admin API separation. Use when adding GraphQL endpoints to Vendure.
Create API Action controllers extending BaseAction. Use for API endpoints.
Error handling patterns for RawDrive. Use when implementing error boundaries, API error responses, form validation, loading states, or user-friendly error messages.
Design and implement database models following best practices with clear singular naming, proper timestamps, appropriate data types, database constraints, relationship definitions, and validation at multiple layers. Use this skill when creating new Eloquent models, defining model relationships (hasMany, belongsTo, etc.), adding fillable or guarded properties, implementing model casts for attributes, defining database constraints and foreign keys, or working with model factories and seeders. This skill applies when working on files in app/Models/ directory, creating model classes, defining table structures, or implementing model accessors and mutators.
Comprehensive backend development skill for building scalable backend systems using NodeJS, Express, Go, Python, Postgres, GraphQL, REST APIs. Includes API scaffolding, database optimization, security implementation, and performance tuning. Use when designing APIs, optimizing database queries, implementing business logic, handling authentication/authorization, or reviewing backend code.
Complete config.json CRUD operations with validation, merge strategy, and error recovery
Python type annotations and Pydantic best practices. Use when working with types, models, or data structures. Triggers on "type", "types", "typing", "Pydantic", "BaseModel", "dict", "list", "tuple", "annotation", "hint", "Any", "TypedDict", "dataclass", "model", "schema", or when defining function signatures or data models.
Fastify Node.js expert for .ts API files, REST endpoints, routes, middleware, handlers, PostgreSQL, SQL queries, pg.Pool, Zod schemas, validation, authentication, authorization, async/await, database connections, camelCase, type safety, error handling
Prevent 404s by validating all routes exist and are accessible
Guide for TypeBox schema conventions in Fastify routes and environment validation. Use when defining request/response schemas or validating configuration.
Configure middleware extension hooks for affolterNET.Web.Bff. Use when adding custom middleware, extending the pipeline, or integrating third-party components.
Write routes following the Epic architecture patterns. Use when creating HTTP endpoints for behaviors, webhooks, or streaming. Triggers on "create a route", "add a webhook", or "write a route for".
Use when creating FastAPI web applications, REST APIs, microservices, or backend services in Python. Also use for implementing FastAPI features like authentication, validation, async endpoints, dependency injection, middleware, or error handling. NOT when working with other web frameworks (Django, Flask) or frontend frameworks.
Create complete API endpoints following Clean Architecture. Use when the user wants to add a new endpoint, create an API, implement CRUD operations, or mentions "endpoint", "controller", "API", "REST".