---
title: MindsDB and DBeaver
sidebarTitle: DBeaver
---

DBeaver is a database tool that allows you to connect to and work with various database engines. You can download it [here](https://dbeaver.io/).

## Data Setup

First, create a new database connection in DBeaver by clicking the icon, as shown below.

<p align="center">
  <img src="/assets/sql/dbeaver_1.png" />
</p>

Next, choose the MySQL database engine and click the _Next_ button.

<Warning>
If you have multiple `MySQL` options, choose the `Driver for MySQL8 and later`.
</Warning>

<p align="center">
  <img src="/assets/sql/dbeaver_2.png" />
</p>

Now it's time to fill in the connection details.

<p align="center">
  <img src="/assets/sql/dbeaver_3.png" />
</p>

Use the following parameters:
    
* `127.0.0.1` or `localhost` for the host name. If you run MindsDB in cloud, specify the host name accordingly.

* `47335` for the port, which is the port of the MySQL API exposed by MindsDB. Learn more about [available APIs here](/setup/environment-vars#mindsdb-apis).

* `mindsdb` for the database name.

* `mindsdb` for the user name, unless specified differently in the [`config.json` file](/setup/custom-config#auth).

* `<empty>` for the password, unless specified differently in the [`config.json` file](/setup/custom-config#auth).

Now we are ready to test the connection.

## Testing the Connection

Click on the `Test Connection...` button to check if all the provided data allows you to connect to MindsDB.

On success, you should see the message, as below.

<p align="center">
  <img src="/assets/sql/dbeaver_4.png" />
</p>

## Let's Run Some Queries

To finally make sure that our MindsDB database connection works, let's run some queries.

```sql
SHOW FULL DATABASES;
```

On execution, we get:

```sql
+----------------------+---------+--------+
| Database             | TYPE    | ENGINE |
+----------------------+---------+--------+
| information_schema   | system  | [NULL] |
| mindsdb              | project | [NULL] |
| files                | data    | files  |
+----------------------+---------+--------+
```

Here is how it looks in DBeaver:

<p align="center">
  <img src="/assets/sql/dbeaver_5.png" />
</p>

<Tip>
How to [whitelist MindsDB Cloud IP address](/faqs/whitelist-ips)?
</Tip>

## What's Next?

Now that you are all set, we recommend you to check out our [Tutorials](/sql/tutorials/house-sales-forecasting) section where you'll find various examples of
regression, classification, and time series predictions with MindsDB or [Community Tutorials](/tutorials) list.

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!
