Metabase: The ultimate Swiss knife open-source for getting insightful answers from databases

Metabase is a no- and low-code open-source (Libre) project that removes all hassle of getting insightful data from databases. It does a lot without having to deal with SQL code or even know any SQL to begin with.

It is built for anyone with basic technical skills, as well as data engineers and scientists. That makes it the right tool for marketeers, sales managers, project planners and marketing strategist.

Metabase helps user to learn from their data by asking meaningful questions which it translates into a complex SQL queries in the background.

Currently, we are using it to work with several databases, and we recommend it to some of our clients.

Why do we like it?

  1. A mix of a no-code and low-code: Which fits perfectly for all sort of users with different background and tech (database/ SQL) skills
  2. Question to SQL queries without dealing with SQL code: Simple questions, Custom complex questions
  3. Customizable Dashboards
  4. Native SQL queries editor
  5. Supports multiple databases
  6. Graphs and charts
  7. It took a few minutes to install

Metabase is intended for:

  1. All soft of users
  2. Data scientists
  3. Data engineers

Data science features

Metabase Features List

  1. Built with Java (Runs everywhere)
  2. Supports SQL and NoSQL database
  3. Multiple-dashboard support
  4. Multiple-users with permissions and groups
  5. Charts, Graphs and Maps all in one package
  6. Database connection made easy
  7. Supports MongoDB
  8. Filtering, sorting, search and aggregation support
  9. Field search
  10. Full-text search
  11. Advanced search with filters support
  12. Complete no-code approach
  13. Low-code support with SQL console
  14. Notebook editor with multiple aggregations support
  15. Responsive design which works smoothly on tablets and mobiles
  16. Built-in analytics
  17. Easy to setup and configure with no almost no configuration required
  18. Docker installation support
  19. Rich documentation and tutorial set
  20. Sample database set for newcomers
  21. Smooth learning curve
  22. Alerts and notification with custom alerts support
  23. Import and export to CSV, Excel and JSON
  24. Filed filtering with smart filtering support that supports date, time and custom operations
  25. Chart customizations
  26. Customizable dashboards
  27. Multi-step summarizations with the Notebook editor
  28. Sharable and re-usable SQL snippets
  29. Improved collection management with a drag-and-drop interface

Supported Databases

  1. MySQL
  2. PostgreSQL
  3. MongoDB
  4. SQL Server
  5. Amazon REDSHIFT
  6. SQLite
  7. H2
  8. Oracle
  9. Apache Spark
  10. Amazon Athena
  11. Teradata
  12. BigQuery

Install requirements

  1. Clojure
  2. Java Development Kit JDK
  3. Node.js
  4. Yarn or NPM
  5. Leiningen

Install Metabase with Docker

With a simple command, you can get Metabase up and running in a minute or two:

docker run --restart=always -d -p 3000:3000 --name metabase metabase/metabase

Then head to: http://localhost:3000/ and setup your first admin account.

Supported Platforms

  1. Linux
  2. macOS
  3. Linux Servers: Ubuntu, Debian, CentOS, Red Hat Linux, Fedora and OpenSUSE

Resources






Hamza Mu Author: Hamza Mu

A physician with programming skills and Linux user.