Blazer

What it does

Anomaly detection

Blazer supports anomaly detection through Prophet, Trend, or AnomalyDetection.rb.checked 12 Oct 2026

Charts

Blazer automatically generates charts from SQL result columns, including line, column, scatter, and pie charts.checked 5 Oct 2026

Checks and alerts

Checks can send email alerts when bad data appears, and can also send notifications through a configured Slack incoming webhook.checked 12 Oct 2026

CSV uploads

Blazer can create database tables from CSV uploads, and this feature requires PostgreSQL.checked 12 Oct 2026

Dashboards

Dashboards can combine multiple queries, displaying charts when queries return chartable data and tables otherwise.checked 12 Oct 2026

Database permissions

Blazer attempts to protect against modifying queries by running them in a transaction and rolling it back, and recommends a read-only database user as a safer approach.checked 12 Oct 2026

Data sources

It supports multiple data sources, including PostgreSQL, MySQL, Redshift, BigQuery, Snowflake, and many others.checked 12 Oct 2026

Deployment

Blazer is installed as a Ruby gem in a Rails application and is also available as a Docker image.checked 12 Oct 2026

Hosting

Blazer is available as a Docker image and can be installed in a Rails application.checked 5 Oct 2026

Installation

Blazer is installed as a Ruby gem in a Rails application and mounted as a dashboard route.checked 5 Oct 2026

Integrations

Blazer can send check notifications to Slack through an incoming webhook.checked 5 Oct 2026

Intended users

Blazer is presented for teams that want to explore data with SQL and share charts and dashboards.checked 5 Oct 2026

License

The project is released under the MIT license.checked 12 Oct 2026

Notable limits

Cohort analysis requires PostgreSQL or MySQL 8, and CSV uploads require PostgreSQL.checked 5 Oct 2026

Performance

Queries run within a web request by default; asynchronous queries require caching, and multiple web processes require a centralized cache store.checked 12 Oct 2026

Purpose

Blazer lets teams explore data with SQL, create charts and dashboards, and share them.checked 12 Oct 2026

Query auditing

Blazer tracks all queries.checked 5 Oct 2026

Query audits

Blazer tracks all queries.checked 12 Oct 2026

Query permissions

Its basic permissions model can hide unnamed queries, limit queries beginning with # to their creator, and limit editing of queries beginning with * to their creator.checked 12 Oct 2026

Security

Blazer can use an application's authentication system, and its documentation advises protecting the dashboard in production.checked 12 Oct 2026

Variables

Queries can use variables so users can run the same query with different values.checked 12 Oct 2026