Which Sheets and Postgres operations can Hermes use?

Only the operations you allowlist on each node, such as read range, append row, and run query. If you do not expose a write, the agent can read but not change anything.

Do I have to host Hermes myself?

No. NoClick runs the Hermes harness for you and wires both Google Sheets and Postgres in as tools, so there is nothing to install or self-host.

Can it run SQL that changes my database?

Only if you allowlist a write or update operation on the Postgres node. With just a read query exposed, it can report findings but cannot modify rows.

Hermes is an open agent based on Nous Research’s Hermes models. NoClick runs it for you and adds your connected apps as tools.

How do I give Hermes access to an app?

Connect the app's integration node to the agent's tools handle and pick the operations to expose. Each becomes a callable tool.

Do I need my own infrastructure?

No. The harness runs in a hosted sandbox and NoClick handles credentials for the apps you connect.

Can Hermes use multiple apps at once?

Yes. Wire in several integrations and the agent can use them together in a single run.

Connect Hermes to Google Sheets and PostgreSQL

Connect Google Sheets and Postgres to Hermes and you get an agent that moves data between a spreadsheet people actually use and the database of record. It can read rows from a sheet, write them into a Postgres table, run a query, and push the results back so a tab stays in sync. The pairing turns Hermes into a hands-off bridge between your team's working sheet and your production data.

Loading preview…

Opens a workflow with 125 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 Hermes, or hosted in the cloud. The rest of setup adapts to your choice:
Pick what it can do in Google Sheets
A preset of real Google Sheets operations. Each one becomes a tool the agent can call, and it can't touch anything outside the list.
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 Google Sheets
One sign-in. The agent acts through your account, scoped to the operations you picked.
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 Hermes first calls in. Hermes connects when it next starts a session.
1. Run this in your terminal
$hermes mcp add noclick --url https://mcp.noclick.app/s/<your-link>
2. Answer no when asked if the server requires authentication — the link itself is the key
<your-link> is your personal server URL — setup mints it for you.

Exact capabilities

Tools Hermes gets

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

Google Sheets

85 tools

Read Sheet Data

Configuration for reading data from a Google Sheet

Write Sheet Data

Configuration for writing data to a Google Sheet

Append Rows to Sheet

Configuration for appending rows to a Google Sheet

Clear Sheet Range

Configuration for clearing values from a range

Create New Spreadsheet

Configuration for creating a new spreadsheet

Fetch Spreadsheet Metadata

Configuration for getting spreadsheet metadata

Read Multiple Sheet Ranges

Configuration for reading multiple ranges at once

Write to Multiple Sheet Ranges

Configuration for writing to multiple ranges at once

Add Spreadsheet Sheet

Configuration for adding a new sheet/tab

Delete Spreadsheet Sheet

Configuration for deleting a sheet/tab

Copy Sheet to Spreadsheet

Configuration for copying a sheet to another spreadsheet

Rename Spreadsheet Sheet

Configuration for renaming a sheet/tab

Duplicate Sheet in Spreadsheet

Configuration for duplicating a sheet within the same spreadsheet

Find and Replace in Spreadsheet

Configuration for find and replace in a spreadsheet

Insert Sheet Rows

Configuration for inserting rows

Delete Sheet Rows

Configuration for deleting rows

Clear Multiple Sheet Ranges

Configuration for clearing multiple ranges at once

Insert Sheet Columns

Configuration for inserting columns

Delete Sheet Columns

Configuration for deleting columns

Format Cells

Configuration for formatting a range of cells

Update Sheet Properties

Configuration for sheet-level display properties

Auto-Resize Columns Or Rows

Configuration for auto-sizing columns or rows to fit their contents

Set Column Width Or Row Height

Configuration for setting an explicit column width or row height

Merge Cells

Configuration for merging cells

Unmerge Cells

Configuration for unmerging cells

Add Or Remove Borders

Configuration for drawing borders on a range

Add Alternating Colours

Configuration for alternating row colours

Set Filter

Configuration for adding a filter to a range

Clear Filter

Configuration for removing a filter

Add Conditional Formatting

Configuration for a conditional formatting rule

Sort Range

Configuration for sorting a range

Add Dropdown Or Input Rule

Configuration for adding a dropdown or input rule to a range

Remove Dropdown Or Input Rule

Configuration for removing dropdowns / input rules from a range

Remove Conditional Formatting

Configuration for removing conditional formatting rules

Remove Alternating Colours

Configuration for removing alternating row colours

Convert Range To Table

Configuration for turning a range into a Sheets table

Delete Table

Configuration for removing a table

Edit Conditional Formatting

Configuration for editing or reordering a conditional formatting rule

Recolour Alternating Colours

Configuration for recolouring existing banding in place

Edit Table

Configuration for changing a table's name, range or column types

Update Spreadsheet Properties

Configuration for spreadsheet-level properties

Add Named Range

Configuration for naming a range

Update Named Range

Configuration for changing a named range

Delete Named Range

Configuration for removing a named range

Protect Range

Configuration for protecting a range from edits

Update Protected Range

Configuration for changing a protected range

Unprotect Range

Configuration for removing range protection

Cell Notes

Configuration for putting a hover note on cells

Insert Smart Chips

Configuration for inserting people or link smart chips

Pivot Table

Configuration for anchoring a pivot table

Copy And Paste Range

Configuration for copying a range onto another

Cut And Paste Range

Configuration for moving a range

Paste Delimited Text

Configuration for pasting delimited text

Auto-Fill Range

Configuration for extending a series

Split Text To Columns

Configuration for splitting a column of text

Trim Whitespace

Configuration for trimming whitespace

Remove Duplicate Rows

Configuration for removing duplicate rows

Randomise Range

Configuration for shuffling rows

Insert Cells

Configuration for inserting cells and shifting the rest

Delete Cells

Configuration for deleting cells and shifting the rest

Move Rows Or Columns

Configuration for moving rows or columns

Append Rows Or Columns

Configuration for appending blank rows or columns

Add Chart

Configuration for adding a chart

Edit Chart

Configuration for changing an existing chart

Move Or Resize Chart

Configuration for moving or resizing a chart

Set Chart Border

Configuration for a chart's border colour

Delete Chart

Configuration for removing a chart

Append Rows After Data

Configuration for appending rows of cells after the last row of data

Filter View

Configuration for creating a saved filter view

Update Filter View

Configuration for changing a filter view

Duplicate Filter View

Configuration for copying a filter view

Delete Filter View

Configuration for removing a filter view

Group Rows Or Columns

Configuration for grouping rows or columns

Collapse Or Expand Group

Configuration for collapsing or expanding a group

Ungroup Rows Or Columns

Configuration for ungrouping rows or columns

Add Slicer

Configuration for adding a slicer control

Update Slicer

Configuration for changing a slicer

Add Developer Metadata

Configuration for tagging a sheet, row or column with durable metadata

Update Developer Metadata

Configuration for changing developer metadata

Delete Developer Metadata

Configuration for removing developer metadata

Connect BigQuery Data Source

Configuration for connecting a BigQuery data source

Repoint Data Source

Configuration for repointing a data source

Delete Data Source

Configuration for disconnecting a data source

Refresh Data Source

Configuration for refreshing connected data

Cancel Data Source Refresh

Configuration for cancelling a running refresh

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

Read new rows from a Google Sheet and insert them into a Postgres table

Run a Postgres query and write the results into a sheet tab for the team to read

Reconcile a sheet against the database and flag rows that do not match

Append a daily Postgres metric snapshot to a tracking sheet

Meet the runner

About Hermes

Hermes is an open agent built on Nous Research’s Hermes models. NoClick runs it hosted and connects your apps to it as tools, so it can do real work across your systems. Wire an integration into the agent and Hermes can use that app’s operations directly while it reasons through a task. It is a strong pick when you want an open-model agent with genuine tool access.

Built on open Hermes models

Capable general reasoning

Flexible, open-model foundation

Hosted with apps wired in as tools

Good to know