SQLAdmin - CRUD Admin

The project is a FastAPI-based REST API application with SQLAlchemy and SQLAdmin integration, featuring automatic table generation and a CRUD interface for all models.

Features

• CRUD support for models: Product, Category, User
• Integrated SQLAdmin panel Automatic table creation on startup
• OpenAPI documentation available at /docs
• Authentication via User model (optional)

Project Structure

.
├── app/
│   ├── models/        # SQLAlchemy models
│   ├── schemas/       # Pydantic schemas
│   ├── admin/         # SQLAdmin configuration
│   ├── crud/          # CRUD operations
│   └── main.py        # Entry point
├── requirements.txt
└── README_en.md

Models

• Product: id, name, category_id, description, changelog
• Category: id, name
• User: id, username, email

Installation

git clone https://github.com/AlgorithmAlchemy/fastapi-sqladmin-template
cd fastapi-sqladmin-template
python -m venv venv
source venv/bin/activate  # or .\venv\Scripts\activate on Windows
pip install -r requirements.txt
uvicorn app.main:app --reload

Dependencies

• FastAPI
• SQLAlchemy
• SQLAdmin
• Uvicorn

Admin Panel

http://127.0.0.1:8000/admin

API Documentation

http://127.0.0.1:8000/docs