Blazer Self-Hosted SQL BI Dashboard

This is a repackaged open source software product wherein additional charges apply for cloudimg support services.

## Why This AMI Instead of Self-Deploying?

Blazer is a popular open source, self-hosted business-intelligence tool: write SQL queries, turn them into charts and dashboards, and schedule data checks that alert you when something looks wrong. Deploying it yourself means installing Docker, running the Rails application, provisioning and hardening a database, fronting the app behind a reverse proxy with authentication, and generating and rotating application secrets. This AMI eliminates that effort entirely - your self-hosted SQL dashboard is running within minutes of launch, not hours. You get a pre-hardened, tested configuration backed by 24/7 expert support with a one-hour average response for critical issues, something community forums cannot provide.

The current release available is Blazer 3.4.0.

## Application Stack

The official upstream Blazer container runs under one systemd service, backed by a bundled PostgreSQL database. A host nginx reverse proxy fronts the application on port 80 and gates every path behind HTTP Basic authentication, because Blazer has no built-in authentication of its own. The database listens on the loopback address only; nginx is the single public listener. The image ships populated: a sample dataset, four example queries, a dashboard and a data check, so the query editor, chart results and dashboards render real content the moment you sign in.

## Secure By Default

Blazer runs arbitrary SQL, so an unauthenticated instance would be a serious risk. Many pre-built images ship with shared or default credentials - this image eliminates that entirely:

• A unique admin password, a unique application secret and a unique database password are generated for every instance on its first boot, before the application is reachable
• The web interface is gated behind HTTP Basic authentication on every path except a static health endpoint - no path is world-open
• The database listens on loopback only and is never exposed to the network
• The admin password is stored in a root-only file, inaccessible to unprivileged users
• No shared or default credential ships in the image, and no plaintext database credential survives capture

## Ready To Use

Browse to the instance on port 80, sign in with the generated admin credentials, and start exploring. The bundled sample dataset and example queries let you try charts and dashboards immediately; point Blazer at your own database with a read-only role when you are ready to query production data.

## What You Avoid By Using This AMI

• Installing Docker and running the Rails application
• Provisioning, tuning and hardening a database
• Fronting the app behind a reverse proxy with authentication
• Generating and securely rotating application and database secrets
• Ongoing maintenance and security patching without expert guidance

## cloudimg Support

24/7 technical support by email and chat with a one-hour average response for critical issues. Our engineers help with deployment, TLS termination, connecting external databases with read-only roles, backups, user management and scaling.

## Use Cases

• Self-hosted SQL exploration and business-intelligence dashboards with full data ownership
• A private, in-your-own-VPC alternative to hosted BI tools for privacy or data-residency requirements
• Scheduled data checks and alerts over an internal database

All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.