SQLAdmin

Overview

Use this skill to implement SQLAdmin in FastAPI/Starlette apps, wire SQLAlchemy engines/sessions (sync or async), and tailor the admin UI via ModelView configuration, authentication, templates, and extensions.

Trigger examples

• “Add an admin dashboard for my SQLAlchemy models in FastAPI.”
• “Lock down the admin so only users with role=admin can access certain models.”
• “Make SQLAdmin work with an async engine and async sessionmaker.”
• “Customize list columns and add a custom action button.”
• “Override SQLAdmin templates for a custom layout.”

Quick start

1. Create the SQLAlchemy engine (sync or async) and your models.
2. Initialize Admin(app, engine) (or pass a session_maker).
3. Define a ModelView for each model and add_view it.
4. Visit /admin (or your custom base URL).

See references/quickstart.md for a minimal setup pattern.