everything-backend

Design API endpoints including resource structure, request/response schemas, error handling, authentication, and versioning. Supports REST, GraphQL, and gRPC. Creates OpenAPI/Swagger specifications. Use this skill when the user says 'design API', 'create endpoints', 'plan routes', or starting a new feature with API surface.

Design backend architecture including system structure, tech stack selection, and component boundaries. Asks questions iteratively, recommends patterns (monolith, microservices, serverless), and creates architecture documentation with mermaid diagrams. Use this skill when the user says 'design architecture', 'plan backend', or starting a new project.

Design and implement authentication and authorization for backend projects. Owns session/token/OAuth flows, JWT design, password handling, MFA, RBAC/ABAC, and secure defaults. Use this skill when the user says 'auth', 'authentication', 'authorization', 'OAuth', 'JWT', 'RBAC', 'login', 'session', 'sign in', 'sign up', 'permissions', 'roles', or 'access control'.

Design database schemas including table structures, relationships, indexes, and constraints. Recommends database type (PostgreSQL, MySQL, MongoDB, Redis), creates ERD diagrams with mermaid, and generates migration plans. Use this skill when the user says 'design database', 'create schema', 'plan tables', or starting a feature with data storage.

Own deployment and infrastructure setup for backend projects. Use this skill when the user says 'deploy', 'Docker', 'CI/CD', 'GitHub Actions', 'GitLab CI', 'Kubernetes', 'docker-compose', or 'infrastructure'. Generates container configs, local orchestration, pipeline templates, health checks, environment promotion, and deployment decision trees.

Run execution-based health checks on backend code: tests, lint/type checks, dependency audits, smoke tests, LSP diagnostics, and static anti-pattern scans. Identifies issues with severity levels and provides evidence-backed recommendations. Use this skill when the user says 'check my backend', 'health check', 'review code', 'doctor', or before deployment.

Turn backend designs into code or evolve existing code. Supports Node.js, Python, Go, and Java. Reads from memory files for full context. Activate when the user says 'implement', 'generate code', 'build this', or wants to add, split, or refactor backend code.

Own database schema evolution and migration workflows for backend projects. Guides additive changes, destructive changes, expand/contract, zero-downtime deployments, data backfills, rollback planning, and verification. Use this skill when the user says 'migration', 'migrate', 'schema evolution', 'backfill', 'alter table', 'zero downtime', 'rename column', 'add column', or 'rollback migration'.

Own observability, caching, async messaging, and config management for backend projects. Use this skill when the user says 'observability', 'logging', 'metrics', 'tracing', 'caching', 'queue', 'config', 'async', 'production-ready', or asks how to operate a backend at scale.

Route backend requests to the correct backend sub-skill.

Perform behavior-preserving refactoring on existing backend code. Supports Node.js, Python, Go, and Java. Covers splitting fat controllers and services, extracting modules, reducing coupling, dependency inversion, strangler-fig migrations, and legacy modernization. Use this skill when the user says 'refactor', 'cleanup', 'split service', 'split controller', 'reduce coupling', 'extract module', 'modernize legacy', 'strangler fig', or 'behavior-preserving refactor'.

Scan a backend project to learn its current state and keep memory files in sync. Use this skill when the user says 'explore', 'understand', 'what's here', 'scan', 'refresh memory', 'update memory', or 'sync memory'. Operates in mode=initial for first discovery or mode=sync for drift detection.

Own the testing workflow for backend projects: design test strategy, write tests, set up fixtures, mocking, coverage, and run suites. Use this skill when the user says 'test', 'testing strategy', 'write tests', 'coverage', 'fixtures', or wants to add, fix, expand, or run backend tests.

Generate beautiful, themed Mermaid diagrams from database schemas, ORM models, migrations, or user descriptions. Supports ERD, class diagrams, user/actor diagrams, flowcharts, sequence diagrams, and architecture diagrams. Use this skill when the user says 'visualize database', 'draw ERD', 'create class diagram', 'diagram schema', 'show me the database', or wants a visual representation of backend structure.