MySQL List Databases¶
Lists all databases available to the provided MySQL connection. It loads saved MySQL credentials, calls the service to retrieve database names, and returns both a readable summary and machine-friendly JSON.
Usage¶
Use this node to discover which databases are accessible with your MySQL credentials before selecting one for queries, table listing, or schema exploration. It’s typically placed early in a workflow to drive subsequent selections for table info, queries, or visual query building.
Inputs¶
| Field | Required | Type | Description | Example |
|---|---|---|---|---|
| credentials_path | True | STRING | Path or reference to stored MySQL credentials. Must correspond to a MySQL credential template. | /configs/credentials/mysql/default.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 of the databases found. | MySQL Databases: - information_schema - sales - analytics - mysql |
| json | JSON | Raw JSON payload containing the databases list and any related metadata from the service. | {"data": ["information_schema", "sales", "analytics", "mysql"], "count": 4} |
| html | STRING | HTML output (empty for this node). | |
| xlsx | BYTES | Excel output (empty for this node). | |
| BYTES | PDF output (empty for this node). |
Important Notes¶
- Credentials: Requires valid MySQL credentials with sufficient permissions to list databases (e.g., SHOW DATABASES).
- No extra parameters: This operation does not require additional inputs beyond credentials_path and timeout.
- Service-backed: The node delegates work to the MySQL service endpoint; network connectivity and service availability are required.
- Output formats: This node primarily returns text and JSON; other formats (HTML/XLSX/PDF) are empty for this operation.
Troubleshooting¶
- Connection failed or timeout: Verify the host, port, and network access. Increase the timeout value if the database is slow to respond. Use the 'MySQL Test Connection' node to confirm connectivity.
- Authentication error: Ensure the credentials_path points to a valid MySQL credential set and that username/password are correct.
- Insufficient privileges: The account must have permission to list databases. Contact your DBA or update the account permissions.
- Empty or partial results: Confirm the user’s access scope; some environments restrict visibility to specific databases.