Categories
Self-Hosted Analytics Database Dashboard Business Intelligence SQL Data Visualization ReportingStars
Forks
Watchers
Developer links
Redash
Used by millions of users at thousands of organizations worldwide and holding 29,000+ GitHub stars, Redash is the most established open-source SQL-first business intelligence tool — enabling anyone from analysts to executives to query databases, visualize results, and share dashboards without writing a single line of application code. The browser-based query editor supports SQL and NoSQL with schema browsing, auto-complete, query snippets, and parameterized queries that turn static reports into interactive data applications. Native connectors span 35+ data sources including PostgreSQL, MySQL, Amazon Redshift, Google BigQuery, Snowflake, ClickHouse, MongoDB, Elasticsearch, Databricks, Apache Presto, Microsoft SQL Server, and REST APIs — with an extensible data source API for custom integrations. Visualization types cover line, bar, area, pie, scatter, box plot, funnel, cohort, sankey, sunburst, choropleth map, and pivot tables, all draggable onto shared dashboards with cross-filtering parameters. Scheduled refreshes automatically update query results at configurable intervals, while threshold-based alerts notify teams via email, Slack, or webhook when metrics cross defined boundaries. SAML and Google OAuth SSO integration, role-based access control, API key management, and query-level permissions ensure enterprise-grade security for sensitive datasets. The self-hosted stack deploys via Docker Compose with PostgreSQL for metadata storage, Redis for job queuing, and Celery workers for background task execution. Running on a dedicated VPS on RepoCloud with guaranteed CPU, RAM, and SSD, full root SSH access, and a browser serial console. BSD 2-Clause licensed.
Benefits
- Query Any Data Source Instantly
- Connect to 35+ databases and platforms including PostgreSQL, BigQuery, Redshift, Snowflake, ClickHouse, MongoDB, and Elasticsearch with native drivers — no ETL pipeline required.
- Self Service Business Intelligence
- Browser-based SQL editor with schema browsing, auto-complete, and parameterized queries empowers analysts to explore data independently without engineering support or dashboard bottlenecks.
- Automated Reporting and Alerts
- Schedule query refreshes at configurable intervals and define threshold-based alerts that notify teams via email, Slack, or webhook when key metrics change.
- Permissive Open Source License
- BSD 2-Clause license allows unrestricted commercial use, modification, and distribution. No AGPL copyleft restrictions — deploy internally or embed in proprietary products without legal concern.
Features
- SQL Query Editor
- Browser-based editor with schema browsing, auto-complete, query snippets, syntax highlighting, and parameterized queries that create interactive data applications.
- Drag and Drop Dashboards
- Combine line, bar, pie, scatter, funnel, cohort, sankey, choropleth, and pivot table visualizations into shareable dashboards with cross-filtering parameters.
- Scheduled Query Refreshes
- Automatically update query results at configurable intervals from minutes to days. Cached results serve dashboard viewers without re-executing expensive queries.
- Threshold Based Alerts
- Define numeric conditions on query results and receive notifications via email, Slack, PagerDuty, or custom webhooks when metrics cross defined thresholds.
- REST API Access
- Full REST API mirrors every UI capability — create queries, execute them programmatically, retrieve results, and manage dashboards from external applications and scripts.
- Docker Compose Deployment
- Official Docker Compose stack ships PostgreSQL, Redis, and Celery workers pre-configured. Upgrades via single Docker tag update with database migration command.