tekkiiiii/the-agency/backend

Claude Code and agent skill by tekkiiiii/the-agency

Trust tier 2
  • community
LLM review pending
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/backend

SKILL.md

The same SKILL.md was published earlier as tekkiiiii/the-agency/backend.

Backend Development Skill

Before Building — Clarify:

  1. Framework/Language: Node.js (Express/Fastify/Hono), Python (FastAPI/Django), Go, Java Spring?
  2. Database: Relational (PostgreSQL/MySQL) or NoSQL (MongoDB/Redis)?
  3. Auth method: JWT, sessions, OAuth, API keys?
  4. Deployment target: Serverless, containers, VPS?
  5. Scale expectations: Requests/sec, data volume?

API Design Principles

REST Best Practices
  • Use nouns for resources, verbs for HTTP methods
  • GET /users/:id not GET /getUser
  • Consistent response envelope:
json
{
"data": {},
"error": null,
"meta": { "page": 1, "total": 100 }
}
  • 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_at timestamps
  • Index foreign keys and frequently queried columns
  • Soft deletes with deleted_at when data history matters
Query Optimization
  • Avoid N+1 queries — use JOINs or eager loading
  • Use EXPLAIN ANALYZE to 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)

src/
├── routes/ # Route definitions only
├── controllers/ # Request/response handling
├── services/ # Business logic
├── repositories/ # Database queries
├── middleware/ # Auth, validation, logging
├── models/ # DB schemas/types
└── utils/ # Shared helpers

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

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
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/tekkiiiii/the-agency/backend/badge)](https://verified-skill.com/skills/tekkiiiii/the-agency/backend)

Something wrong with this skill or its page? Tell us.