Connecting to other types of databases in Metabase
Let's get to know all the other types of databases we can connect to in Metabase.
Relational databases
Besides PostgreSQL, which we've already covered extensively, the other relational databases you can connect to with Metabase are as follows.
MySQL
To connect to a MySQL database, choose MySQL from the list of database types in the Database section of the Metabase admin panel. Connecting to MySQL is nearly identical to PostgreSQL. The standard port for MySQL is 3306
.
MariaDB
Although not listed in the database types, you can connect to a MariaDB database with Metabase using the MySQL option.
Microsoft SQL Server
To connect to Microsoft SQL Server, choose SQL Server from the list of database types in the Database section of the Metabase admin panel. Connecting to SQL Server is nearly identical to PostgreSQL. The standard ports are 1433
and 1521
.