express-api-developer

Express API development with JWT authentication implements token-based identity verification and role-based access control by validating credentials, issuing signed tokens, and enforcing permissions on endpoints. This Skill provides patterns for bcrypt password hashing, JWT middleware integration, and RBAC rule enforcement across your API routes.

ClickHouse integration with Express enables columnar analytics queries on branch detection data through dedicated query endpoints. This Skill covers ClickHouse connection setup, 3-branch column handling, query construction, and proxy endpoints that route branch service requests while maintaining authentication and audit logging.

Audit logging and rate limiting in Express track API request activity and control usage frequency through middleware. This Skill applies middleware-based rate limiting and structured audit log capture to endpoints, recording authentication events, data modifications, and branch service interactions for compliance and monitoring.

CORS and health monitoring enable secure cross-origin requests and service availability checks. This Skill configures CORS policies, implements GET /api/health/branches endpoints for branch status verification, and integrates health checks into proxy endpoints that forward requests to branch services.

Express with TypeScript provides compile-time type safety for API handlers, database queries, and payloads. This Skill applies TypeScript typings to route handlers, SQLite user storage queries, and ClickHouse branch data operations, ensuring type consistency across authentication, RBAC, and logging layers.

Configuration management centralizes environment-specific settings for database connections, authentication secrets, rate limits, and branch service URLs. This Skill structures configuration and audit logging support to handle development, testing, and production environments with modular architecture patterns.