areas/software/full-stack/skills/backend-developer/SKILL.md
Specialized skill for Python backend development using FastAPI, SQLAlchemy, and Pydantic.
npx skillsauth add sawrus/agent-guides backend-developerInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
Expertise: Python 3.12+, FastAPI, SQLAlchemy (Async), Pydantic V2, Pytest.
mypy must pass.async.except Exception:.| 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 |
Models & Migrations:
alembic revision --autogenerate -m "desc".Repositories:
Services:
async with session.begin():).API:
Tests:
client.post(...) for API tests.testing
QA Expert for writing E2E tests, test scenarios, test plans, and ensuring test coverage quality.
development
Expert UI/UX design intelligence for creating distinctive, high-craft, and mobile-first interfaces. Focuses on premium aesthetics, touch-first ergonomics, and Flutter performance.
development
Code Review Expert for static analysis, security auditing, architecture review, and ensuring code quality standards.
development
Babysit a GitHub pull request after creation by continuously polling review comments, CI checks/workflow runs, and mergeability state until the PR is merged/closed or user help is required. Diagnose failures, retry likely flaky failures up to 3 times, auto-fix/push branch-related issues when appropriate, and keep watching open PRs so fresh review feedback is surfaced promptly. Use when the user asks Codex to monitor a PR, watch CI, handle review comments, or keep an eye on failures and feedback on an open PR.