Skip to content
railsengines.com

Administrate vs SQLite Dashboard

Both replace Retool. Administrate is the better-known of the two (5,800 stars), while SQLite Dashboard also stands in for Metabase Cloud.

Browse and query your SQLite databases from inside the app

No ratings yet
# Gemfile
gem "sqlite_dashboard"

# config/routes.rb
mount SqliteDashboard::Engine, at: "/sqlite_dashboard"

What Administrate does

Administrate generates admin controllers and views that you then edit like any other Rails code. The generated code is yours. A dashboard class per model describing fields and their types Index, show, new and edit screens Search and filtering Every view overridable, because they are generated into your app Administrate generates code into your repository; Madmin keeps more of itself inside the gem. Pick generated-and-editable, or configured-and-compact.

Read the full Administrate listing →

Why you might pick it

  • It also replaces Forest Admin.
  • It has substantially more adoption — 5,800 stars against 80.

What SQLite Dashboard does

Rails 8 put SQLite in production. This gives you somewhere to look at it. Automatic discovery of the SQLite databases in config/database.yml Multiple databases, switchable from the sidebar — including the Solid Queue, Solid Cache and Solid Cable databases A SQL editor with CodeMirror syntax highlighting and autocomplete Paginated results, exportable to CSV or JSON Read-only mode by default: DROP and ALTER are blocked, and DML is configurable Works with importmap — no build step required.

Read the full SQLite Dashboard listing →

Why you might pick it

  • It also replaces Metabase Cloud.

Side by side

Rows where the two differ are marked.

Administrate vs SQLite Dashboard compared across category, licence and coverage
Administrate SQLite Dashboard
Category Admin and internal tools Admin and internal tools
Replaces (differs) Forest Admin, Retool Metabase Cloud, Retool
License MIT MIT
GitHub stars (differs) 5800 80
Gem (differs) administrate sqlite_dashboard
Mounts at (differs) /admin /sqlite_dashboard
Member rating

What each one gets off your invoice

Both replace

Only Administrate

Only SQLite Dashboard

Questions

What is the difference between Administrate and SQLite Dashboard?
Both replace Retool. Administrate is the better-known of the two (5,800 stars), while SQLite Dashboard also stands in for Metabase Cloud.
Can I mount both Administrate and SQLite Dashboard in the same Rails app?
Technically yes — engines mount at different paths — but they overlap, so running both usually means two sets of tables doing one job. Pick one.
Do Administrate and SQLite Dashboard replace the same SaaS product?
Both are listed as replacements for Retool.

Other comparisons in Admin and internal tools