Senior Backend
Scaffold REST/GraphQL APIs, tune Postgres queries, and stress-test endpoints while your agent follows senior backend conventions across Node, Go, and Python stacks.
Overview
Senior Backend is an agent skill most often used in Build (also Ship) that scaffolds APIs, optimizes databases, and load-tests backends across Node, Go, Python, Postgres, GraphQL, and REST.
Install
npx skills add https://github.com/davila7/claude-code-templates --skill senior-backendWhat is this skill?
- Python api_scaffolder with configurable templates and built-in quality checks
- Database migration tool for analysis, metrics, recommendations, and automated fixes
- API load tester for performance validation before release
- Covers Node/Express, Go, Python, Postgres, GraphQL, REST, auth, and security patterns
- Explicit invoke paths for API design, query optimization, business logic, and backend code review
- Three core Python automation scripts: API scaffolder, database migration tool, and API load tester
Adoption & trust: 2.2k installs on skills.sh; 27.8k GitHub stars; 3/3 security scanners passed (skills.sh audits).
What problem does it solve?
You need scalable API structure, sane migrations, and performance confidence but only have an agent and scattered framework docs.
Who is it for?
Indie builders shipping SaaS or API products who want scripted scaffolding plus optimization checklists in the same skill invocation.
Skip if: Pure frontend work, no-backend static sites, or teams that already maintain a locked internal platform template and forbid agent-generated scaffolds.
When should I use this skill?
Designing APIs, optimizing database queries, implementing business logic, handling authentication/authorization, or reviewing backend code.
What do I get? / Deliverables
You get scaffolded API projects, migration insights, and load-test runs aligned with senior backend patterns ready to wire into your repo and CI.
- Scaffolded API project structure from api_scaffolder.py
- Migration analysis report and recommended fixes
- Load-test results from api_load_tester.py
Recommended Skills
Journey fit
Spans multiple journey phases - primary shelf plus alternate fits below.
Backend APIs and data layers are the core Build-phase deliverable for most SaaS and API products. The skill’s scaffolding, migrations, and load-testing scripts target server-side design and persistence—not frontend or ship-only gates.
Where it fits
Spin up a REST API skeleton with auth hooks before wiring your admin UI.
Model GraphQL resolvers and Postgres schemas for a third-party integration service.
Run the API load tester against staging to catch bottlenecks pre-launch.
Ask the agent to review business logic and security patterns on a feature branch.
How it compares
Skill-backed backend playbook with runnable scripts—not a hosted BaaS or a single-language framework generator.
Common Questions / FAQ
Who is senior-backend for?
Solo and indie developers using AI coding agents to design, implement, and review server-side systems on Postgres-backed stacks.
When should I use senior-backend?
During Build when designing APIs or migrations; during Ship when load-testing endpoints or reviewing backend changes before release.
Is senior-backend safe to install?
Review the Security Audits panel on this Prism page and inspect the Python scripts locally before running them against production data or credentials.
SKILL.md
READMESKILL.md - Senior Backend
# Senior Backend Complete toolkit for senior backend with modern tools and best practices. ## Quick Start ### Main Capabilities This skill provides three core capabilities through automated scripts: ```bash # Script 1: Api Scaffolder python scripts/api_scaffolder.py [options] # Script 2: Database Migration Tool python scripts/database_migration_tool.py [options] # Script 3: Api Load Tester python scripts/api_load_tester.py [options] ``` ## Core Capabilities ### 1. Api Scaffolder Automated tool for api scaffolder tasks. **Features:** - Automated scaffolding - Best practices built-in - Configurable templates - Quality checks **Usage:** ```bash python scripts/api_scaffolder.py <project-path> [options] ``` ### 2. Database Migration Tool Comprehensive analysis and optimization tool. **Features:** - Deep analysis - Performance metrics - Recommendations - Automated fixes **Usage:** ```bash python scripts/database_migration_tool.py <target-path> [--verbose] ``` ### 3. Api Load Tester Advanced tooling for specialized tasks. **Features:** - Expert-level automation - Custom configurations - Integration ready - Production-grade output **Usage:** ```bash python scripts/api_load_tester.py [arguments] [options] ``` ## Reference Documentation ### Api Design Patterns Comprehensive guide available in `references/api_design_patterns.md`: - Detailed patterns and practices - Code examples - Best practices - Anti-patterns to avoid - Real-world scenarios ### Database Optimization Guide Complete workflow documentation in `references/database_optimization_guide.md`: - Step-by-step processes - Optimization strategies - Tool integrations - Performance tuning - Troubleshooting guide ### Backend Security Practices Technical reference guide in `references/backend_security_practices.md`: - Technology stack details - Configuration examples - Integration patterns - Security considerations - Scalability guidelines ## Tech Stack **Languages:** TypeScript, JavaScript, Python, Go, Swift, Kotlin **Frontend:** React, Next.js, React Native, Flutter **Backend:** Node.js, Express, GraphQL, REST APIs **Database:** PostgreSQL, Prisma, NeonDB, Supabase **DevOps:** Docker, Kubernetes, Terraform, GitHub Actions, CircleCI **Cloud:** AWS, GCP, Azure ## Development Workflow ### 1. Setup and Configuration ```bash # Install dependencies npm install # or pip install -r requirements.txt # Configure environment cp .env.example .env ``` ### 2. Run Quality Checks ```bash # Use the analyzer script python scripts/database_migration_tool.py . # Review recommendations # Apply fixes ``` ### 3. Implement Best Practices Follow the patterns and practices documented in: - `references/api_design_patterns.md` - `references/database_optimization_guide.md` - `references/backend_security_practices.md` ## Best Practices Summary ### Code Quality - Follow established patterns - Write comprehensive tests - Document decisions - Review regularly ### Performance - Measure before optimizing - Use appropriate caching - Optimize critical paths - Monitor in production ### Security - Validate all inputs - Use parameterized queries - Implement proper authentication - Keep dependencies updated ### Maintainability - Write clear code - Use consistent naming - Add helpful comments - Keep it simple ## Common Commands ```bash # Development npm run dev npm run build npm run test npm run lint # Analysis python scripts/database_migration_tool.py . python scripts/api_load_tester.py --analyze # Deployment docker build -t app:latest . docker-compo