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 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
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
Create comprehensive digital transformation roadmaps that span 3-5 years with phased initiatives, business cases, and risk mitigation strategies. This skill helps you align technology investments with business objectives, prioritize competing initiatives by impact and effort, and communicate transformation plans clearly to executive stakeholders. You'll generate ROI projections, resource requirements, and success metrics for each phase.
by nakano1122
Perform comprehensive financial analysis on multifamily acquisitions, from pro forma development to underwriting memoranda. Generate sensitivity analyses, cash flow projections, and investment metrics (IRR, CoC, NOI) that help you evaluate deal quality and portfolio performance. Create institutional-grade reports with rent rolls, expense breakdowns, and risk assessments for due diligence, lender presentations, or investor pitch decks.
by nakano1122
You get immediate structured incident assessment and response coordination. Claude analyzes incident severity, impact scope, and escalation requirements—then generates decision trees, stakeholder communication templates, and post-incident review guides. This skill accelerates your response from triage through resolution to after-action review.
by nakano1122
You conduct systematic architecture reviews that identify technical risks, quantify their business impact, and prioritize technical debt for remediation. The framework generates risk matrices, compliance gap analyses, and actionable roadmaps with effort estimates—ideal for due diligence, modernization planning, or governance decision-making. You produce executive summaries that translate technical findings into business language for stakeholder alignment.
by nakano1122
Create comprehensive digital transformation roadmaps that balance business objectives with technical feasibility and stakeholder priorities. You'll develop multi-phase implementation plans with identified risks, mitigation strategies, and projected business impact — all aligned across executive, technical, and operational teams. The result is a validated, consensus-driven transformation strategy ready for board-level presentation and execution.
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