> ## 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 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="https://mintcdn.com/mindsdb/qZ0qlWEqCb1K2Drt/assets/sql/dbeaver_1.png?fit=max&auto=format&n=qZ0qlWEqCb1K2Drt&q=85&s=231bd333c657925a13f6dc529b8693ce" width="496" height="126" data-path="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="https://mintcdn.com/mindsdb/qZ0qlWEqCb1K2Drt/assets/sql/dbeaver_2.png?fit=max&auto=format&n=qZ0qlWEqCb1K2Drt&q=85&s=55850f95f87e182a6c3d52f547b631c9" width="1614" height="1394" data-path="assets/sql/dbeaver_2.png" />
</p>

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

<p align="center">
  <img src="https://mintcdn.com/mindsdb/qZ0qlWEqCb1K2Drt/assets/sql/dbeaver_3.png?fit=max&auto=format&n=qZ0qlWEqCb1K2Drt&q=85&s=927da4a5495439a51194a2e3f87ad640" width="1616" height="1396" data-path="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="https://mintcdn.com/mindsdb/qZ0qlWEqCb1K2Drt/assets/sql/dbeaver_4.png?fit=max&auto=format&n=qZ0qlWEqCb1K2Drt&q=85&s=b9cc99b317eec5063ad0f9047763d53f" width="2084" height="1312" data-path="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 theme={null}
SHOW FULL DATABASES;
```

On execution, we get:

```sql theme={null}
+----------------------+---------+--------+
| 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="https://mintcdn.com/mindsdb/qZ0qlWEqCb1K2Drt/assets/sql/dbeaver_5.png?fit=max&auto=format&n=qZ0qlWEqCb1K2Drt&q=85&s=fafa431ee811c2a8e00113b826638ae3" width="854" height="498" data-path="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!