MySQL List Tables¶
Lists all tables available in a specified MySQL database using the provided credentials. Returns a human-readable summary and a machine-readable JSON payload you can pass to downstream nodes.
Usage¶
Use this node when you need to explore or enumerate tables in a MySQL database before building queries or fetching table metadata. It’s typically placed early in a workflow to discover available tables, then chained to nodes like MySQL Table Info or MySQL Query.
Inputs¶
| Field | Required | Type | Description | Example |
|---|---|---|---|---|
| credentials_path | True | STRING | Path or reference to stored MySQL credentials configured for this service. | /workspace/credentials/mysql/ |
| timeout | True | INT | Maximum time (in seconds) to wait for the operation before it times out. | 60 |
| database | True | STRING | The name of the database from which to list tables. | analytics_db |
Outputs¶
| Field | Type | Description | Example |
|---|---|---|---|
| text | STRING | Readable summary of the tables found in the specified database. | Tables in Database: analytics_db - users - orders - products (3 tables) |
| json | STRING | JSON string containing the list of tables and related metadata (if available). | {"tables": [{"name": "users"}, {"name": "orders"}, {"name": "products"}]} |
Important Notes¶
- Credentials required: You must have a valid MySQL credential configuration available to the node.
- Permissions: The connected user must have privileges to read metadata for the target database; otherwise, the table list may be incomplete or empty.
- Timeouts: Large schemas or slow networks may require increasing the timeout.
- Database name: Ensure the database exists and is spelled exactly as configured on the server.
Troubleshooting¶
- Connection failed or timed out: Verify the credentials path, host/port in your credentials, and increase the timeout if the database is large or network is slow.
- Authentication error: Confirm username/password or authentication method in the stored credentials and that access to the target database is granted.
- Unknown database: Check that the database value matches an existing database the user can access.
- Empty list returned: Ensure the user has metadata permissions and that the database contains tables.