Placeholder description.
Grab the automated bash script from GitHub to follow along with the video.
wget https://raw.githubusercontent.com/mhmdali94/Docker/main/analytics/metabase/metabase-ubuntu.sh
chmod +x metabase-ubuntu.sh
sudo bash metabase-ubuntu.shwget https://raw.githubusercontent.com/mhmdali94/Docker/main/analytics/metabase/metabase-ubuntu.shchmod +x metabase-ubuntu.shThe script installs Docker if needed and deploys Metabase. First startup takes 1–2 minutes as the Java application initializes.
sudo bash metabase-ubuntu.shOpen your browser and navigate to:
http://<your-server-ip>:3000After the welcome wizard sets your admin account, Metabase asks which database to connect. Choose your database type (PostgreSQL, MySQL, MongoDB, etc.), enter the connection details, and click Save. Metabase will scan the schema and start suggesting questions based on your data within minutes.
| Port | Purpose |
|---|---|
| 3000 | Metabase Web UI |
| — | Uses embedded H2 DB by default (switch to PostgreSQL for production) |
Metabase is the most widely deployed open-source business intelligence tool, with over 57,000 companies using it. Its key differentiator is the no-SQL question builder — non-technical users can explore data, filter results, and build charts by clicking, not typing SQL. Under the hood, Metabase translates their selections into optimized queries. Analysts who prefer SQL can use the native SQL editor. Metabase connects to 20+ databases, generates dashboards with automatic refresh, supports subscription emails and Slack alerts, and can embed charts and dashboards in external web applications. The open-source Community Edition is self-hostable and covers all core BI features.
Most BI tools require SQL knowledge, which means data analysts become bottlenecks every time a business user has a question. Metabase breaks this bottleneck — the question builder lets a marketing manager filter sales by region, or an ops manager check inventory levels, without filing a ticket. Charts update automatically, so dashboards are always current. For self-hosters, Metabase keeps all your business data and query patterns on your own server — no sending customer or financial data to a SaaS analytics platform. The Community Edition is 100% free with no row limits, no user limits, and no watermarks.
Metabase runs on port 3000. In production put it behind Nginx Proxy Manager on port 443. The Metabase metadata database (H2 or PostgreSQL) stays on the internal Docker network. Your data source databases must be reachable from the Metabase container — configure Docker networking accordingly. Configure ufw allow 443 and ufw allow 80 for redirect, deny all other inbound.
Redash is the best alternative for SQL-proficient teams — it embraces SQL rather than abstracting it and has better multi-source query support. Apache Superset is more powerful with more chart types but is significantly harder to set up and maintain. Grafana is excellent for time-series and infrastructure metrics but not designed for business analytics from transactional databases. Lightdash builds on dbt models for teams with a mature data warehouse. Tableau and Looker are enterprise tools costing hundreds per user per month. For self-hosted no-SQL BI, Metabase has the most polished experience.
Metabase is not ideal for very large data warehouses (billions of rows) where query performance requires careful tuning — tools like Looker with caching layers handle this better. If your entire team consists of SQL experts who find the question builder limiting, Redash's SQL-first approach may be more productive. Metabase's Community Edition also lacks some enterprise features: SAML SSO, advanced permissions, audit logging, and sandboxed data access by row — those require Metabase Pro ($500+/month). If real-time streaming analytics (sub-second refresh) is required, use Grafana with InfluxDB or ClickHouse.
PrismaTechWork provides end-to-end infrastructure services — from initial deployment and security hardening to ongoing monitoring, automated backups, and dedicated support. Whether you need a single-server setup or a multi-site network, our team ensures your infrastructure is built right, secured properly, and maintained reliably.
Yes — Metabase Community Edition is fully open-source (AGPL license) and completely free with no user limits, no row limits, and no feature watermarks. The paid tiers (Pro at $500+/month and Enterprise) add SAML SSO, advanced permissions, audit logs, row-level sandboxing, and priority support. For most self-hosting teams, the Community Edition covers all necessary BI functionality.
Metabase connects to PostgreSQL, MySQL, MariaDB, SQLite, MongoDB, Google BigQuery, Amazon Redshift, Snowflake, Apache Druid, Presto, Trino, ClickHouse, Oracle, Microsoft SQL Server, Vertica, and more. Each connection is configured in Admin → Databases. Metabase syncs the database schema automatically and resurfaces new tables and columns without manual intervention.
Yes — the question builder is genuinely usable by non-technical users. You pick a table, add filters (e.g. orders where status = 'completed'), group by a column (e.g. by month), choose a metric (count or sum), and Metabase draws the chart. Users can also click any chart to drill into the underlying rows. SQL knowledge is not required for the question builder — analysts use the native SQL editor when they need more control.
Metabase has a signed embedding API. Enable embedding in Admin → Embedding, then use the embed URL for a question or dashboard signed with your secret key and a JWT token. You can lock parameters (e.g. user_id) in the JWT so each embedded user only sees their own data. Embed the URL in an iframe. This works in the Community Edition for public charts; locked parameters (signed embedding) requires Metabase Pro.
Metabase is Java-based and requires a minimum of 2 GB RAM to run stably. For production with multiple users and complex queries: 4 GB RAM is recommended. If you run Metabase on 1 GB RAM, it will start but crash under query load. The metadata database (use PostgreSQL in production) adds modest additional memory requirements.
Yes — Metabase subscriptions send a dashboard snapshot to any email address on a schedule (daily, weekly, or specific days and times). Open any dashboard, click the Share icon, choose Dashboard subscriptions, add recipient emails, and set the schedule. You can also subscribe to individual question alerts that trigger when a metric crosses a threshold (e.g. send an email when daily errors exceed 50).
Metabase is designed for business users — the no-SQL question builder makes it accessible to anyone without programming knowledge. Redash is designed for analysts — it is SQL-first and assumes users know how to write queries. Metabase wins on accessibility and self-serve analytics for non-technical teams. Redash wins on SQL flexibility, more data source connectors, and better query parameterization for analyst workflows. Many organizations use both: Redash for internal analyst work, Metabase for sharing results with business teams.
Pull the latest Metabase Docker image (docker pull metabase/metabase:latest) and restart the container (docker compose up -d). Metabase runs schema migrations on startup automatically. Always back up the metadata database before upgrading. Check the Metabase release notes for any breaking changes before major version upgrades. The migration typically completes within 1–2 minutes.