#1111th of 18 in Backend and cloud templates
fastcrud
Async CRUD methods and auto-generated endpoints for FastAPI and SQLAlchemy 2.0
- Stars
- 1.6k
- License
- MIT
- Last commit
- Oct 2026
- Last release
- Oct 2026
- Language
- Python
Missed the latest GitHub check; these facts may be older.
Overview
FastCRUD is a Python library that adds async CRUD operations on SQLAlchemy 2.0 models and a crud_router helper that generates FastAPI endpoints from a model and Pydantic schemas. It supports joins with auto-detected conditions, dynamic filtering and sorting, and offset and cursor pagination. It also ships a bundled agent skill that coding tools can load through library-skills.
Who it is for: FastAPI developers who want CRUD endpoints over SQLAlchemy models
Strengths
- crud_router generates endpoints from a model plus create and update schemas
- Offset and cursor pagination built in, with auto-detected join conditions
- Can be used inside hand-written FastAPI routes via FastCRUD(Model)
- Bundled agent skill covers N+1 avoidance and when to use raw SQLAlchemy
Weaknesses
- Aggregates, CTEs, GROUP BY projections and bulk writes need raw SQLAlchemy
- Requires Python 3.10+, SQLAlchemy 2.0.21+ and Pydantic 2.4.1+
- Non-native column types such as sqlalchemy-utils may raise NotImplementedError
- Library only: no auth, billing or frontend included
What it needs
- Python
- Needs FastAPI, SQLAlchemy >=2.0.21, Pydantic >=2.4.1, SQLAlchemy-Utils (optional)
Also in Backend and cloud templates
See all 18| Rank | Project | Score |
|---|---|---|
| 1 | full-stack-fastapi-templateFastAPI and React starter with JWT auth, PostgreSQL and a generated API client | 74 out of 100 |
| 2 | agent-service-toolkitLangGraph agents served by FastAPI with a Streamlit chat client | 67 out of 100 |
| 3 | agent-landing-zoneAzure Bicep landing zone for deploying enterprise agent apps on Microsoft Foundry | 60 out of 100 |
| #4 | full-stack-ai-agent-templateProject generator for FastAPI and Next.js apps with agents and RAG | 56 out of 100 |
| #5 | fastapi-langgraph-agent-production-ready-templateFastAPI backend template for LangGraph agents with memory, auth and tracing | 55 out of 100 |