scenic-views/scenic

Health v2 · maintenance only

Adoption not part of the score

3623 stars · 241 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

Scenic is a Ruby gem that adds methods to ActiveRecord::Migration for creating and managing versioned database views in Rails applications. It lets developers define views in SQL files with a convention for versioning that keeps migrations reversible and consistent, shipping with PostgreSQL support and a configurable adapter interface.

Use cases

• manage versioned SQL database views in a Rails app
• create and update Postgres views through Rails migrations
• use database views without switching schema format to SQL
• implement full-text search across multiple models with a SQL view
• build complex reports by encapsulating SQL in views
• keep view definitions in SQL files with syntax highlighting and easy testing

When to choose

• you use Rails with PostgreSQL and want first-class database view support
• you need reversible, versioned migrations for view changes
• you want to express complex queries as composable database views instead of ActiveRecord scopes

When to avoid

• your application does not use Rails or ActiveRecord
• you use MySQL, SQLite, or another database without a third-party Scenic adapter
• you prefer managing views manually outside your migration history

Facets

library · maturity stable

database orm developer-tools databases web-development backend developer-tools ruby rails activerecord database-views postgres sql migrations schema web-server

Member repositories

For agents

markdown · JSON · MCP: product_card(name="scenic-views/scenic")