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



  • Amplication is a low-code development tool for the enterprise. It helps developers generate production-quality applications while it automates all repetitive tasks. Currently, Amplication is in public beta, and it is free to use. However, in the future, it may offer a community plan and a paid business plan. It features...Read more...

  • Budibase is a no-code/ low-code platform built to help developers and decision makers create solid enterprise apps in timely fashion. It packs all the required elements to connect to different data sources, views, forms, and tables which ease the collaboration and building process. The platform is super-easy to install, it...Read more...

  • What is Skyve?Skyve is an open-source Low-code tool that let you build and deploy application easily. Skyve perfectly for developers and Software providers to build and provide SaaS and Cloud-based products. It focused on the capability (rather than functionality). Who use Skyve?Developers Software providersEntrepreneursPrototype developersOrganizationsanyone who used to...Read more...

  • Most enterprise software applications today are hand-crafted and hand-coded. This process is slow, expensive and can result in inconsistencies. Moreover, it is a considerable challenge to keep up with ever-changing technologies. What is Rintagi?Rintagi is an open-source low-code application platform with limitless extension.Rintagi Developed and maintained by Robocoder...Read more...

  • A collection of open-source low-code and no-code solutions for enterprise...Read more...