MySQL List Tables¶
Lists all tables available in a specified MySQL database. It authenticates using provided MySQL credentials and returns a human-readable list along with a machine-readable JSON payload. Non-text exports (HTML/XLSX/PDF) are available but are empty by default for this operation.
Usage¶
Use this node when you need to discover or audit the tables present in a particular MySQL database before writing queries or building data workflows. Typical usage is to connect with valid MySQL credentials, provide the target database name, and feed the results into downstream nodes that select tables, inspect schemas, or construct queries.
Inputs¶
| Field | Required | Type | Description | Example |
|---|---|---|---|---|
| credentials_path | True | STRING | Path to the saved MySQL credentials file configured for this service. The credentials should follow the MySQL credential template. | /workspace/credentials/mysql.json |
| timeout | True | INT | Maximum time in seconds to wait for the list operation before failing. | 30 |
| database | True | STRING | Name of the MySQL database from which to list tables. | analytics |
Outputs¶
| Field | Type | Description | Example |
|---|---|---|---|
| text | TEXT | Formatted textual summary of tables found in the specified database. | Tables in Database: analytics - users - orders - products |
| json | JSON | JSON representation of the result, suitable for programmatic use. | {"data": ["users", "orders", "products"], "database": "analytics"} |
| html | HTML | HTML output (empty by default for this node). | |
| xlsx | XLSX | Binary Excel data for export (empty by default for this node). | |
| Binary PDF data for export (empty by default for this node). |
Important Notes¶
- Credentials required: Ensure the credentials file at credentials_path is valid and configured for MySQL.
- Database name accuracy: The database input must exist and be accessible to the provided user, otherwise the result may be empty or error.
- Timeouts: Large catalogs or slow connections may require increasing the timeout.
- Outputs: The operation primarily returns populated TEXT and JSON outputs; HTML/XLSX/PDF outputs are provided for interface consistency and are typically empty for this node.
Troubleshooting¶
- Authentication error: Verify credentials_path points to a valid MySQL credential set and that network access to the MySQL host is allowed.
- Permission denied: Ensure the MySQL user has privileges to read metadata (e.g., information_schema) for the specified database.
- Empty results: Confirm the database name is correct and that it actually contains tables.
- Request timed out: Increase the timeout input and check database/network latency.
- Unknown database: Double-check the database field for typos or missing databases on the server.