hermes

Connect Hermes to Notion and PostgreSQL

With Notion and Postgres wired into Hermes, the agent can turn raw database results into readable documentation without a manual export step. It runs a Postgres query, shapes the output, and writes or updates a Notion page with the findings. That combination is handy for keeping a living dashboard or report in Notion that reflects what the database actually says.

Loading preview…
Opens a workflow with 59 tools ready to use.

Tools Hermes gets

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

Notion

19 tools
Search Pages and Databases

Search pages and databases by title

Query Notion Database

Query a database to retrieve pages

Fetch Database Metadata

Retrieve a database's metadata and schema

Create Page Database

Create a new database as a child of a page

Update Database Metadata

Update a database's title, description, or properties

Fetch Page Properties

Retrieve a page's properties

Create Notion Page

Create a new page in a database or as a child of another page

Update Page Properties

Update a page's properties, icon, or cover

Fetch Notion Block

Retrieve a block

Fetch Block Children

Retrieve a block's children

Append Children to Block

Append new children blocks to a parent block

Update Block Content

Update a block's content

Delete Notion Block

Delete (archive) a block

List Workspace Users

List all users in the workspace

Fetch Workspace User

Retrieve a user by ID

Fetch Bot Integration User

Retrieve the bot user for the current integration

Create Page Comment

Create a comment on a page or in an existing discussion thread

Fetch Page Comment

Retrieve a comment by its ID

List Block Comments

List comments on a block or page

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

What you can build

Query Postgres for weekly metrics and write them into a Notion report page
Refresh a Notion table from the latest rows in a Postgres view
Pull a Postgres list of new signups and append them to a Notion CRM database
Answer a question from a Notion doc by checking the matching Postgres data

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

Frequently asked questions

Build a custom Hermes agent

Open your Hermes agent in one click

NoClick runs Hermes for you with Notion and PostgreSQL wired in as tools. Connect your account and run.