Google Looker
Modern BI platform for governed data modeling and dashboards
Open-Source Projects
Discover top open-source software, updated regularly with real-world adoption signals.
Discover top open-source software, updated regularly with real-world adoption signals.
Explore SQL data, build charts, and monitor alerts
Blazer adds SQL querying, charting, and alerting to Rails apps, supporting many databases, variable‑driven reports, audits, and flexible authentication.
Blazer is a Rails engine that lets developers run SQL queries against a variety of databases—PostgreSQL, MySQL, Redshift, and more—directly from their application. Queries can be parameterized with variables, and results are automatically visualized as line, bar, or pie charts, enabling fast insight without a separate BI tool.
Beyond ad‑hoc reporting, Blazer supports scheduled checks that email or post to Slack when data anomalies appear, providing proactive data‑quality monitoring. Every query is audited and can be secured with basic auth, Devise, or custom before‑action hooks. Installation is a single gem line, a generator, and a route mount, with optional Docker images for containerized deployments. For production safety, it encourages read‑only database users and runs queries inside transactions that roll back any writes.
When teams consider Blazer, these hosted platforms usually appear on the same shortlist.
Looking for a hosted option? These are the services engineering teams benchmark against before choosing open source.
Daily sales monitoring
Automated queries run every hour, charting sales trends and emailing alerts when revenue drops below threshold.
User activity cohort analysis
Variables let analysts slice activity by date range and segment, generating dashboards for product teams.
Data quality checks on ETL pipelines
Scheduled checks detect nulls or anomalies and post to Slack, enabling rapid issue resolution.
Ad‑hoc reporting for finance
Finance users run parameterized SQL queries with smart variables, instantly visualizing results in line or bar charts.
Add `gem "blazer"` to your Gemfile, run `rails generate blazer:install && rails db:migrate`, then mount `Blazer::Engine` in your routes.
Yes. Use basic auth, Devise, or define a custom `before_action_method` in `config/blazer.yml` to enforce any logic.
Blazer works with PostgreSQL, MySQL, MariaDB, Redshift, and any other DB that Rails can connect to via a URL.
Run `rake blazer:run_checks SCHEDULE="5 minutes"` via cron, Heroku Scheduler, Solid Queue, or similar. Alerts can be emailed or sent to Slack.
Blazer runs each query inside a transaction and rolls it back, but using a read‑only DB user is the safest approach.
Project at a glance
ActiveLast synced 4 days ago
