Does this skill support PostgreSQL?

Yes, it provides templates for asynchronous database connections using SQLAlchemy, which is fully compatible with PostgreSQL and other SQL databases.

Is the project structure scalable for large teams?

Yes, it follows a clean architecture that separates business logic (services) from data access (repositories), allowing teams to scale features independently.

How does it handle authentication?

The skill implements a robust JWT-based authentication pattern including password hashing via passlib and dependency-based authorization.

Can I use this for existing FastAPI projects?

While optimized for new scaffolding, the patterns and code snippets provided can be used to refactor and standardize existing FastAPI codebases to follow best practices.

FastAPI Project Scaffolding

Name: FastAPI Project Scaffolding
Author: Krosebrook

byKrosebrook

•

API Development

Generates production-grade FastAPI project structures with async patterns, dependency injection, and comprehensive CRUD implementations.

This skill streamlines the creation of high-performance Python backends by providing standardized FastAPI templates. It implements industry best practices including a clean multi-layered architecture (API, Services, Repositories), asynchronous database operations with SQLAlchemy, robust Pydantic schemas, and built-in JWT authentication. It is designed to help developers bypass the boilerplate phase and immediately begin building scalable, maintainable microservices or monolithic APIs with enterprise-ready patterns.

Key Features

011 GitHub stars

02Asynchronous SQLAlchemy database management

03Built-in JWT authentication and security workflows

04Standardized Pydantic v2 data validation

05Automated lifespan and middleware configuration

06Multi-layered architecture (Controller-Service-Repository)

Use Cases

01Migrating synchronous Python APIs to an async FastAPI architecture

02Implementing standard CRUD operations with robust error handling

03Bootstrapping a new high-performance microservice from scratch

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add krosebrook/source-of-truth-monorepo fastapi-templates

For use in Claude.ai and ChatGPT

Download Skill