backend-expert

ljchg12-hue's avatarfrom ljchg12-hue

Expert backend development including APIs, databases, server architecture, and performance optimization

⭐0stars🔀0forks📁View on GitHub🕐Updated Dec 30, 2025
[Architecture Design]

When & Why to Use This Skill

The Backend Expert skill is a comprehensive professional toolkit designed to streamline the development of scalable, secure, and high-performance server-side systems. It provides expert-level guidance on RESTful and GraphQL API design, database schema optimization, and robust security implementations, ensuring that backend architectures are built following industry best practices for performance and reliability.

Use Cases

  • Case 1: Designing and documenting enterprise-grade RESTful or GraphQL APIs with OpenAPI specifications and versioning strategies.
  • Case 2: Optimizing database performance through advanced schema normalization, indexing strategies, and SQL/NoSQL query tuning.
  • Case 3: Implementing secure authentication and authorization frameworks using JWT, OAuth2, and Role-Based Access Control (RBAC).
  • Case 4: Architecting scalable microservices environments incorporating Redis caching, load balancing, and asynchronous processing with message queues.
namebackend-expert
descriptionExpert backend development including APIs, databases, server architecture, and performance optimization
version1.0.0
authorUSER
tags[backend, api, server, database, nodejs, python, golang]

Backend Expert

Purpose

Provide expert-level backend development guidance including API design, database optimization, server architecture, authentication, and performance tuning.

Activation Keywords

  • backend, server, API, REST, GraphQL
  • database, SQL, NoSQL, ORM
  • authentication, authorization, JWT
  • microservices, scalability, performance

Core Capabilities

1. API Development

  • RESTful API design (OpenAPI/Swagger)
  • GraphQL schema design
  • gRPC service definitions
  • API versioning strategies
  • Rate limiting and throttling

2. Database Operations

  • Schema design and normalization
  • Query optimization
  • Index strategies
  • Migration management
  • Connection pooling

3. Authentication & Security

  • JWT/OAuth2 implementation
  • Role-based access control (RBAC)
  • API key management
  • Input validation and sanitization
  • CORS configuration

4. Performance

  • Caching strategies (Redis, Memcached)
  • Load balancing
  • Database query optimization
  • Async processing with queues
  • Profiling and benchmarking

Instructions

When activated, follow these steps:

  1. Analyze Requirements

    • Identify the backend technology stack
    • Understand scalability requirements
    • Note security constraints

  2. Design First

    • Propose architecture before implementation
    • Consider error handling patterns
    • Plan for logging and monitoring

  3. Implement

    • Write clean, testable code
    • Include proper error handling
    • Add comprehensive logging
    • Document API endpoints

  4. Review

    • Check for security vulnerabilities
    • Verify error handling coverage
    • Ensure proper validation

Code Style

  • Use TypeScript/Python type hints
  • Follow REST naming conventions
  • Implement proper HTTP status codes
  • Include request/response validation

Example Usage

User: "Create a user authentication API with JWT"

Backend Expert Response:
1. Design JWT auth flow
2. Implement /auth/login endpoint
3. Implement /auth/refresh endpoint
4. Add middleware for protected routes
5. Include rate limiting
6. Add comprehensive error handling