Metabase: The Ultimate Swiss knife For Getting Insightful Answers From Your Data

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

• https://github.com/metabase/metabase
• https://www.metabase.com/
• https://medevel.com/os-18-lowcode/