Skip to content
railsengines.com

Avo vs SQLite Dashboard

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

Avo

Better known

A configuration-driven admin panel and internal tools framework

5.0 · 4 ratings
# Gemfile
gem "avo"

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 Avo does

Avo builds an admin panel from resource definitions, and goes past CRUD with custom actions, filters and dashboard cards. Resource classes describing fields, filters and actions Custom actions that run Ruby against selected records Dashboards with metric and chart cards Authorization through Pundit policies Mounts at /avo by default. The community edition is MIT. Several features are in the paid tiers. Check before you plan around one.

Read the full Avo listing →

Why you might pick it

  • It also replaces Forest Admin.
  • It has substantially more adoption — 2,400 stars against 80.
  • Members here rate it higher, at 5.0 against 0.0.
  • Its licence is Community edition MIT; advanced features commercial, which may matter more than the feature list.

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.
  • Its licence is MIT, which may matter more than the feature list.

Side by side

Rows where the two differ are marked.

Avo vs SQLite Dashboard compared across category, licence and coverage
Avo SQLite Dashboard
Category Admin and internal tools Admin and internal tools
Replaces (differs) Forest Admin, Retool Metabase Cloud, Retool
License (differs) Community edition MIT; advanced features commercial MIT
GitHub stars (differs) 2400 80
Gem (differs) avo sqlite_dashboard
Mounts at (differs) /avo /sqlite_dashboard
Member rating (differs) 5.0

What each one gets off your invoice

Both replace

Only SQLite Dashboard

Questions

What is the difference between Avo and SQLite Dashboard?
Both replace Retool. Avo is the better-known of the two (2,400 stars), while SQLite Dashboard also stands in for Metabase Cloud.
Can I mount both Avo 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 Avo and SQLite Dashboard replace the same SaaS product?
Both are listed as replacements for Retool.

Other comparisons in Admin and internal tools