Connecting to MySQL

Edit online

MySQL is an open source relational database management system that is based on structured query language (SQL). MySQL is a fast, reliable, scalable, and easy-to-use database system with querying and connectivity capabilities that offers robust data structure and platform integration

To integrate MySQL with IBM watsonx Orchestrate, you need to establish a secure connection that enables both systems to communicate seamlessly. For general guidance on managing integrations, refer to Connecting apps for prebuilt agents.

Important:

By default, Single sign-on (SSO) is disabled for your app. To enable it, refer to Configuring single sign-on for applications.

Steps to connect

Use the following steps to connect MySQL to watsonx Orchestrate:

  1. Go to Manage > Connections and search for the corresponding MySQL Connection ID.

  2. Click edit next to the matching connection ID.

  3. Select Key Value Pair as the authentication type.

  4. Enter the MySQL‑specific fields. See Connecting apps for prebuilt agents page for general connection workflow.

  5. Complete the Draft and Live setup steps.

  6. Save and test the connection to confirm successful connection.

Supported authentication methods

MySQL supports the following authentication type in watsonx Orchestrate:

  1. Key Value Pair (KVP): Required for API‑key or token‑based configurations

Connection ID

Use the following Connection ID when locating your MySQL connection in the Connections settings page. To understand how to search for a Connection ID and open a connection for editing, see Connecting apps for prebuilt agents.

Authentication type

Connection ID

Key Value Pair

``mysql_ibm_184bdbd3``

Key Value Pair connection details

If your organization uses API keys, set Authentication type to Key Value Pair and add each of the following fields using Add new field:

Key

Description

Port

Port for authentication

Database

Database for authentication

Username

Username for authentication

Password

Password for authentication

Note: When using Key Value Pair, only Team credentials are supported.

Your MySQL administrator can help you get the details.

What to do next

Now that your app connection is live, you can start using it in watsonx Orchestrate.

  • Run an agent in Orchestrate Chat to complete tasks using natural language.

  • Use relevant tools to perform app-specific actions.