---
id: sqladmin
version: "0.31.0"
license: BSD-3-Clause
license_treatment: permissive
maintenance: active
---

# sqladmin — SQLAlchemy admin for FastAPI and Starlette

License: permissive · Maintenance: active · Downloads: 948.8K/mo

## 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 above — 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

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

- License: BSD-3-Clause (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 948.8K/month (top 5,000 on PyPI)
- Known vulnerabilities: none known

## Tags

sqlalchemy admin interface, admin panel for orm, starlette admin dashboard, database crud interface, sqlalchemy model management, web admin for database, automatic admin interface, admin-interface, orm-tooling, web-framework-integration

[View on SkillFed](https://skillfed.io/packages/sqladmin) · [View on PyPI](https://pypi.org/project/sqladmin/)