Quickstart

Build a fully functional CRUD admin interface for a blog in minutes, with automatically generated forms, lists, search, import, and export powered directly from your data models.

Installation

Install the necessary packages using your preferred package manager:

pip install starlette-admin sqlalchemy "fastapi[standard]"

uv add starlette-admin sqlalchemy "fastapi[standard]"

The complete example

Create a file named main.py and add the following code:

from contextlib import asynccontextmanager
from datetime import datetime, timezone

from fastapi import FastAPI
from sqlalchemy import create_engine
from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column
from starlette_admin.contrib.sqla import Admin, ModelView

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


class Base(DeclarativeBase):
    pass


class Post(Base):
    __tablename__ = "posts"

    id: Mapped[int] = mapped_column(primary_key=True)
    title: Mapped[str]
    content: Mapped[str]
    published: Mapped[bool] = mapped_column(default=False)
    created_at: Mapped[datetime] = mapped_column(
        default=lambda: datetime.now(timezone.utc)
    )


class PostView(ModelView):
    fields = ["id", "title", "content", "published", "created_at"]
    searchable_fields = ("title", "content")


@asynccontextmanager
async def lifespan(app: FastAPI):
    Base.metadata.create_all(engine)
    yield


# Note: This can also be replaced by Starlette(lifespan=lifespan)
app = FastAPI(lifespan=lifespan)

admin = Admin(engine, title="Blog Admin", secret_key="change-me")
admin.add_view(PostView(Post, icon="fa fa-newspaper"))
admin.mount_to(app)

Run the application

Start the development server:

fastapi dev

uv run -- fastapi dev

Open your browser and navigate to http://127.0.0.1:8000/admin.

Click Posts in the sidebar, then select Create. You now have access to paginated list, detail, create, edit, and delete pages. The system generates all of these interfaces automatically from your model definition.

How it works

The following sections explain the core components of the application.

The model

class Post(Base):
    __tablename__ = "posts"

    id: Mapped[int] = mapped_column(primary_key=True)
    title: Mapped[str]
    content: Mapped[str]
    published: Mapped[bool] = mapped_column(default=False)
    created_at: Mapped[datetime] = mapped_column(
        default=lambda: datetime.now(timezone.utc)
    )

This code uses standard SQLAlchemy 2.0. Behind the scenes, starlette-admin reads the column metadata mapped to these attributes to determine the exact HTML input to generate. For example, it creates a text input for str, a checkbox for bool, and a datetime picker for datetime.

The view

class PostView(ModelView):
    fields = ["id", "title", "content", "published", "created_at"]
    searchable_fields = ("title", "content")

PostView serves as the central object for this resource. The fields attribute controls which columns appear in the list and form, while searchable_fields enables the search bar. All configurations regarding how Post looks and behaves in the admin dashboard reside within this single class.

The admin

admin = Admin(engine, title="Blog Admin", secret_key="change-me")
admin.add_view(PostView(Post, icon="fa fa-newspaper"))
admin.mount_to(app)

The Admin class connects the database engine to the user interface.

• add_view registers your view with the sidebar. The optional icon parameter accepts any valid Font Awesome class.
• mount_to attaches the admin application to your FastAPI or Starlette application at the /admin path.

Adding a second model

You can register an unlimited number of models. For example, to add a Tag model and its corresponding view, define the classes and call add_view again:

class Tag(Base):
    __tablename__ = "tags"

    id: Mapped[int] = mapped_column(primary_key=True)
    name: Mapped[str]


class TagView(ModelView):
    fields = ["id", "name"]
    searchable_fields = ("name",)


admin.add_view(PostView(Post, icon="fa fa-newspaper"))
admin.add_view(TagView(Tag, icon="fa fa-tag"))

Refresh your browser to see both Posts and Tags appear in the sidebar. Each resource now features its own fully functional list, create, edit, and delete pages.

What's next

• Concepts: Learn the terminology for the concepts introduced here to better navigate the User Guide.
• Admin: Discover all Admin(...) options including branding, theming, authentication, security, and internationalization.
• Views: Explore every ModelView configuration option available for customizing your data presentation.