2.8k stars · BSD-3-Clause · 0.31.1 (2026-09-01) · Track this in Scout
A SQLAlchemy admin panel mounted inside the FastAPI app he already runs — support without a psql prompt.
▶Repo detailsthe review · specs · pros & cons
What it is
A SQLAlchemy admin interface for FastAPI and Starlette: you declare which models to expose and get a browsable, searchable, editable web UI over your tables. It mounts as a route inside an application you are already running — no separate service, no second database connection.
What it is good for. On a small team every support email — "my import failed", "did my payment go through?" — ends at a psql prompt with somebody reconstructing a query. This is an afternoon of work that turns those into a search box, and for anyone who does not write SQL from memory that is the difference between answering in a minute and putting it off until Sunday. It also makes the rest of this ledger inspectable rather than theoretical: Procrastinate's job table (Ed. 5 #10), Lago's usage events (#1), Logto's users (#4) all become something you can look at without a terminal. Note the move: the project is now smithyhq/sqladmin, and it is releasing roughly monthly under its new home.
- Fits a FastAPI, Starlette and SQLAlchemy stack, with nothing new to deploy or monitor.
- BSD-3-Clause, the most permissive licence on this page.
- Actively released under the new owner: 0.31.0 on 6 August, after 0.30, 0.29 and 0.28 in the three months before.
- An admin panel over live production data is a serious authentication problem. Put it behind Logto (#4) or a VPN — never a shared password.
- Still 0.x, and the ownership change means older tutorials point at the previous repository.
- It exposes your schema exactly as it is. A confusingly named column stays confusingly named in the UI.
