fastapi-postgres-repository

What problem does it solve?

This Skill provides a reusable PostgreSQL-backed repository layer for FastAPI apps, enabling consistent data access patterns and advanced features without duplicating code.

Core Features & Use Cases

• CRUD operations based on a flexible base repository
• Bulk upsert using ON CONFLICT for efficient batch inserts and updates
• Soft delete filtering with optional restoration support
• Integration with fastapi-pagination and fastapi-filter for paginated, queryable results
• Easy extension by creating entity-specific repositories

Quick Start

Create your first repository by inheriting from PostgresRepository and supplying your SQLAlchemy model and Pydantic schemas. Use bulk_upsert to insert or update multiple records in a single database round trip. Apply soft delete operations and leverage paginated queries in your FastAPI endpoints.