spa-sqladmin 0.3.0

React SPA admin for SQLAlchemy with FastAPI and Starlette

---

spa-sqladmin: React SPA Admin for Starlette/FastAPI

spa-sqladmin is a modern React SPA rewrite of sqladmin providing a better UI/UX.

Main features include:

• SQLAlchemy sync/async engines
• Starlette integration
• FastAPI integration
• SQLModel support
• Modern React SPA UI with Shadcn UI, Tanstack Router, Tanstack Table, and Tanstack Query

---

Installation

$ pip install spa-sqladmin

Or with uv:

$ uv add spa-sqladmin

---

Screenshots

Quickstart

Let's define an example SQLAlchemy model:

from sqlalchemy import Column, Integer, String, create_engine
from sqlalchemy.orm import declarative_base


Base = declarative_base()
engine = create_engine(
    "sqlite:///example.db",
    connect_args={"check_same_thread": False},
)


class User(Base):
    __tablename__ = "users"

    id = Column(Integer, primary_key=True)
    name = Column(String)


Base.metadata.create_all(engine)  # Create tables

If you want to use SQLAdmin with FastAPI:

from fastapi import FastAPI
from spa_sqladmin import Admin, ModelView


app = FastAPI()
admin = Admin(app, engine)


class UserAdmin(ModelView, model=User):
    column_list = [User.id, User.name]


admin.add_view(UserAdmin)

Or if you want to use SQLAdmin with Starlette:

from spa_sqladmin import Admin, ModelView
from starlette.applications import Starlette


app = Starlette()
admin = Admin(app, engine)


class UserAdmin(ModelView, model=User):
    column_list = [User.id, User.name]


admin.add_view(UserAdmin)

Now visiting /admin on your browser you can see the SQLAdmin interface.

Find an extensive example in the example folder.

For a full overview of Admin(...) parameters, icon formats, palette syntax, and custom admin patterns, see docs/USAGE.md.

Acknowledgements

This project would not have been possible without sqladmin.