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
This skill evaluates industrial real estate deals by analyzing property fundamentals, comparable market data, risk factors, and investment metrics. You get detailed assessments of deal viability, market positioning, and potential returns—all structured to support your investment thesis with hard data. Whether you're analyzing a single property or comparing multiple deals, you'll receive an executive summary with a clear buy/hold/pass recommendation.
by nakano1122
You systematically analyze multi-layered enterprise architectures, identify critical trade-offs across scalability, cost, and risk, and generate documented decisions that align technical choices with business strategy. This skill produces comprehensive architecture reviews that expose hidden dependencies, quantify implementation trade-offs, and deliver prioritized, actionable recommendations backed by formal Architecture Decision Records.
by nakano1122
You can leverage Claude to conduct thorough code reviews, evaluate code quality, identify architectural issues, and provide actionable feedback to your frontend engineers. This skill helps you standardize code review practices across your team, catch bugs before production, and maintain consistent quality standards while scaling your engineering capacity.
by nakano1122
You get a structured decision-making framework tailored to scale-ups navigating rapid growth. Claude helps you evaluate technical architecture choices, plan team scaling with hiring rubrics, prioritize technical debt against velocity demands, and craft engineering strategy communications for leadership. The framework balances short-term velocity with long-term maintainability.
by nakano1122
This skill transforms complex lease agreements into clear, actionable analysis. It evaluates terms against market benchmarks, identifies negotiation leverage points, and generates professional recommendation letters that strengthen your position in lease discussions.
by nakano1122
Upload or paste office lease documents and market data, and this skill analyzes every term—from base rent to escalation clauses—to identify financial risks, flag unfavorable conditions, and generate tailored negotiation strategies backed by market comparables. You'll get a detailed risk assessment, cost-benefit breakdown, and a step-by-step negotiation playbook that strengthens your position at the bargaining table.
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
This skill helps you analyze properties systematically, generate accurate comparative market analyses (CMAs), and develop tailored negotiation strategies that give you the edge in competitive markets. You receive data-driven valuations backed by comparable sales, neighborhood trends, and property-specific factors. With built-in negotiation frameworks and offer positioning strategies, you confidently identify leverage points and market conditions to close deals at the best possible price.
by nakano1122