MySQL List Databases¶
Lists all databases accessible to the provided MySQL connection. It loads the specified credentials, calls the MySQL service to retrieve database names, and returns both a human-readable summary and a JSON payload.
Usage¶
Use this node when you need to discover available databases on a MySQL server before selecting one for queries or schema exploration. Typically placed early in a workflow to guide dynamic selection of target databases for subsequent operations.
Inputs¶
| Field | Required | Type | Description | Example |
|---|---|---|---|---|
| credentials_path | True | STRING | Path to the stored MySQL credentials to authenticate the request. The credentials should match the 'mysql' template. | /workspace/credentials/mysql.json |
| timeout | True | INT | Maximum time in seconds to wait for the operation to complete before failing. | 60 |
Outputs¶
| Field | Type | Description | Example |
|---|---|---|---|
| text | STRING | Human-readable summary listing the discovered databases. | MySQL Databases:\n- information_schema\n- app_db\n- analytics |
| json | STRING | JSON string containing the raw result of the database list operation. | {"data": [{"database": "information_schema"}, {"database": "app_db"}, {"database": "analytics"}]} |
| html | STRING | HTML representation of results (not used by this node's default output; returned as an empty string). | |
| xlsx | BYTES | Binary XLSX content (not used by this node's default output; returned as an empty value). | |
| BYTES | Binary PDF content (not used by this node's default output; returned as an empty value). |
Important Notes¶
- Credentials Required: This node uses the 'mysql' credential template. Ensure the provided credentials path contains valid MySQL connection details.
- No Additional Parameters: Beyond credentials and timeout, no extra inputs are required to list databases.
- Output Structure: The node returns both a human-readable text summary and a JSON string; other output slots (HTML, XLSX, PDF) are intentionally left empty by default.
- Permissions Matter: The databases returned depend on the user's privileges; limited users may see only a subset.
Troubleshooting¶
- Authentication failure: Verify the credentials file at the provided path and ensure it matches the expected 'mysql' format.
- Timeouts or network errors: Increase the timeout value and ensure network connectivity to the MySQL host.
- Empty results: Check user permissions; the account may not have privileges to view available databases.
- Unexpected JSON format: Ensure downstream nodes parse the 'json' output as a string and decode it before use.