sqladmin

What it is and what it does

SQLAdmin is a web-based admin interface generator for SQLAlchemy models that works with Starlette applications. It automatically creates CRUD pages, filtering, and model management views without requiring you to write custom admin code. The interface integrates directly with your existing SQLAlchemy models and database engine.

The package handles both synchronous and asynchronous SQLAlchemy engines and supports SQLModel. Optional extras enable session-backed authentication and internationalization. You define admin views by subclassing ModelView, specify which columns to display, and register them with the Admin instance—the interface is then available at /admin.

Use it for:

• Quickly add a management interface to a Starlette application without building custom admin pages
• Enable non-technical users to view, create, edit, and delete database records through a web UI
• Prototype or demo a data-driven application with minimal admin scaffolding code
• Manage SQLAlchemy model instances in production with built-in filtering and column selection
• Support both sync and async database operations in a single admin interface

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Generates a web-based admin interface for SQLAlchemy models, integrating with Starlette to provide CRUD operations, filtering, and model management without writing custom views.

Yes. Active maintenance, low install friction, no known vulnerabilities, and permissive licensing make this a safe choice. Install it if you need a functional admin interface for SQLAlchemy models in Starlette without building custom views. Suitable for prototypes, internal tools, and production dashboards.

Install

sqladmin on PyPI

pip install sqladmin

uv add sqladmin

poetry add sqladmin

Installing sqladmin

Before you install

Low friction install with five runtime dependencies. Actively maintained with a release 8 days ago and 2812 repository stars. Supports Python 3.10, 3.11, 3.12, 3.13, 3.14.

License in practice

BSD-3-Clause permissive license allows commercial and private use with minimal restrictions; attribution required.

Quickstart

pip install sqladmin

from sqladmin import Admin, ModelView
from starlette.applications import Starlette
from sqlalchemy import create_engine

app = Starlette()
admin = Admin(app, create_engine('sqlite:///example.db'))

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

admin.add_view(UserAdmin)

Requires SQLAlchemy models and a Starlette application instance; optional extras (auth, i18n) need itsdangerous or babel respectively.

Verify before relying

• Performance characteristics with large datasets or complex relationships
• Customization depth for advanced UI/UX requirements beyond the default interface
• Full scope of supported SQLAlchemy features and edge cases

Package facts

Evidence: sqladmin-0.31.0-py3-none-any.whl

Keywords: sqlalchemy, fastapi, starlette, admin

Tags

More WWW/HTTP packages