How to integrate Neon MCP with Hermes

Connect Hermes to Neon MCP. Create a new neon project and database, deploy branch to staging and run migrations, and more using natural language, with authentication handled for you.

Neon MCP logoNeon MCP
Dcr Oauth

Neon MCP is a managed platform for Neon projects, branches, and databases. Use it to streamline development workflows and manage databases with clarity.

104 Tools

Introduction

Hermes is a 24/7 autonomous agent that lives on your computer or server — it remembers what it learns and evolves as your usage grows.

This guide explains the easiest and most robust way to connect your Neon account to Hermes. You can do this through either Composio Connect CLI or Composio Connect MCP. For personal use we recommend the CLI, but you won't go wrong with MCP either.

Also integrate Neon MCP with

What is Composio Connect?

Composio Connect is a consumer offering that lets anyone plug 1,500+ applications directly into their agent harness — including Hermes. It can:

  • Search and load tools from relevant toolkits on-demand, reducing context usage.
  • Chain multiple tools to accomplish complex workflows via a remote workbench, without excessive back-and-forth with the LLM.
  • Manage app authentication end-to-end with zero manual overhead.

Integrating Neon with Hermes

Using Composio Connect CLI

1. Install the Composio CLI

Run the install script directly, or paste https://composio.dev/hermes into your Hermes chat box to have it installed for you.

bash
curl -fsSL https://composio.dev/install | bash
Hermes authenticating with Composio

2. Authenticate

Once the CLI is installed, ask Hermes to authenticate with Composio.

3. Connect to Neon

Ask your agent to connect to Neon, or simply request any Neon-related task. Hermes will prompt you to authenticate and authorize access.

4. Done. You're all set with a new Neon connection.


Using Composio Connect MCP

1. Get your MCP URL and API Key

Go to dashboard.composio.dev and copy your Connect MCP URL and API key.

Copy MCP URL and API key from Composio dashboard

2. Open the Hermes config file

bash
nano ~/.hermes/config.yaml

3. Add the Composio Connect MCP server

bash
mcp_servers:
  composio:
    url: "https://connect.composio.dev/mcp"
    headers:
      x-consumer-api-key: "YOUR_COMPOSIO_API_KEY"
    connect_timeout: 60
    timeout: 180

Save with Ctrl + O, Enter, then exit with Ctrl + X.

4. Restart your Hermes agent

Once restarted, ask your agent to connect to Neon or request any Neon-related task. It will prompt you to authenticate and authorize access.

5. Done!

What is the Neon MCP server, and what's possible with it?

The Neon MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your Neon account. It provides structured and secure access to your Neon projects, branches, databases, authentication, functions, and storage, so your agent can create projects and branches, manage PostgreSQL resources, inspect schemas, analyze queries, and create snapshots on your behalf.

  • Project and branch management: Have your agent create, inspect, or delete Neon projects and branches, and retrieve branch settings and usage details.
  • PostgreSQL resource administration: Let the agent create or delete databases, compute resources, and Postgres roles, or retrieve a database connection string.
  • Schema inspection and query analysis: Direct your agent to explore branch objects, review table columns and constraints, compare database schemas, or analyze SQL execution plans.
  • Snapshots and development workflows: Instruct your agent to create or delete snapshots, finalize branch restores, and apply or discard prepared migration and query tuning changes.
  • Authentication, functions, and storage: Have your agent manage Neon Auth users, OAuth providers, and trusted domains, deploy or delete functions, and create or remove storage buckets and objects.

Way Forward

With Neon connected, Hermes can now act on your behalf whenever it detects a relevant task or you ask it to.

From here, you can extend Hermes further:

  • Connect more apps: Calendar, Slack, Notion, Linear, and hundreds of others are available through the same Composio Connect setup. Each new integration compounds what Hermes can do for you.
  • Build workflows across tools: Once multiple apps are connected, Hermes can chain actions together — turn an email into a calendar invite, a Slack message into a Linear ticket, or a meeting note into a follow-up draft.
  • Let it learn your patterns: The more you use Hermes, the better it gets at anticipating how you'd handle recurring tasks. Give it feedback on drafts and decisions, and it will adapt.

If you run into trouble or want to share what you've built, join the community or check out the Docs for deeper configuration options.

TOOLS

Supported Tools

Every Neon MCP action and event your agent gets out of the box.

Add auth oauth provider

Adds an OAuth provider configuration to the specified branch's Neon Auth integration.

Add auth trusted domain

Adds a domain to the redirect URI whitelist for the specified branch.

Compare database schema

Compare one database's SQL schema on a branch to another.

Complete database migration

Apply or discard a prepared migration and delete the temporary branch.

Complete query tuning

Apply or discard query-tuning changes and delete the temporary branch.

Create auth user

Creates a new user in the Neon Auth user directory for the specified branch.

Create branch

Creates a branch with a read-write compute and waits until it is ready.

Create postgres database

Creates a database in the specified branch.

Create postgres endpoint

Creates a compute endpoint on a branch.

Create postgres role

Creates a Postgres role in the specified branch.

Create project

Creates a Neon project and waits until the default compute is ready.

Create snapshot

Creates a snapshot from the specified branch.

Create storage bucket

Creates a new branchable object storage bucket on the specified branch.

Delete auth oauth provider

Deletes an OAuth provider from the specified project.

Delete auth trusted domain

Removes a domain from the redirect URI whitelist for the specified branch.

Delete auth user

Deletes the specified user from the Neon Auth user directory for the specified branch.

Delete branch

Delete a branch and all its data.

Delete data api

Deletes the Neon Data API for the specified branch.

Delete function

Deletes the function identified by its slug.

Delete functions custom domain

Removes a custom domain registered on the branch and stops routing it.

Delete postgres database

Deletes the specified database from the branch.

Delete postgres endpoint

Deletes the specified compute endpoint.

Delete postgres role

Deletes the specified Postgres role from the branch.

Delete project

Delete a Neon project and all its data.

Delete snapshot

Deletes the specified snapshot.

Delete storage bucket

Deletes the named bucket from the specified branch.

Delete storage object

Deletes the named object from the bucket on the specified branch.

Delete storage objects by prefix

Soft-deletes every object on the specified branch whose key starts with `prefix`, in a single call.

Deploy function

Creates a deployment for the function.

Describe branch

Get a tree view of all objects in a branch, including databases, schemas, tables, views, and functions.

Describe project

Retrieves the project record (settings, compute, usage).

Describe table schema

Get column definitions, data types, and constraints for a specific table.

Disable auth

Disables the Neon Auth integration for the specified branch, removing the connection to the authentication provider.

Explain sql statement

Analyze the query execution plan for a SQL statement using EXPLAIN ANALYZE.

Fetch

Fetch detailed information about a specific organization, project, or branch using the ID returned by the `search` tool.

Finalize branch restore

Finalize a branch created with `restore_snapshot` and `finalize: false`: reassign computes (this restarts them) and swap names so it replaces the original branch.

Get ai gateway

Returns the AI Gateway endpoint host for the specified branch, used to render code-snippet base URLs.

Get auth

Retrieves the Neon Auth integration details for the specified branch, including the auth provider type and integration status.

Get branch

Retrieves information about the specified branch.

Get connection string

Get a PostgreSQL connection string for a Neon database.

Get data api

Retrieves the Neon Data API configuration for the specified branch, including endpoint URL, enabled state, and database settings.

Get database tables

List all tables in a Neon database.

Get default branch

Resolve the project's default branch by the default flag, not by name.

Get doc resource

Fetch one Neon documentation page as markdown.

Get function

Returns the function identified by its slug.

Get neon auth config

Read Neon Auth config for a branch with OAuth and SMTP secrets redacted as "***redacted***".

Get operation

Retrieves details for the specified operation.

Get postgres database

Retrieves information about the specified database.

Get postgres endpoint

Retrieves information about the specified compute endpoint.

Get postgres role

Retrieves details about the specified role.

Get snapshot schedule

Returns the backup schedule for the specified branch, including the configured snapshot frequencies.

Get storage

Returns whether branchable object storage is usable for the specified branch.

Inspect database

Run one read-only neon inspect db check (pick `check` from the input schema).

List auth oauth providers

Lists the OAuth providers configured for the specified branch's Neon Auth integration.

List auth trusted domains

Lists the trusted domains in the redirect URI whitelist for the specified branch.

List branch computes

Retrieves a list of compute endpoints for the specified branch.

List branches

Retrieves a list of branches for the specified project.

List docs resources

List Neon documentation page slugs from neon.

List functions

Lists functions on the specified branch.

List functions custom domains

Lists all custom domains registered on the branch, across every target entity.

List log fields

Lists the low-cardinality log fields observed on this branch.

List log field values

Lists distinct values for a low-cardinality log field.

List operations

Lists operations for a project.

List organizations

List all organizations the current user belongs to.

List postgres databases

Retrieves a list of databases for the specified branch.

List postgres endpoints

Retrieves a list of compute endpoints for the specified project.

List postgres roles

Retrieves a list of Postgres roles from the specified branch.

List project members

Lists organization members and their per-project roles for an org-owned project.

List project permissions

Retrieves details about users who have access to the project, including the permission `id`, the granted-to email address, and the date project access was granted.

List projects

List Neon projects you own.

List regions

Lists Neon regions available to the authenticated account.

List slow queries

List queries from pg_stat_statements by execution time, slowest first.

List snapshots

Lists the snapshots for the specified project.

List storage buckets

Lists branchable object storage buckets visible on the specified branch, including those inherited from ancestor branches.

List storage objects

Lists objects visible in the named bucket on the specified branch, including those inherited from ancestor branches.

Prepare database migration

Apply a schema change on a temporary branch and return a migration_id.

Prepare query tuning

Analyze a slow query on a temporary branch and return a tuning_id.

Presign storage object

Returns a presigned URL that transfers bytes directly to or from the object's bucket on the specified branch, without the caller ever handling S3 credentials.

Provision neon auth

Enables Neon Auth for the specified branch by connecting it to an authentication provider.

Provision neon data api

Creates a new instance of Neon Data API in the specified branch.

Query logs

Returns logs for a branch.

Recover project

Recovers a deleted project within the 7-day deletion recovery period.

Register functions custom domain

Registers a hostname on the branch and routes it to a function.

Reset from parent

Reset a branch to its parent's current HEAD.

Reset postgres role password

Resets the password for the specified Postgres role.

Restart postgres endpoint

Restarts the specified compute endpoint by immediately suspending it and then starting it again.

Restore snapshot

Restore a snapshot onto a new or existing branch.

Run sql

Execute one SQL statement on a Neon database.

Run sql transaction

Execute multiple SQL statements as one transaction.

Search

Search across all organizations, projects, and branches by keyword.

Set default branch

Sets the specified branch as the project's default branch.

Set snapshot schedule

Replace a branch's automatic snapshot schedule.

Start postgres endpoint

Starts a compute endpoint.

Suspend postgres endpoint

Suspends the specified compute endpoint.

Update auth config

Updates the auth configuration for the branch.

Update auth oauth provider

Updates an OAuth provider for the specified project.

Update auth user role

Updates the role of a user in the Neon Auth user directory for the specified branch.

Update branch

Updates the specified branch.

Update data api

Updates the Neon Data API configuration for the specified branch.

Update function

Updates the function's mutable metadata — currently only the display `name`.

Update postgres database

Updates the specified database in the branch.

Update postgres endpoint

Updates the specified compute endpoint.

Update project

Updates the specified project.

Update snapshot

Updates the specified snapshot.

FAQ

Frequently asked questions

With a standalone Neon MCP server, the agents and LLMs can only access a fixed set of Neon tools tied to that server. However, with the Composio Tool Router, agents can dynamically load tools from Neon and many other apps based on the task at hand, all through a single MCP endpoint.

Yes, you can. Hermes fully supports MCP integration. You get structured tool calling, message history handling, and model orchestration while Tool Router takes care of discovering and serving the right Neon tools.

Yes, absolutely. You can configure which Neon scopes and actions are allowed when connecting your account to Composio. You can also bring your own OAuth credentials or API configuration so you keep full control over what the agent can do.

All sensitive data such as tokens, keys, and configuration is fully encrypted at rest and in transit. Composio is SOC 2 Type 2 compliant and follows strict security practices so your Neon data and credentials are handled as safely as possible.

Start with Neon MCP.It takes 30 seconds.

Managed auth, hosted MCP servers, and every Neon MCP tool your agent needs.Free to start.

Start building