Backend Architecture Review & Performance Optimization
Analyze backend systems for architecture flaws and performance bottlenecks
What You Can Do
Conduct systematic architecture reviews that identify design patterns, scalability issues, and performance bottlenecks in your backend systems. You'll receive detailed optimization recommendations spanning database queries, API design, infrastructure decisions, and code quality improvements. The skill provides actionable prioritized findings with implementation guidance to help you architect resilient, high-performance systems.
Features
Evaluate your system against proven patterns (microservices, monolith, event-driven, etc.). Identify misaligned patterns, coupling issues, and opportunities for better separation of concerns.
Analyze code, queries, and infrastructure for latency sources. Surface N+1 queries, inefficient algorithms, cache misses, and resource contention preventing optimal throughput.
Review SQL queries, indexes, and schema design. Identify missing indexes, suboptimal joins, and normalization issues that cause slow queries and high database load.
Evaluate how your system scales horizontally and vertically. Identify stateful bottlenecks, load balancing gaps, and architectural limits preventing efficient scaling.
Assess endpoint design, authentication patterns, rate limiting, and versioning strategies. Recommend improvements for maintainability, security, and developer experience.
Evaluate containerization, orchestration, networking, and deployment strategies. Provide guidance on cloud resource sizing, CDN optimization, and cost efficiency.
Analyze cyclomatic complexity, error handling patterns, logging strategy, and testing coverage. Identify risky code patterns and maintainability concerns.
Receive a ranked list of improvements with estimated impact, effort, and dependencies. Focus your team on high-ROI optimizations first.
Example Output
Example 1: E-commerce API Review
Critical Findings:
- Product listing endpoint executing 50+ database queries (N+1 issue)
- Recommendation: Implement eager loading with JOINs → 40ms → 3ms response time
- User cart service not horizontally scalable (in-memory state)
- Recommendation: Migrate to Redis → supports 10x concurrent users
- Missing database indexes on frequently-filtered columns
- Recommendation: Add 3 compound indexes → 85% reduction in full table scans
Architecture Issues:
- Order processing tightly coupled to payment gateway → increases failure blast radius
- Recommendation: Introduce async job queue (Bull/RabbitMQ) + circuit breaker pattern
Example 2: Microservices Performance Report
Performance Metrics:
- Average response latency: 450ms (P95: 2.1s) — above SLA target of 200ms
- Database connection pool exhaustion during peak load
- Message queue backlog causing 30-minute order processing delays
Optimization Priority:
- High Impact, Low Effort: Add Redis caching layer → 60% latency reduction (2 days)
- High Impact, Medium Effort: Implement query batching + connection pooling (5 days)
- Medium Impact, Low Effort: Add distributed tracing for visibility (3 days)
Example 3: Infrastructure Scaling Gap Analysis
Current State: Single database instance, manual scaling, no load balancing
Recommended Architecture:
- Multi-AZ database with read replicas (PostgreSQL)
- Kubernetes cluster with auto-scaling based on CPU/memory
- CDN for static assets and API responses where applicable
- Estimated cost reduction: 30% with 3x throughput improvement
What's Included
- Architecture Assessment Framework: Comprehensive evaluation checklist covering design patterns, service boundaries, dependency graphs, and architectural risks specific to your tech stack.
- Performance Analysis Templates: Structured templates for profiling CPU, memory, I/O, and network usage. Includes query execution plan review and bottleneck root cause analysis.
- Database Optimization Checklist: Step-by-step guidance for indexing strategies, query optimization, connection pooling, and schema design improvements with before/after metrics.
- Scalability Roadmap: Prioritized recommendations for horizontal/vertical scaling with implementation effort estimates, infrastructure changes needed, and expected performance gains.
- Code Review Guidelines: Best practices and red flags for backend code quality, async patterns, error handling, logging, and testing strategies aligned with your architecture.
- Implementation Action Plan: Ranked list of optimizations with dependencies, effort estimates, risk assessment, and step-by-step implementation guidance for your team.
Who It's For
- Backend / Platform Engineers
- DevOps / SRE Engineers
- Solutions Architects
- Engineering Managers / Tech Leads
- CTO / VP of Engineering
Best For
- Pre-production architectural reviews
- Performance optimization sprints
- System refactoring planning
- Scaling bottleneck identification
- API endpoint optimization
You might also like
You can evaluate vendors comprehensively across security, financial stability, operations, and compliance using structured scoring matrices. Claude generates detailed risk assessments, produces vendor comparison reports, and recommends approval/rejection decisions backed by quantified scores.
by nakano1122
You can systematically identify performance bottlenecks in your frontend application across React, Vue, and Angular frameworks. This skill analyzes your codebase for common anti-patterns, runtime behavior, and bundle metrics to pinpoint the slowest components and queries. You'll receive a data-driven optimization roadmap prioritized by impact and implementation effort, complete with specific code examples and effort estimates your team can execute immediately.
by nakano1122
This skill helps you create balanced quarterly roadmaps by systematically evaluating features against infrastructure needs, team capacity, and risk factors. You'll transform vague priorities into a prioritized roadmap with clear trade-offs documented and stakeholder buy-in achieved. The output includes dependency mapping, capacity forecasts, and a phased delivery plan that scales with your team's growth.
by nakano1122
You'll structure high-stakes architectural decisions using a proven enterprise framework that systematically evaluates options, assesses risks, aligns stakeholders, and documents trade-offs. This skill guides you through decision matrices, financial impact analysis, implementation planning, and post-decision reviews—ensuring your organization makes defensible architectural choices that scale.
by nakano1122
Compile market data, identify comparable retail properties, and create professional market analysis reports that clients can trust. This skill transforms raw market information into polished, client-ready documents that justify valuations, support investment decisions, and guide retail location strategy. You'll save hours of research and formatting while delivering expert-level analysis.
by nakano1122
Claude systematically analyzes production incidents to identify root causes, contributing factors, and systemic vulnerabilities in your infrastructure. You'll receive structured postmortems that guide your team through incident timelines, pinpoint what actually failed, and prioritize infrastructure improvements that prevent recurrence. The skill also detects patterns across your incident history—revealing repeated failures that point to deeper architectural weaknesses.
by nakano1122
This skill generates comprehensive, personalized buyer education and real-time guidance tailored to each client's experience level and concerns. You'll handle objections with empathy and data-backed responses, guide clients through every transaction stage with clear next steps, and build buyer confidence that turns hesitation into action. It creates customized scripts, educational resources, and FAQ compilations that work across real estate, automotive, insurance, and B2B sales.
by nakano1122
You can rapidly map your security controls to major regulatory frameworks (SOC 2, ISO 27001, GDPR, HIPAA, PCI-DSS), automatically identify compliance gaps, and generate audit-ready evidence packages. The skill analyzes your control inventory against framework requirements, flags missing or inadequate controls, and produces structured documentation that accelerates compliance reviews and audit preparation.
by nakano1122