Note on third‑party tools
We aim to provide accurate and helpful details about third‑party tools, but we can’t guarantee that this information is always complete or up to date. If you notice any discrepancies, feel free to share them in the feedback section below. For the most reliable information, please always refer to the third‑party tool’s official documentation.
MySQL is a popular relational database system.
This component allows you to query a MySQL database.
Connections
On-Premise Connection
Authenticate requests to a MySQL server.
Create a connection of type On-Premise Connection to authenticate with a MySQL server.
Configure the Connection
- Host: The publicly-accessible address of the MySQL server (e.g.,
my-server.example.com) - Port: The port the database server is exposing (default:
3306) - Database: The name of the MySQL database to connect to
- Username (optional): The username for authenticating with the MySQL server
- Password (optional): The password for authenticating with the MySQL server
| Input | Comments | Default |
|---|---|---|
| Host | The publicly-accessible address of the MySQL server. | my-server.example.com |
| Port | The port the database server is exposing. | 3306 |
| Database | The name of the MySQL database to connect to. | |
| Username | The username for authenticating with the MySQL server. | |
| Password | The password for authenticating with the MySQL server. |
Actions
Query Database
Executes a query against a MySQL database and returns the results.
| Input | Comments | Default |
|---|---|---|
| Connection | The MySQL connection to use. | |
| Query | The SQL query to execute against the MySQL server. Use '?' placeholders for parameterized values. | SELECT * FROM table WHERE name = ? AND age > ? |
| Parameters | The ordered list of values to bind to '?' placeholders in the query. Use this when the number of parameters is known at design time. Use either Parameters or Reference Parameters, not both. | |
| Reference Parameters | A JSON array of values to bind to '?' placeholders, referenced from a previous step. Use this when the number of parameters is determined at runtime. Use either Parameters or Reference Parameters, not both. |