Question 1

How do I connect NoClick to my PostgreSQL database?

Accepted Answer

Add a credential to the PostgreSQL node using either a full connection string in the form postgresql://user:password@host:port/database, or individual fields for host, port, database, username, and password. You can also set the SSL mode, which is required by most managed Postgres providers. The database must be reachable from NoClick's servers.

Question 2

Can I run parameterized queries to avoid SQL injection?

Accepted Answer

Yes. Both the SELECT query and the execute statement operations accept a separate parameters array, and you reference those values in your SQL as $1, $2, and so on. NoClick binds the parameters server-side, so values coming from upstream nodes are never concatenated into the query string. This is the recommended way to pass dynamic data from a form, webhook, or earlier node.

Question 3

What is the difference between the query and execute operations?

Accepted Answer

Run Select Query is for SELECT statements and returns rows as JSON, with a configurable row limit up to 10,000. Execute SQL Statement is for INSERT, UPDATE, DELETE, and other non-SELECT statements; it reports the affected row count and can optionally return rows when your statement includes a RETURNING clause. For very large result sets, the cursor-based query operation streams results in batches.

Question 4

Can the node manage database structure, not just data?

Accepted Answer

Yes. Beyond querying, the node can create and drop tables, schemas, indexes, and views, truncate tables, install extensions, and inspect structure with list-tables, list-columns, and get-table-info operations. It can also run maintenance operations like VACUUM and ANALYZE. This lets a workflow provision or clean up database objects as part of an automation.

Question 5

Does NoClick support PostgreSQL transactions?

Accepted Answer

It does. The node exposes Begin Transaction, Commit Transaction, and Rollback Transaction operations so you can group several statements into one atomic unit. If a step inside the transaction fails, you can route the workflow to a rollback so no partial change is left behind.

PostgreSQL Integration

What you can automate with PostgreSQL

PostgreSQL Operations

Query7

Query

Execute

Execute Many

Query Cursor

Copy To Table

Copy From Table

Explain Query

Table9

List Tables

List Columns

Get Table Info

Create Table

Drop Table

Truncate Table

List Constraints

Vacuum Table

Analyze Table

Schema3

List Schemas

Create Schema

Drop Schema

Database1

List Databases

Index3

List Indexes

Create Index

Drop Index

View3

List Views

Create View

Drop View

Sequence4

List Sequences

Get Next Sequence Value

Get Current Sequence Value

Set Sequence Value

Function2

List Functions

Call Function

Trigger1

List Triggers

Extension2

List Extensions

Create Extension

Role2

List Users

List Roles

Transaction3

Begin Transaction

Commit Transaction

Rollback Transaction

Frequently asked questions

Related integrations

Ready to build with PostgreSQL?