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.

​

Data Setup

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

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

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

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.

• mindsdb for the database name.

• mindsdb for the user name, unless specified differently in the config.json file.

• <empty> for the password, unless specified differently in the config.json file.

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.

​

Let’s Run Some Queries

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

SHOW FULL DATABASES;

On execution, we get:

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

Here is how it looks in DBeaver:

​

What’s Next?

Now that you are all set, we recommend you to check out our Tutorials section where you’ll find various examples of regression, classification, and time series predictions with MindsDB or Community Tutorials list.

To learn more about MindsDB itself, follow the guide on MindsDB database 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!