tekkiiiii/the-agency/backend
Claude Code and agent skill by tekkiiiii/the-agency
Trust tier 2
- community
Source check pending
Checking that the SKILL.md file is still in the repository.
Use when building or reviewing backend systems: APIs, database schemas, auth, file uploads, webhooks, microservices, query optimization (Node, Python, Go, Java). Covers layered architecture, REST, JWT, error handling, logging, N+1 and indexing. Not for reviewing only (use /backend-critique).
Install
npx vskill@latest install tekkiiiii/the-agency/backendSKILL.md
The same SKILL.md was published earlier as tekkiiiii/the-agency/backend.
Backend Development Skill
Before Building — Clarify:
- Framework/Language: Node.js (Express/Fastify/Hono), Python (FastAPI/Django), Go, Java Spring?
- Database: Relational (PostgreSQL/MySQL) or NoSQL (MongoDB/Redis)?
- Auth method: JWT, sessions, OAuth, API keys?
- Deployment target: Serverless, containers, VPS?
- Scale expectations: Requests/sec, data volume?
API Design Principles
REST Best Practices
- Use nouns for resources, verbs for HTTP methods
GET /users/:idnotGET /getUser- Consistent response envelope:
- Use correct HTTP status codes (200, 201, 400, 401, 403, 404, 422, 500)
- Version your API:
/api/v1/...
Request Validation
- Validate and sanitize ALL inputs before processing
- Return descriptive 422 errors with field-level messages
- Use Zod (TS), Pydantic (Python), or class-validator
Database Patterns
Schema Design
- Use UUIDs over sequential IDs for public-facing IDs
- Always include
created_at,updated_attimestamps - Index foreign keys and frequently queried columns
- Soft deletes with
deleted_atwhen data history matters
Query Optimization
- Avoid N+1 queries — use JOINs or eager loading
- Use
EXPLAIN ANALYZEto debug slow queries - Paginate all list endpoints (cursor-based for large datasets)
- Cache expensive queries with Redis (TTL based on data freshness)
Authentication & Sessions
- Hash passwords with bcrypt (cost factor 12+)
- JWT: short-lived access tokens (15min) + refresh tokens (7-30 days)
- Store refresh tokens in httpOnly cookies, not localStorage
- Always validate token on protected routes middleware-level
Error Handling
- Centralized error handler middleware
- Never expose stack traces in production responses
- Log errors with context (user ID, request ID, timestamp)
- Use structured logging (JSON) for easy querying
Code Structure (Node.js example)
Performance Checklist
- [ ] Database connections pooled (not opened per request)
- [ ] Async/await used correctly (no blocking the event loop)
- [ ] Background jobs offloaded to queue (Bull, Celery, etc.)
- [ ] Rate limiting on public endpoints
- [ ] Response compression enabled (gzip/brotli)
- [ ] Health check endpoint at
GET /health
Security Reminders
- Parameterized queries always (no string concatenation in SQL)
- CORS configured restrictively
- Helmet.js or equivalent security headers
- Secrets in environment variables, never in code
Security
- Security scanPassed, 100 of 100Pattern checks on the skill's files.
- Model reviewNot runA model review is scheduled for the next rescan.
Quality evaluation
- Task evaluationNot runNo evaluation yet. Run one in Skill Studio.
Source
- SKILL.md in the repositoryCheckingskills/backend/SKILL.md
Popularity
- Repository stars
- 3
- 7-day trend score
- 7
Stars and forks are for the whole GitHub repository, not this skill alone. Not refreshed yet.
Works with
Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.
- Claude Code
- Cursor
- GitHub Copilot
- Windsurf
- Codex
- Gemini CLI
- Cline
- Amp
- Roo Code
- Goose
- Continue
- Kilo Code
- Junie
- Trae
- OpenHands
- Qwen Code
- AI Agent
- Tabnine Chat
- Sourcegraph Cody
- Amazon Q
- Firebase Genkit
- Sweep
- Devin
- Phind
- Mentat
- Claude Desktop
- Aider
- GPT Pilot
- Plandex
- bolt.new
- v0
- Replit Agent
- Anse
- TypingMind
- BetterChatGPT
- LibreChat
- Warp AI
- Pieces
- Fig AI
Embed badge
[](https://verified-skill.com/skills/tekkiiiii/the-agency/backend)