Backend Developer

Name: Backend Developer
Author: sawrus

ASecurity

Specialized skill for Python backend development using FastAPI, SQLAlchemy, and Pydantic.

19 stars
0 votes
0 copies
0 views
Added October 19, 2026

ai-agentspythongobashsqlfastapitestingapidatabasebackend

Works with

Security analysis

A100/100

Scanned October 19, 2026

npx -y skills add sawrus/agent-guides --skill backend-developer --agent claude-code

Installs into .claude/skills of the current project.

Are you the author of Backend Developer?

Add the live security badge to your README. It updates with every re-scan.

Security grade badge for Backend Developer

[![Security: A — Skills Directory](https://www.skillsdirectory.com/api/skills/sawrus-backend-developer/badge)](https://www.skillsdirectory.com/skills/sawrus-backend-developer)

More formats (shields.io, HTML) on the badges page. Keep it an A: scan every change in CI with Pro.

Download with Pro

SKILL.md

---
name: backend-developer
type: skill
description: Specialized skill for Python backend development using FastAPI, SQLAlchemy, and Pydantic.
inputs:
  - implementation_plan.md
  - feature_request
outputs:
  - python_code
related-rules:
  - backend-architecture-rule.md
  - code-style-guide.md
allowed-tools: Read, Write, Edit, Grep, Bash
---

# Backend Developer Skill

> **Expertise:** Python 3.12+, FastAPI, SQLAlchemy (Async), Pydantic V2, Pytest.

## 🧠 Mindset

- **Type Safety:** Uses strict type hints. `mypy` must pass.
- **Async First:** All I/O operations must be `async`.
- **Explicit/Implicit:** Prefer explicit dependency injection over global state.
- **Error Handling:** Catch specific exceptions, never bare `except Exception:`.

## 🛠️ Toolkit

| Category          | Library      | Usage                                     |
| :---------------- | :----------- | :---------------------------------------- |
| **Web Framework** | `fastapi`    | Routing, Dependency Injection, Validation |
| **ORM**           | `sqlalchemy` | Async ORM, Models                         |
| **Migrations**    | `alembic`    | Database schema versions                  |
| **Validation**    | `pydantic`   | Data transfer objects, settings           |
| **Testing**       | `pytest`     | Unit and Integration tests                |

## 📋 Implementation Checklist

1.  **Models & Migrations:**
    - Define SQLAlchemy models.
    - Generate migration: `alembic revision --autogenerate -m "desc"`.
    - **Verify architecture rules:** Models do not import from API.

2.  **Repositories:**
    - CRUD operations.
    - Return Pydantic models or ORM objects (depending on project pattern).

3.  **Services:**
    - Business logic.
    - Transaction management (`async with session.begin():`).

4.  **API:**
    - Status codes (201 for creation, 204 for no content).
    - Proper HTTP verbs.

5.  **Tests:**
    - Fixtures for DB session.
    - `client.post(...)` for API tests.