> ## Documentation Index
> Fetch the complete documentation index at: https://docs.mindsdb.com/llms.txt
> Use this file to discover all available pages before exploring further.
# MindsDB and Metabase
Metabase is open-source software that facilitates data analysis. It lets you visualize your data easily and intuitively. Now that MindsDB supports the MySQL binary protocol, you can connect it to Metabase and see the forecasts by creating and training the models.
For more information, visit [Metabase](https://www.metabase.com/).
## Setup
### MindsDB
Install MindsDB locally via [Docker](/setup/self-hosted/docker) or [Docker Desktop](/setup/self-hosted/docker-desktop).
### Metabase
Now, let's set up the Metabase by following one of the approaches presented on
[the Metabase Open Source Edition page](https://www.metabase.com/start/oss/).
Here, we use the
[.jar approach](https://www.metabase.com/docs/latest/installation-and-operation/running-the-metabase-jar-file.html)
for Metabase.
## How to Connect
Follow the steps below to connect your MindsDB to Metabase.
1. Open your Metabase and navigate to the *Admin settings* by clicking the cog
in the bottom left corner.
2. Once there, click on *Databases* in the top navigation bar.
3. Click on *Add database* in the top right corner.
4. Fill in the form using the following data:
```text theme={null}
Database type: `MySQL`
Display name: `MindsDB`
Host: `localhost`
Port: `47335`
Database name: `mindsdb`
Username: `mindsdb`
Password: *leave it empty*
```
5. Click on *Save*.
Now you're connected!
## Example
Now that the connection between MindsDB and Metabase is established, let's do
some examples.
Most of the SQL statements that you usually run in your
[MindsDB SQL Editor](/connect/mindsdb_editor/) can be run in Metabase as well.
Let's start with something easy.
On your Metabase's home page, click on *New > SQL query* in the top right corner
and then, select your MindsDB database.
Let's execute the following command in the editor.
```sql theme={null}
SHOW TABLES;
```
On execution, we get:
Please note that creating a
[database connection](/sql/tutorials/home-rentals/#connecting-the-data) using
the `CREATE DATABASE` statement fails because of the curly braces (`{}`) being
used by JDBC as the escape sequences.
```sql theme={null}
CREATE DATABASE example_db
WITH ENGINE = "postgres",
PARAMETERS = {
"user": "demo_user",
"password": "demo_password",
"host": "samples.mindsdb.com",
"port": "5432",
"database": "demo"
};
```
On execution, we get:
You can overcome this issue using the
[MindsDB SQL Editor](/connect/mindsdb_editor/) to create a database.
Now, getting back to the Metabase, let's run some queries on the database
created with the help of the [MindsDB SQL Editor](/connect/mindsdb_editor/).
```sql theme={null}
SELECT *
FROM example_db.demo_data.home_rentals
LIMIT 10;
```
On execution, we get:
## What's Next?
Now that you are all set, we recommend you check out our **Tutorials** and
**Community Tutorials** sections, where you'll find various examples of
regression, classification, and time series predictions with MindsDB.
To learn more about MindsDB itself, follow the guide on
[MindsDB database structure](/sql/table-structure/). Also, don't miss out on the
remaining pages from the **SQL API** section, as they explain a common SQL
syntax with examples.
Have fun!