How do I connect NoClick to my PostgreSQL database?

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.

Can I run parameterized queries to avoid SQL injection?

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.

What is the difference between the query and execute operations?

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.

Can the node manage database structure, not just data?

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.

Does NoClick support PostgreSQL transactions?

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.

How does OpenClaw act on my apps?

You connect an integration to the agent's tools handle and select operations. OpenClaw calls those operations as tools while it runs.

Is there anything to install?

No. NoClick runs the OpenClaw harness for you in a hosted sandbox.

Can I run it on a schedule?

Yes. A hosted agent can be started from a schedule, a webhook, or another app event.

Which apps can it use?

Any of NoClick’s tool-provider integrations across communication, CRM, developer tools, databases, and more.

Connect OpenClaw to PostgreSQL

Hand a coding agent your Postgres database as a tool and it changes the schema itself rather than handing you SQL to run. It can create tables, schemas, and views, add or drop indexes, install extensions, copy data in and out of tables, and run work inside a begin and commit transaction, calling each operation as a tool as it goes. In NoClick it wires into a hosted coding agent that can take a migration from plan to applied on its own.

Loading preview…

Opens a workflow with 40 tools ready to use.

What happens next

Set up in minutes

The open button drops you into a guided setup. It asks exactly this, nothing else:

Choose where it runs
On your computer through your own OpenClaw, or hosted in the cloud. The rest of setup adapts to your choice:
Pick what it can do in PostgreSQL
A preset of real PostgreSQL operations. Each one becomes a tool the agent can call, and it can't touch anything outside the list.
Connect PostgreSQL
One sign-in. The agent acts through your account, scoped to the operations you picked.
Add your personal MCP link
The last step mints a private MCP URL for this agent and walks you through exactly this, with your real link filled in. The page flips to Connected the moment your OpenClaw first calls in. OpenClaw probes the server while adding it, so this lights up during openclaw mcp add.
Run this in your terminal
$openclaw mcp add noclick --url https://mcp.noclick.app/s/<your-link>
<your-link> is your personal server URL — setup mints it for you.

Exact capabilities

Tools OpenClaw gets

Pick the operations you want and each becomes a tool the agent can call directly while it works.

PostgreSQL

40 tools

Run Select Query

Execute a SELECT query and return results as JSON

Execute Sql Statement

Execute an INSERT, UPDATE, DELETE, or other non-SELECT statement

Execute Batch Statements

Execute a statement with multiple parameter sets (batch operations)

Run Query with Cursor

Execute query with cursor for large result sets

Copy Data to Table

Bulk import data to a table using COPY

Copy Data from Table

Bulk export data from a table using COPY

List Schema Tables

List all tables in a schema

List Table Columns

Get column metadata for a table

Get Table Info

Get detailed information about a table including constraints and indexes

Create Table

Create a new table

Drop Table

Drop a table

Truncate Table

Truncate a table (remove all rows)

List Schemas

List all schemas in the database

Create Schema

Create a new schema

Drop Schema

Drop a schema

List Databases

List all databases in the PostgreSQL server

List Schema Indexes

List all indexes in a schema

Create Index

Create an index on a table

Drop Index

Drop an index

List Schema Views

List all views in a schema

Create View

Create a view

Drop View

Drop a view

List Schema Sequences

List all sequences in a schema

Get Sequence Next Value

Get the next value from a sequence (nextval)

Get Sequence Current Value

Get the current value from a sequence (currval)

Set Sequence Value

Set the current value of a sequence (setval)

List Schema Functions

List all functions in a schema

Call Database Function

Call a PostgreSQL function

List Table Constraints

List all constraints for a table

List Schema Triggers

List all triggers in a schema

List Extensions

List all installed extensions

Install Extension

Create/install an extension

List Database Users

List all database users

List Database Roles

List all database roles

Explain Query Plan

Explain a query's execution plan

Vacuum Table

Vacuum a table to reclaim storage and update statistics

Analyze Table Statistics

Analyze a table to update statistics

Begin Transaction

Begin a new transaction

Commit Transaction

Commit the current transaction

Rollback Transaction

Rollback the current transaction

Starting points

What you can build

Run a SELECT query on a schedule to pull yesterday's sales rows and pass them to a Slack or email node for a daily report.

Execute an INSERT statement to log every incoming form submission or webhook payload into an audit table.

Use the batch execute operation to apply the same UPDATE across hundreds of rows in a single workflow step.

Bulk-import a CSV or API response into a table with the COPY data operation, then verify the load with a row-count query.

Run an EXPLAIN query plan step against a slow query and route the plan into an AI node to suggest a new index.

Wrap a multi-statement change in begin, execute, and commit operations so a partial failure rolls back cleanly.

Meet the runner

About OpenClaw

OpenClaw is an open command-line agent. NoClick runs it hosted and lets you connect your apps to it as tools, so it can take real actions across your systems. Wire an integration into the agent and OpenClaw can call that app’s operations directly. It is a good fit when you want an open, no-fuss agent with real tool access and nothing to install.

Open and approachable

Simple to point at a task

Solid general tool use

Hosted, with nothing to install

Good to know