MySQL

Apidog allows you to execute MySQL queries directly within your API workflow, either as a pre-request setup or a post-request verification step.

Connecting to MySQL

Create Connection

Go to Settings > Database Connections > New. Select MySQL.

Configure Details

Enter Host, Port, Username, Password, and Database Name.

SSL Configuration (Optional)

If your server requires SSL, switch to the SSL tab.

Prefer (Default): Try SSL, fallback if unavailable.

Require: Enforce SSL.

Verify CA: Verify server certificate.

Verify Full: Verify certificate and hostname.

MySQL 8 Authentication

The latest MySQL module may have issues with caching_sha2_password (default in MySQL 8). If you encounter errors, revert to mysql_native_password:

Executing Queries

Apidog supports standard SQL commands. You can incorporate dynamic variables into your queries.

SELECT

Query data and extract results.

Extracting Results:
The result is always an array of objects.

Variable Name: userName

JSONPath: $[0].name (Extracts name from the first row)

INSERT / UPDATE / DELETE

Modify data using variables.

Insert:

Update:

Delete:

Usage in Automated Testing

In test scenarios, you can chain database operations with API requests.

Extract Data: Use an API request to get an ID.

Verify via DB: Use that ID in a SQL query validation step.

Loop Operations

You can use ForEach loops to process batch data. Use {{$.StepID.element.field}} to reference the current item in the loop.

Example Loop Query:

(Replace 4 with the actual Step ID of your loop)

Connecting to MySQL#

Executing Queries#

SELECT#

INSERT / UPDATE / DELETE#

Usage in Automated Testing#

Loop Operations#

Connecting to MySQL

Executing Queries

SELECT

INSERT / UPDATE / DELETE

Usage in Automated Testing

Loop Operations