SQL
Databases integration · 3 node(s).
00Overview
Every field below is exactly what you see in the Flomation editor. Fields marked ● live picker let you choose from a list pulled live from your account — no IDs to look up.
01Connecting SQL
Add your credentials as a Flomation environment secret, then pick them in each node. The connection fields are:
Pick an Environment on your flow (Flow Settings → Environment) so the secret resolves. Secret fields never show the value — they reference
${secrets.your_secret}.02Mysql
MySQL Query
sql/mysql · Action
Execute a query against a MySQL database
| Field | Type | Details | |
|---|---|---|---|
| Database Host | string | Required | localhost |
| Database Port | integer | Required | 3306 |
| Username | string | Required | |
| Password | string | Required | |
| Database Name | string | Required | |
| SQL Query | text | Required | SELECT * FROM ... |
| TLS Mode | string | choices: Disabled, Preferred, Required, Skip Verify |
Returns: tool_result, results, row_count
03Oracle
Oracle Query
sql/oracle · Action
Execute a query against an Oracle database
| Field | Type | Details | |
|---|---|---|---|
| Database Host | string | Required | localhost |
| Database Port | integer | Required | 1521 |
| Username | string | Required | |
| Password | string | Required | |
| Service Name | string | Required | ORCL |
| SQL Query | text | Required | SELECT * FROM ... |
Returns: tool_result, results, row_count
04Postgresql
PostgreSQL Query
sql/postgresql · Action
Execute a query against a PostgreSQL database
| Field | Type | Details | |
|---|---|---|---|
| Database Host | string | Required | localhost |
| Database Port | integer | Required | 5432 |
| Username | string | Required | |
| Password | string | Required | |
| Database Name | string | Required | |
| SQL Query | text | Required | SELECT * FROM ... |
| SSL Mode | string | choices: Disable, Allow, Prefer, Require, Verify CA, Verify Full |
Returns: tool_result, results, row_count
05Notes & Limitations
Behaviours and constraints worth knowing before you build with these nodes.
- Only queries that begin with SELECT or WITH return data in the Results output; INSERT, UPDATE, DELETE and administrative statements (such as SHOW or CALL) report a Row Count only and leave Results empty.
- Row Count carries two meanings depending on the statement: for read queries it is the number of rows returned, and for write queries it is the number of rows changed.
- Each node runs a single statement, so supply one query per node rather than several semicolon-separated commands.
- Values pulled in from earlier steps are inserted directly into the query text, so text containing apostrophes or other special characters can break the query or change its meaning unless you quote or clean it first.
- Connections to MySQL and PostgreSQL are unencrypted unless you select a TLS or SSL mode, so choose a Required or Verify option when reaching a database across an untrusted network.