Run Query

Run Query connects to a PostgreSQL account, executes one SQL statement, and returns its result rows and affected-row count.

Inputs

Input	Type	Required	Description
Third-party account	PostgreSQL account	Yes	Host, database, credentials, port, and SSL settings.
Query	String	Yes	A non-empty SQL statement.
Parameters	List of any values	No	Values bound to `$1`, `$2`, `$3`, and later placeholders in order.

select id, email
from customers
where plan = $1 and created_at >= $2
order by created_at desc;

Add pro as parameter 1 and the cutoff date as parameter 2.

Use parameters for values instead of joining untrusted text into SQL. Parameter placeholders protect values, but they cannot stand in for table or column names.

Outputs

Output	Type	Description
Rows	List of objects	Rows returned by the query. Each object uses column names as keys.
Row Count	Number	The number of rows returned or affected.

The database connection is closed after the query succeeds or fails.

Yes/No QuestionAsk an OpenAI model for a boolean decision.

Overview

Fundamentals

Web, Files & Data

AI

Scraping & Rendering

Google Workspace

Email, CRM & Scheduling

Databases & Tables

Microsoft

Inputs

Outputs

​Inputs

​Outputs

Inputs

Outputs