SQLite Dashboard

Rails 8 put SQLite in production. This gives you somewhere to look at it.

What you get

• 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

Mounting it

# Gemfile
gem "sqlite_dashboard"

# config/routes.rb
authenticate :user, ->(user) { user.admin? } do
  mount SqliteDashboard::Engine => "/sqlite_dashboard"
end

Works with importmap — no build step required.