Enable MySQL in Kizen

Audience: Admins, Developers, Solution Architects

Purpose: Explains how to configure the MySQL integration to use live MySQL data in Agentic Workflows

Overview

Caution: This setup reflects Kizen's default configuration. Your administrator may have customized your layout, so columns or navigation may appear differently. Trial accounts may have limited features.

To use MySQL data in Agentic Workflows, you must first enable the MySQL integration in Kizen.

---

Before You Begin

Before you enable the MySQL integration, ensure you have:

• Any MySQL instance, whether self-hosted or managed through Amazon RDS, Google Cloud SQL, or a similar service
• A MySQL database, version 5.7 or later, that is network-reachable from Kizen's egress IP addresses
• A MySQL user account with the necessary read or write privileges on the target database tables
• Org Admin access in Kizen

---

Enable MySQL in Kizen

To enable MySQL in Kizen:

1

Configure your MySQL network

To configure your MySQL network to work with Kizen:

• Add Kizen's egress IP addresses to the allowlist on your MySQL database or proxy. For the current list of egress IPs, contact your Kizen representative.
• Set your firewall to allow inbound TCP traffic on the MySQL port. This port is usually but not necessarily 3306. If you aren't sure of the correct port number, check your MySQL configuration.
• Optionally turn on SSL for your MySQL instance. To maintain security, we recommend that you use SSL unless you connect to the instance through a trusted private network or VPN.

2

Go to the App Marketplace

In the global navigation of Kizen, select Platform > App Marketplace.

3

Turn on the MySQL connection

Find the MySQL Connection card, and turn on the slider.

Note: If the Update Integration Secret modal appears after you turn on the slider, skip ahead to Step 6.

4

Go to your Integration Secrets Manager

Select Manage Secrets on the MySQL Connection card. A settings page appears with your integration secrets.

5

Edit the MySQL Connection Integration Secret

Open the Actions menu for the MySQL Connection plugin app, and select Edit.

The Update Integration Secret modal appears.

6

Enter your MySQL connection credentials

In the Integration Secret field of the modal, enter your MySQL connection credentials as a JSON object. The JSON object must contain host, port, user-name, and password keys, like this:

{
  "host": "db.company.com",
  "port": 3306,
  "user_name": "kizen_ro_user",
  "password": "secret"
}

Store multiple environments as nested JSON objects:

{
  "production_db": {
    "host": "db.company.com",
    "port": 3306,
    "user_name": "kizen_ro_user",
    "password": "secret"
  },
  "staging_db": {
    "host": "staging.db.company.com",
    "port": 3306,
    "user_name": "kizen_ro_user",
    "password": "secret"
  }
}

For descriptions of the keys, see the following table:

Key	Type	Description
host	String	The host name or IP address of the MySQL server
port	Integer	The MySQL server port
user_name	String	The user name of the connecting MySQL account
password	String	The password of the connecting MySQL account

Note: Kizen hides your secret once you submit it, so you can't append a new environment to an existing secret. You must re-enter the credentials for all your environments along with the new one. Consider keeping a secure record of each environment's connection details outside of Kizen so you can refer to the full set whenever you add a new environment.

7

Save the Integration Secret

Select Save.

---

What's Next

Now that you've set up the MySQL integration, you're ready to use the Read Data and Write Data actions in Agentic Workflows. Continue to Add MySQL Data to an Agentic Workflow to learn how.

Related Topics

• MySQL
• Add MySQL Data to an Agentic Workflow
• Troubleshoot MySQL

---

Oracle, Java, MySQL, and NetSuite are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.