# fastcrud | Benav Labs | Knowledge Base | Instagit

FastCRUD is a Python package for FastAPI, offering robust async CRUD operations and flexible endpoint creation utilities.

GitHub Stars: 1.5k

Repository: https://github.com/benavlabs/fastcrud

---

## Articles

### [How to Test FastCRUD Endpoints: A Complete Guide with Examples](/benavlabs/fastcrud/how-to-test-fastcrud-endpoints)

Easily test FastCRUD endpoints using FastAPI TestClient and async session injection. Follow our complete guide with examples to verify your auto-generated CRUD routes efficiently.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Use FastCRUD with Existing FastAPI Applications: A Complete Integration Guide](/benavlabs/fastcrud/how-to-use-fastcrud-with-existing-fastapi-applications)

Integrate FastCRUD into your existing FastAPI app. Learn how to generate async CRUD endpoints easily with the crud_router function and include it seamlessly.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Configure Response Formatting in FastCRUD: A Complete Guide](/benavlabs/fastcrud/how-to-configure-response-formatting-in-fastcrud)

Learn how to configure response formatting in FastCRUD using schema_to_select return_as_model and nest_joins for raw dictionaries or Pydantic models.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Implement Dynamic Query Building with FastCRUD: A Complete Guide](/benavlabs/fastcrud/how-to-implement-dynamic-query-building-with-fastcrud)

Learn to implement dynamic query building with FastCRUD. This guide covers using its modular pipeline of builders, processors, and filters for efficient joins, sorting, and pagination.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Use FastCRUD with SQLModel: A Complete Async CRUD Guide](/benavlabs/fastcrud/how-to-use-fastcrud-with-sqlmodel)

Learn to use FastCRUD with SQLModel for efficient async CRUD operations. This guide covers setup and best practices for faster database interactions. Enhance your Python backend development today.

- Tags: tutorial
- Published: 2026-02-26

### [How to Implement Count Operations with FastCRUD: Complete Guide with Examples](/benavlabs/fastcrud/how-to-implement-count-operations-with-fastcrud)

Learn to implement count operations with FastCRUD using its async method. Explore joins, distinct counts, and sub-queries with detailed examples for efficient data retrieval.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Use FastCRUD with Pydantic v2 Schemas: Complete Implementation Guide](/benavlabs/fastcrud/how-to-use-fastcrud-with-pydantic-v2-schemas)

Master FastCRUD with Pydantic v2 schemas. This guide shows type-safe CRUD operations for SQLAlchemy models. Accelerate your development now.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Configure Sort Parameters in FastCRUD Endpoints: A Complete Guide](/benavlabs/fastcrud/how-to-configure-sort-parameters-in-fastcrud-endpoints)

Learn to configure sort parameters in FastCRUD endpoints using query strings or the Python API. Master sorting for your API with this complete guide.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Filter Joined Data in FastCRUD Queries: Complete Guide for SQLAlchemy Relationships](/benavlabs/fastcrud/how-to-filter-joined-data-in-fastcrud-queries)

Learn to filter joined data in FastCRUD with dot-notation and FilterProcessor. This guide explains how to easily query SQLAlchemy relationships for powerful data retrieval.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Implement Upsert Operations in FastCRUD: A Complete Guide](/benavlabs/fastcrud/how-to-implement-upsert-operations-in-fastcrud)

Learn how to implement upsert operations in FastCRUD for single and multi-record updates. This guide covers native support for PostgreSQL, SQLite, and MySQL.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Use FastCRUD Relationship Auto-Detection: A Complete Guide](/benavlabs/fastcrud/how-to-use-fastcrud-with-relationship-auto-detection)

Master FastCRUD relationship auto-detection for seamless SQLAlchemy joins using auto_detect_relationships=True. Effortlessly include one-to-many relations with this guide.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Add Custom Dependencies to FastCRUD Endpoints: A Complete Guide](/benavlabs/fastcrud/how-to-add-custom-dependencies-to-fastcrud-endpoints)

Learn to add custom dependencies to FastCRUD endpoints effectively. This guide details using create_deps, read_deps, and more for seamless integration with FastAPI.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Implement Offset Pagination with FastCRUD: A Complete Guide to SQL Query Limiting](/benavlabs/fastcrud/how-to-implement-offset-pagination-with-fastcrud)

Learn how to implement offset pagination with FastCRUD easily. Utilize built-in features like PaginatedRequestQuery and get multi method for efficient SQL query limiting without manual SQL.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Configure Nested Join Responses in FastCRUD](/benavlabs/fastcrud/how-to-configure-nested-join-responses-in-fastcrud)

Configure nested join responses in FastCRUD easily. Learn to set nest_joins=True for hierarchical data or globally in your CrudRouter for simplified related data retrieval.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Use FastCRUD with Multiple Databases: PostgreSQL, MySQL, and SQLite](/benavlabs/fastcrud/how-to-use-fastcrud-with-multiple-databases-postgresql-mysql-sqlite)

Learn how to use FastCRUD with PostgreSQL, MySQL, and SQLite using SQLAlchemy 2.0. FastCRUD unifies CRUD operations across databases with automatic dialect detection for seamless integration.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Implement Dependency Injection in FastCRUD Endpoints: A Complete Guide](/benavlabs/fastcrud/how-to-implement-dependency-injection-in-fastcrud-endpoints)

Learn how to implement dependency injection in FastCRUD endpoints. This guide shows how to inject auth, logging, and custom logic into auto-generated CRUD routes.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Customize Endpoint Names in FastCRUD's crud_router: A Complete Guide](/benavlabs/fastcrud/how-to-customize-endpoint-names-in-crud_router)

Customize endpoint names in FastCRUD crud_router easily. Map operation keys to custom path segments for flexible API routing beyond default REST conventions. Learn more.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Use FastCRUD with SQLAlchemy 2.0 Async Sessions: A Complete Guide](/benavlabs/fastcrud/how-to-use-fastcrud-with-sqlalchemy-2-0-async-sessions)

Master FastCRUD with SQLAlchemy 2.0 async sessions. This guide shows how to leverage async features for efficient CRUD operations, enhancing your Python applications. Get started today.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Configure One-to-Many Relationships in FastCRUD Joins](/benavlabs/fastcrud/how-to-configure-one-to-many-relationships-in-fastcrud-joins)

Learn to configure one-to-many relationships in FastCRUD joins. Fetch parent records with nested child rows using JoinConfig and nest_joins=True for efficient data retrieval.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Set Up Soft Delete with FastCRUD: Complete Implementation Guide](/benavlabs/fastcrud/how-to-set-up-soft-delete-with-fastcrud)

Learn how to set up soft delete with FastCRUD. This guide shows you how FastCRUD updates boolean and timestamp fields instead of hard deleting records. Implement safer data management.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Implement Cursor-Based Pagination with FastCRUD for Large Datasets](/benavlabs/fastcrud/how-to-implement-cursor-based-pagination-with-fastcrud-for-large-datasets)

Learn to implement cursor-based pagination with FastCRUD for large datasets. Optimize infinite-scroll with efficient SQLAlchemy queries and avoid offset-based performance issues.

- Tags: how-to-guide
- Published: 2026-02-26

### [How to Configure Automatic Join Condition Detection in FastCRUD](/benavlabs/fastcrud/how-to-configure-automatic-join-condition-detection-in-fastcrud)

Learn how to configure automatic join condition detection in FastCRUD with auto_detect_relationships. Simplify your SQLAlchemy configurations and streamline your development.

- Tags: how-to-guide
- Published: 2026-02-26