Data and databases · Edition No. 11 · 5 Sep 2026

smithyhq/sqladmin

An admin interface over SQLAlchemy tables, mounted inside a FastAPI or Starlette application.

← Data and databasesRead the whole edition →
11

smithyhq/sqladmin

💎 hidden gem
SQLAdmin. An admin screen over database tables.

2.8k stars · BSD-3-Clause · 0.31.1 (2026-09-01) · Track this in Rising ↗

A SQLAlchemy admin panel mounted inside the FastAPI app he already runs — support without a psql prompt.

Verified27 Oct 2026

Radar check

What we found when we opened it. Every bar is one fact, with its date.

Alive90

Last code pushed 1 Oct 2026, 26 days before this check.

Releases85

Latest release 0.32.0 on 20 Sep 2026.

Maturity70

Public since December 2021, a little over 4 years.

Adoption69

2,847 stars and 302 forks.

Activity65

33 commits and 14 new issues in the last 90 days.

Community100

109 contributors. 30 pull requests merged in 90 days.

Security40

No security policy file says how to report a problem. 3 published security advisories.

Licence BSD-3-Clause | [smithyhq.github.io/sqlad: permissive: use it for anything, keep the noticeSetup effort 2 of 5Payoff 4 of 5
How the bars are scored
  • Alive. Days since the last code push: a week or less 100, a month 90, three months 70, six months 50, a year 30, eighteen months 15, older 0.
  • Releases. Age of the latest GitHub release, on a similar scale; no bar when the project publishes no releases.
  • Maturity. Age of the project: eight years 100, five 90, three 70, two 55, one 40, six months 25, younger 10.
  • Adoption. Stars on a log scale: 100,000 stars is 100, 10,000 is 80, 1,000 is 60, 100 is 40.
  • Activity. Commits in the last 90 days: 300 or more 100, 100 85, 30 65, 10 45, any 25.
  • Community. People who have contributed: 100 or more 100, 30 80, 10 60, 5 40, 2 25, one 10.
  • Security. A published security policy 80, none 40; published advisories are listed, not scored.

Checked by Repo Radar on 27 Oct 2026 from the repository on GitHub. Covered in Edition 11.

▶Repo detailsthe review · specs · pros & cons · install

What it does

You declare which database models to expose and which of their columns to show, and it renders a browsable, searchable, editable interface over them. It mounts as a route inside an application that is already running, using the same database connection, so there is no second service and no second set of credentials. Listing, searching, sorting, creating, editing and deleting are all provided. Optional extras cover sign-in for the admin screens and translation of the interface. It understands the relationships declared on the models, so a row can be followed to the records that reference it. What it does not do is invent structure: it shows the schema exactly as it is, so a confusingly named column stays confusingly named, and a table with no sensible display column is still hard to read.

Why it matters

Who it suits. Any small team running FastAPI or Starlette with SQLAlchemy where support questions currently end at a database prompt. It is most valuable where the people answering those questions do not write SQL from memory, because it turns a query into a search box. Skip it if the application is not built on SQLAlchemy, and skip it if there is already an internal tool doing this job.

Verdict. The cheapest useful thing on this page in hours of work, and the one most likely to be opened every week. One warning dominates everything else: an admin screen over live customer data is a serious authentication problem, so put it behind the identity service in entry 4 or a private network, and never behind a shared password. Note the ownership history too: this project was aminalaee/sqladmin and is now smithyhq/sqladmin, so older guides point at the previous address, which still redirects. It is actively released, at 0.32.0 dated 20 September 2026 with code on 1 October 2026, and still a 0.x version, so expect small breaking changes. pallets-eco/flask-admin is the long-standing equivalent for Flask.

Stars2.8k
LicenceBSD-3-Clause
Latest0.31.1 (2026-09-01)checked 7 Sep 2026
Written inPython
RunsLocally, on your own machine
Summary (Key Points)from the README
Key features
  • Sync and async engines: Works with both SQLAlchemy sync and async engines.
  • Starlette integration: Mounts directly in a Starlette app.
  • FastAPI integration: Mounts directly in a FastAPI app.
  • WTForms form building: Builds model forms with WTForms.
  • SQLModel support: Works with SQLModel models.
  • Tabler UI: Ships an admin interface built on Tabler.
  • Optional authentication: The `auth` extra adds session-backed authentication through itsdangerous.
  • Optional internationalization: The `i18n` extra adds internationalization and localization through babel.
Important
  • Optional extras: Authentication needs the `auth` extra (itsdangerous), and localization needs the `i18n` extra (babel). The `full` extra installs both.
  • Admin path: After setup, the interface is served at `/admin` in the browser.
  • Public demo login: The live demo uses the username and password `superadmin`, so treat any deployment that keeps default credentials the same way.
  • Documentation gaps: The README leaves its documentation and source code references empty, so check the project's docs for setup details beyond the quickstart.

Written by an AI model from the project’s README; not part of the review, and it can be wrong.

Setup effort
2 / 5
Payoff
4 / 5
Good
  • Mounts inside an existing application, with nothing new to deploy or monitor.
  • BSD-3-Clause, the most permissive licence on this page.
  • Actively released under its new owner: 0.32.0 on 20 September 2026, code on 1 October 2026.
Watch for
  • It exposes live customer data over a web page, so authentication is not optional.
  • Still a 0.x version, so breaking changes between releases are expected.
  • The project moved address, so a good deal of older advice points at the previous repository.
Install
pip install sqladmin
Screenshots
smithyhq/sqladmin: GitHub preview cardsmithyhq/sqladmin: Screenshot 1smithyhq/sqladmin: Screenshot 2smithyhq/sqladmin: Screenshot 3

On Stack Radar: Infrastructure & Security › Databases & Storage › SQL Databases.

Get the next edition in your inbox

A dozen repositories, opened and checked. The licence read, the last release dated, and the ones that did not make it named with the reason. It is the half most lists leave out.

No tracking pixels. One click to leave. The archive stays free either way.

We use your address to send the edition and nothing else. Confirm by email, leave in one click. How we handle it.