Backend Development

This skill provides expert guidance for building robust, scalable, and secure backend systems, primarily focusing on the Python/FastAPI ecosystem used in this project.

Core Capabilities

1. API Design & Implementation

• RESTful Design: Resource-oriented URLs, proper HTTP methods, and status codes.
• FastAPI Best Practices: Validation with Pydantic, dependency injection, and async handlers.
• Documentation: Automatic OpenAPI generation, clear descriptions, and examples.

2. Database Management

• Schema Design: Normalized relationships, indexing strategies, and migration management (Alembic).
• ORM Usage: SQLAlchemy async session management, repository pattern.
• Optimization: N+1 problem avoidance, query analysis, connection pooling.

3. Security

• Authentication: JWT/OAuth2 implementation, password hashing (bcrypt/argon2).
• Authorization: Role-Based Access Control (RBAC), scopes.