Backend Code Review Assistant
Catch bugs, performance issues, and security gaps before they hit production
What You Can Do
This skill systematically reviews backend code to uncover bugs, performance bottlenecks, security vulnerabilities, and architectural debt before deployment. You provide code (functions, diffs, or full files), and it delivers prioritized findings with detailed explanations and actionable fixes. Every review includes severity assessment, code examples, and concrete recommendations to improve quality and safety.
Features
detects SQL injection, authentication flaws, input validation gaps, hardcoded secrets, and OWASP Top 10 risks
identifies N+1 queries, inefficient algorithms, memory leaks, missing indexes, and bottlenecks in critical paths
checks for privilege escalation, unsafe dependencies, session management flaws, and compliance violations
evaluates code organization, separation of concerns, design patterns, and technical debt accumulation
flags outdated libraries, known vulnerabilities, version conflicts, and unsafe transitive dependencies
checks index coverage, query efficiency, constraint correctness, and scalability concerns
ensures testability, readability, style consistency, and alignment with team standards
Example Output
Finding 1: SQL Injection (Critical)
Location: Line 42 in getUserData()
Issue: Direct string interpolation in SQL query
// ❌ Vulnerable
db.query("SELECT * FROM users WHERE id = " + userId)
// ✅ Fixed
db.query("SELECT * FROM users WHERE id = $1", [userId])
Impact: Attacker can bypass authentication and exfiltrate database
Finding 2: N+1 Query Problem (High)
Location: Lines 18-22 in listUserOrders()
Issue: Loop executes query per user instead of batch
// ❌ 1000 queries for 1000 users
users.forEach(user => db.query("SELECT * FROM orders WHERE user_id = " + user.id))
// ✅ Fixed: 1 query
const orders = db.query("SELECT * FROM orders WHERE user_id = ANY($1)", [userIds])
Impact: API response time > 10 seconds for 1000 users
Finding 3: Missing Authorization (Critical)
Location: Line 15 in DELETE /api/users/:id
Issue: Endpoint lacks role check; any user can delete anyone
Fix: Add middleware requireRole('admin') before handler
What's Included
- SKILL.md file with complete review workflow and decision trees:
- Backend code review checklist (security, performance, architecture, testing):
- Vulnerability pattern library (SQL injection, XSS, CSRF, authentication bypasses):
- Performance antipattern detection guide (N+1 queries, inefficient loops, memory waste):
- Security hardening checklist (secrets, dependencies, privilege escalation):
- Architectural review framework (design patterns, separation of concerns, modularity):
- Template feedback responses for common issues:
- Before/after code examples for 20+ common fixes:
Who It's For
- Backend engineers and full-stack developers conducting peer reviews
- Senior developers and tech leads ensuring code quality before deployment
- Engineering managers overseeing team standards and architectural decisions
- DevOps and platform engineers auditing critical infrastructure code
- Security teams performing pre-release vulnerability assessments
Best For
- Pre-deployment code review of microservices and APIs
- Security audit of authentication, authorization, and data handling layers
- Performance optimization before production scaling events
- Technical debt assessment and remediation roadmap planning
- Dependency and vulnerability audits before releasing new versions
You might also like
Rapidly analyze firmware logs and diagnose hardware issues that cause device failures, connectivity problems, and performance degradation. You'll identify root causes from stack traces, crash dumps, and sensor data, then generate specific optimization recommendations. This skill transforms raw device logs into actionable debugging plans that reduce time-to-resolution from hours to minutes.
When a user uploads a file to Claude, you can intelligently detect its type and read it using the appropriate method. Instead of blindly running cat on binary files or loading massive CSVs into context, this skill routes each file type to the right tool, reading only what's needed to answer the user's question. You'll extract text from PDFs, parse structured data from CSVs and JSON, process images, and decompress archives—all without wasting context or producing garbage output.
by seifbenayed
You'll develop systematic approaches to injectable formulation design, from API selection through sterilization strategy. Claude helps you troubleshoot failed batches by analyzing root causes, recommends regulatory pathways (505(b)(2), ANDA, NDA), and provides science-backed solutions for stability, compatibility, and manufacturability challenges.
This skill helps you systematically assess integration needs across your systems, design architecture patterns that scale with your organization, and identify technical and operational risks before implementation. You'll receive architecture recommendations aligned to your business constraints, clear integration roadmaps, and risk mitigation strategies that reduce deployment surprises. Get structured decision records suitable for architecture review boards and engineering teams.
Claude analyzes your code diffs and generates standardized commit messages that follow the Conventional Commits specification. The skill automatically determines the correct commit type, scope, and description based on the changes you've made, ensuring your messages are parseable by automation tools while remaining human-readable for code reviewers.
You can transform raw text into structured, labeled datasets for machine learning, analysis, and research. This skill performs named entity recognition, sentiment classification, part-of-speech tagging, and dependency parsing—generating consistent, validated annotations at scale. Use it to prepare corpora, extract entities, classify documents, or perform linguistic analysis without manual annotation.
This skill helps you systematically analyze service mesh architectures, identify inter-service communication failures, and design optimal routing and security policies. You'll receive step-by-step troubleshooting guidance tailored to your mesh platform (Istio, Linkerd, Consul), configuration validation reports, and architectural recommendations that reduce latency, improve observability, and tighten security posture.
Query your local Screenpipe instance to retrieve screen recordings, audio transcriptions, UI element accessibility trees, keyboard/mouse input logs, and productivity analytics. You can search by keywords, filter by content type (audio, OCR, accessibility, input), set time ranges, and extract structured data about your applications, meetings, and work sessions without sending data to external servers.
by az9713