Input
MySQL Database
Reads a whole table from a saved MySQL connection into the pipeline.
When to use it
Use it when the source of truth is a MySQL table and you want the rows in FlowDoo to filter, join or export them somewhere else.
In a pipeline
MySQL DatabaseFilter RowsExport Excel
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Table | select | Yes | Select a table |
Example
Loading the orders table
- Connection=Shop (MySQL)
- Table=orders
| id | customer | amount | placed_on |
|---|---|---|---|
| 1041 | Northwind Trading | 1240 | 2026-03-02 |
| 1042 | Harbour Foods | 860 | 2026-03-04 |
| 1043 | Cole & Sons | 312.5 | 2026-03-04 |
| id | customer | amount | placed_on |
|---|---|---|---|
| 1041 | Northwind Trading | 1240 | 2026-03-02 |
| 1042 | Harbour Foods | 860 | 2026-03-04 |
| 1043 | Cole & Sons | 312.5 | 2026-03-04 |
The node runs SELECT * on the chosen table, so narrowing happens in the nodes after it.
Worth knowing
- There is no WHERE box: the whole table is read. Put Filter Rows or SQL Query after it, or point the node at a view.
- The Table list comes from SHOW TABLES, so it shows only what the connection's login can see.
- Connections to localhost or a private address are blocked unless the administrator sets FLOWDOO_ALLOW_PRIVATE_NETWORK=true.
- Connecting times out after 10 seconds and the query after 60; an empty table is not an error.