How to integrate Neon MCP with Mastra AI

This guide walks you through connecting Neon to Mastra AI using the Composio tool router. By the end, you'll have a working Neon agent that can create a new neon project with autoscaling, add a developer's email permission to a project, spin up a new branch database for testing through natural language commands. This guide will help you understand how to give your Mastra AI agent real control over a Neon account through Composio's Neon MCP server. Before we dive in, let's take a quick look at the key ideas and tools involved.

Neon logoNeon
Api Key

Neon is a serverless Postgres platform for building scalable apps faster. Its serverless architecture helps you launch, scale, and manage Postgres with zero overhead.

107 Tools

Introduction

This guide walks you through connecting Neon to Mastra AI using the Composio tool router. By the end, you'll have a working Neon agent that can create a new neon project with autoscaling, add a developer's email permission to a project, spin up a new branch database for testing through natural language commands.

This guide will help you understand how to give your Mastra AI agent real control over a Neon account through Composio's Neon MCP server.

Before we dive in, let's take a quick look at the key ideas and tools involved.

Also integrate Neon with

TL;DR

Here's what you'll learn:
  • Set up your environment so Mastra, OpenAI, and Composio work together
  • Create a Tool Router session in Composio that exposes Neon tools
  • Connect Mastra's MCP client to the Composio generated MCP URL
  • Fetch Neon tool definitions and attach them as a toolset
  • Build a Mastra agent that can reason, call tools, and return structured results
  • Run an interactive CLI where you can chat with your Neon agent

What is Mastra AI?

Mastra AI is a TypeScript framework for building AI agents with tool support. It provides a clean API for creating agents that can use external services through MCP.

Key features include:

  • MCP Client: Built-in support for Model Context Protocol servers
  • Toolsets: Organize tools into logical groups
  • Step Callbacks: Monitor and debug agent execution
  • OpenAI Integration: Works with OpenAI models via @ai-sdk/openai

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 serverless Postgres databases and project infrastructure, so your agent can perform actions like managing projects, configuring authentication, creating branches, and automating database operations on your behalf.

  • Project management and insights: Retrieve detailed information about specific Neon projects, including configurations, workflows, and current status for monitoring or troubleshooting.
  • Automated role and permission setup: Grant email-based permissions, add new roles to branches, and streamline access control across your projects with granular, automated adjustments.
  • Seamless API key and authentication management: Create new API keys for organizations or projects, manage authentication flows, and securely handle access credentials for integrations.
  • Database and branch orchestration: Spin up new Postgres databases within branches, create and configure compute endpoints, and automate the creation of development, testing, or isolated environments as needed.
  • Custom project provisioning: Launch new Neon projects with advanced quota, resource, and networking settings—tailored to your application's requirements and operational best practices.

What is the Composio tool router, and how does it fit here?

What is Composio SDK?

Composio's Composio SDK helps agents find the right tools for a task at runtime. You can plug in multiple toolkits (like Gmail, HubSpot, and GitHub), and the agent will identify the relevant app and action to complete multi-step workflows. This can reduce token usage and improve the reliability of tool calls. Read more here: Getting started with Composio SDK

The tool router generates a secure MCP URL that your agents can access to perform actions.

How the Composio SDK works

The Composio SDK follows a three-phase workflow:

  1. Discovery: Searches for tools matching your task and returns relevant toolkits with their details.
  2. Authentication: Checks for active connections. If missing, creates an auth config and returns a connection URL via Auth Link.
  3. Execution: Executes the action using the authenticated connection.

Step-by-step Guide

Step by step09 STEPS
1

Prerequisites

Before starting, make sure you have:
  • Node.js 18 or higher
  • A Composio account with an active API key
  • An OpenAI API key
  • Basic familiarity with TypeScript
2

Getting API Keys for OpenAI and Composio

OpenAI API Key
  • Go to the OpenAI dashboard and create an API key.
  • You need credits or a connected billing setup to use the models.
  • Store the key somewhere safe.
Composio API Key
  • Log in to the Composio dashboard.
  • Go to Settings and copy your API key.
  • This key lets your Mastra agent talk to Composio and reach Neon through MCP.
3

Install dependencies

bash
npm install @composio/core @mastra/core @mastra/mcp @ai-sdk/openai dotenv

Install the required packages.

What's happening:

  • @composio/core is the Composio SDK for creating MCP sessions
  • @mastra/core provides the Agent class
  • @mastra/mcp is Mastra's MCP client
  • @ai-sdk/openai is the model wrapper for OpenAI
  • dotenv loads environment variables from .env
4

Set up environment variables

bash
COMPOSIO_API_KEY=your_composio_api_key_here
COMPOSIO_USER_ID=your_user_id_here
OPENAI_API_KEY=your_openai_api_key_here

Create a .env file in your project root.

What's happening:

  • COMPOSIO_API_KEY authenticates your requests to Composio
  • COMPOSIO_USER_ID tells Composio which user this session belongs to
  • OPENAI_API_KEY lets the Mastra agent call OpenAI models
5

Import libraries and validate environment

typescript
import "dotenv/config";
import { openai } from "@ai-sdk/openai";
import { Agent } from "@mastra/core/agent";
import { MCPClient } from "@mastra/mcp";
import { Composio } from "@composio/core";
import * as readline from "readline";

import type { AiMessageType } from "@mastra/core/agent";

const openaiAPIKey = process.env.OPENAI_API_KEY;
const composioAPIKey = process.env.COMPOSIO_API_KEY;
const composioUserID = process.env.COMPOSIO_USER_ID;

if (!openaiAPIKey) throw new Error("OPENAI_API_KEY is not set");
if (!composioAPIKey) throw new Error("COMPOSIO_API_KEY is not set");
if (!composioUserID) throw new Error("COMPOSIO_USER_ID is not set");

const composio = new Composio({
  apiKey: composioAPIKey as string,
});
What's happening:
  • dotenv/config auto loads your .env so process.env.* is available
  • openai gives you a Mastra compatible model wrapper
  • Agent is the Mastra agent that will call tools and produce answers
  • MCPClient connects Mastra to your Composio MCP server
  • Composio is used to create a Tool Router session
6

Create a Tool Router session for Neon

typescript
async function main() {
  const session = await composio.create(
    composioUserID as string,
    {
      toolkits: ["neon"],
    },
  );

  const composioMCPUrl = session.mcp.url;
  console.log("Neon MCP URL:", composioMCPUrl);
What's happening:
  • create spins up a short-lived MCP HTTP endpoint for this user
  • The toolkits array contains "neon" for Neon access
  • session.mcp.url is the MCP URL that Mastra's MCPClient will connect to
7

Configure Mastra MCP client and fetch tools

typescript
const mcpClient = new MCPClient({
    id: composioUserID as string,
    servers: {
      nasdaq: {
        url: new URL(composioMCPUrl),
        requestInit: {
          headers: session.mcp.headers,
        },
      },
    },
    timeout: 30_000,
  });

console.log("Fetching MCP tools from Composio...");
const composioTools = await mcpClient.getTools();
console.log("Number of tools:", Object.keys(composioTools).length);
What's happening:
  • MCPClient takes an id for this client and a list of MCP servers
  • The headers property includes the x-api-key for authentication
  • getTools fetches the tool definitions exposed by the Neon toolkit
8

Create the Mastra agent

typescript
const agent = new Agent({
    name: "neon-mastra-agent",
    instructions: "You are an AI agent with Neon tools via Composio.",
    model: "openai/gpt-5",
  });
What's happening:
  • Agent is the core Mastra agent
  • name is just an identifier for logging and debugging
  • instructions guide the agent to use tools instead of only answering in natural language
  • model uses openai("gpt-5") to configure the underlying LLM
9

Set up interactive chat interface

typescript
let messages: AiMessageType[] = [];

console.log("Chat started! Type 'exit' or 'quit' to end.\n");

const rl = readline.createInterface({
  input: process.stdin,
  output: process.stdout,
  prompt: "> ",
});

rl.prompt();

rl.on("line", async (userInput: string) => {
  const trimmedInput = userInput.trim();

  if (["exit", "quit", "bye"].includes(trimmedInput.toLowerCase())) {
    console.log("\nGoodbye!");
    rl.close();
    process.exit(0);
  }

  if (!trimmedInput) {
    rl.prompt();
    return;
  }

  messages.push({
    id: crypto.randomUUID(),
    role: "user",
    content: trimmedInput,
  });

  console.log("\nAgent is thinking...\n");

  try {
    const response = await agent.generate(messages, {
      toolsets: {
        neon: composioTools,
      },
      maxSteps: 8,
    });

    const { text } = response;

    if (text && text.trim().length > 0) {
      console.log(`Agent: ${text}\n`);
        messages.push({
          id: crypto.randomUUID(),
          role: "assistant",
          content: text,
        });
      }
    } catch (error) {
      console.error("\nError:", error);
    }

    rl.prompt();
  });

  rl.on("close", async () => {
    console.log("\nSession ended.");
    await mcpClient.disconnect();
    process.exit(0);
  });
}

main().catch((err) => {
  console.error("Fatal error:", err);
  process.exit(1);
});
What's happening:
  • messages keeps the full conversation history in Mastra's expected format
  • agent.generate runs the agent with conversation history and Neon toolsets
  • maxSteps limits how many tool calls the agent can take in a single run
  • onStepFinish is a hook that prints intermediate steps for debugging

Complete Code

Here's the complete code to get you started with Neon and Mastra AI:

typescript
import "dotenv/config";
import { openai } from "@ai-sdk/openai";
import { Agent } from "@mastra/core/agent";
import { MCPClient } from "@mastra/mcp";
import { Composio } from "@composio/core";
import * as readline from "readline";

import type { AiMessageType } from "@mastra/core/agent";

const openaiAPIKey = process.env.OPENAI_API_KEY;
const composioAPIKey = process.env.COMPOSIO_API_KEY;
const composioUserID = process.env.COMPOSIO_USER_ID;

if (!openaiAPIKey) throw new Error("OPENAI_API_KEY is not set");
if (!composioAPIKey) throw new Error("COMPOSIO_API_KEY is not set");
if (!composioUserID) throw new Error("COMPOSIO_USER_ID is not set");

const composio = new Composio({ apiKey: composioAPIKey as string });

async function main() {
  const session = await composio.create(composioUserID as string, {
    toolkits: ["neon"],
  });

  const composioMCPUrl = session.mcp.url;

  const mcpClient = new MCPClient({
    id: composioUserID as string,
    servers: {
      neon: {
        url: new URL(composioMCPUrl),
        requestInit: {
          headers: session.mcp.headers,
        },
      },
    },
    timeout: 30_000,
  });

  const composioTools = await mcpClient.getTools();

  const agent = new Agent({
    name: "neon-mastra-agent",
    instructions: "You are an AI agent with Neon tools via Composio.",
    model: "openai/gpt-5",
  });

  let messages: AiMessageType[] = [];

  const rl = readline.createInterface({
    input: process.stdin,
    output: process.stdout,
    prompt: "> ",
  });

  rl.prompt();

  rl.on("line", async (input: string) => {
    const trimmed = input.trim();
    if (["exit", "quit"].includes(trimmed.toLowerCase())) {
      rl.close();
      return;
    }

    messages.push({ id: crypto.randomUUID(), role: "user", content: trimmed });

    const { text } = await agent.generate(messages, {
      toolsets: { neon: composioTools },
      maxSteps: 8,
    });

    if (text) {
      console.log(`Agent: ${text}\n`);
      messages.push({ id: crypto.randomUUID(), role: "assistant", content: text });
    }

    rl.prompt();
  });

  rl.on("close", async () => {
    await mcpClient.disconnect();
    process.exit(0);
  });
}

main();

Conclusion

You've built a Mastra AI agent that can interact with Neon through Composio's Tool Router. You can extend this further by:
  • Adding other toolkits like Gmail, Slack, or GitHub
  • Building a web-based chat interface around this agent
  • Using multiple MCP endpoints to enable cross-app workflows
TOOLS

Supported Tools

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

Accept project transfer request

Tool to accept a transfer request for a Neon project.

Access project details by id

Retrieves detailed information about a specific Neon serverless Postgres project.

Add new jwks to project endpoint

Adds a new JSON Web Key Set (JWKS) URL to a Neon project for JWT-based authentication.

Add project email permission

Adds permissions for a specified email address to a particular project within the Neon B2B SaaS integration platform.

Add role to branch

Creates a new PostgreSQL role within a specific branch of a Neon project.

Count project branches

Tool to get the total number of branches in a Neon project.

Create API Key for Organization

Creates a new API key for the specified organization in Neon.

Create Auth Provider SDK Keys

Tool to generate SDK or API keys for authentication providers.

Create auth user

Tool to create a new user in Neon Auth for a specific project branch.

Create branch database

Creates a new database within a specified project and branch in the Neon platform.

Enable Neon Auth for branch

Tool to enable Neon Auth integration for a branch.

Create Neon Data API

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

Create branch snapshot

Creates a snapshot from the specified branch at a specific point in time.

Create compute endpoint

Creates a new compute endpoint for a specified branch within a Neon project.

Create New API Key

Creates a new personal API key for the authenticated Neon user account.

Create new project branch

Creates a new branch in a Neon project.

Create anonymized branch

Creates a new branch with anonymized data using PostgreSQL Anonymizer for static masking.

Create project transfer request

Tool to create a transfer request for a Neon project.

Create project with quota and settings

Creates a new Neon project with specified configuration settings.

Set VPC endpoint restriction

Sets or updates a VPC endpoint restriction for a Neon project.

Assign or Update VPC Endpoint

Assigns an AWS VPC endpoint to a Neon organization for Private Networking, or updates the label of an existing VPC endpoint assignment.

Delete api key by id

Deletes a specific API key from the Neon platform.

Delete auth domains

Deletes domains from the redirect_uri whitelist for a specific branch's authentication configuration.

Delete OAuth provider

Deletes an OAuth provider configuration from a specific branch in a Neon project.

Delete auth user

Deletes an authentication user from a specified branch within a Neon project.

Delete branch data API

Deletes the Neon Data API for a specified branch and database.

Delete database from branch

Deletes a specific database from a designated branch within a project in the Neon platform.

Delete organization api key

Deletes a specific API key associated with an organization in the Neon platform.

Delete organization member

Removes a specific member from a Neon organization.

Delete project branch by id

Deletes a specific branch within a project in the Neon B2B SaaS integration platform.

Delete project branch role

Deletes a PostgreSQL role from a specific branch within a Neon project.

Delete project by id

Permanently deletes a Neon PostgreSQL project and all its associated resources.

Delete project endpoint

Deletes a specific endpoint within a Neon project.

Delete project jwks by id

Deletes a specific JSON Web Key Set (JWKS) associated with a given project in the Neon B2B SaaS integration platform.

Delete project permission

Deletes a specific permission associated with a project in the Neon B2B SaaS integration platform.

Delete project snapshot

Deletes a specific snapshot for a project in Neon.

Delete vpc endpoint by ids

Permanently deletes a VPC endpoint from a Neon organization in a specified AWS region.

Delete vpc endpoint by project id

Deletes a specific VPC endpoint within a designated project in the Neon platform.

Disable branches auth

Tool to disable Neon Auth for a specific branch in a Neon project.

Fetch database for branch

Retrieves a list of databases associated with a specific project and branch in the Neon platform.

Fetch organization members by id

Retrieves a list of all members associated with a specific organization in the Neon B2B SaaS integration platform.

Fetch vpcendpoint details by id

Retrieves the current state and configuration details of a specific VPC endpoint assigned to a Neon organization.

Finalize branch restore

Finalizes the restore operation for a branch created from a snapshot.

Get auth

Retrieves authentication information about the current API request credentials.

Get auth allow localhost

Retrieves the allow localhost configuration for a specific branch in a Neon project.

Get auth email provider

Retrieves the email provider configuration for Neon Auth on a specific branch.

Get available preload libraries

Retrieves the list of available shared preload libraries for a Neon project.

Get branches anonymized status

Retrieves the current status of an anonymized branch, including its state and progress information.

Get branches backup schedule

Retrieves the backup schedule configuration for a specified branch within a Neon project.

Get Neon Data API for branch

Retrieves the Neon Data API information for a specific branch and database.

Get branches for project

Retrieves a list of branches associated with a specific project in the Neon B2B SaaS integration platform.

Get branches masking rules

Retrieves the masking rules for the specified anonymized branch.

Get branch roles for project

Retrieves the roles associated with a specific branch within a project in the Neon B2B SaaS integration platform.

Get consumption history projects

Retrieves consumption history for projects within a Neon organization.

Get current user information

Retrieves the profile information for the currently authenticated user.

Get organization api keys

Retrieves a list of all API keys associated with a specific organization in the Neon B2B SaaS integration platform.

Get project branches

Retrieves detailed information about a specific branch within a Neon project.

Get project branch role

Retrieves detailed information about a specific role within a particular branch of a Neon project.

Get project branch schema comparison

Compares the database schema of a branch with another branch's schema in a Neon project.

Get project connection uri

Retrieves the connection URI for a specified project within the Neon B2B SaaS integration platform.

Get project endpoint information

Retrieves a list of all compute endpoints associated with a specific Neon project.

Get project operation by id

Retrieves detailed information about a specific operation within a Neon serverless PostgreSQL project.

Get schema for project branch

Retrieves the PostgreSQL database schema (DDL) for a specific database on a branch within a Neon project.

Get user organizations

Retrieves a list of organizations associated with the currently authenticated user in the Neon platform.

Get vpc region endpoints

Retrieves a list of VPC endpoints for a specified organization within a particular AWS region.

List api keys

Retrieves a list of API keys associated with the authenticated user's Neon account.

List auth domains

Lists the domains in the redirect_uri whitelist for the specified project and branch.

List Auth OAuth Providers

Retrieves the OAuth providers configured for Neon Auth on a specific branch.

List project snapshots

Tool to list all snapshots for a specified Neon project.

List shared projects

Retrieves a list of Neon Postgres projects shared with your account.

List VPC endpoints for organization

Tool to retrieve the list of VPC endpoints for a specified Neon organization across all regions.

Modify branch details in project

Updates the details of a specific branch within a project in the Neon platform.

Patch branch database information

Updates the properties of a specific database within a project branch in the Neon platform.

Reset role password for branch

Resets the password for a PostgreSQL role on a specific Neon branch and generates a new password.

Restart project endpoint

Restarts a Neon compute endpoint (Postgres instance) within a project.

Restore project branch

This endpoint restores a branch to a specific state or point in time.

Restore snapshot to new branch

Tool to restore a Neon snapshot to a new branch.

Retrieve account consumption history

Retrieves the consumption history for a specified account within the Neon platform.

Retrieve all regions

Retrieves a list of available geographic regions supported by the Neon B2B SaaS integration platform.

Retrieve branch database details

Retrieves detailed information about a specific database within a Neon project and branch.

Retrieve branch endpoints

Retrieves all compute endpoints associated with a specific branch in a Neon project.

Retrieve jwks for project

Retrieves the JSON Web Key Set (JWKS) for a specified project.

Retrieve organization by id

Retrieves detailed information about a specific organization within the Neon platform.

Retrieve organization invitations

Retrieves a list of all pending invitations for a specified organization.

Retrieve organization member info

Retrieves detailed information about a specific member within an organization in the Neon B2B SaaS integration platform.

Retrieve project endpoint details

Retrieves detailed information about a specific compute endpoint within a Neon serverless PostgreSQL project.

Retrieve project operations

Retrieves a list of operations associated with a specific project in the Neon B2B SaaS integration platform.

Retrieve project permissions

Retrieves the current permissions settings for a specific project within the Neon B2B SaaS integration platform.

Retrieve projects list

Retrieves a list of all Neon projects associated with the authenticated user's account.

Retrieve vpc endpoints for project

Retrieves a list of VPC (Virtual Private Cloud) endpoints associated with a specific project in the Neon B2B SaaS integration platform.

Reveal role password in branch

Reveals the password for a specific role within a branch of a Neon project.

Send auth test email

Tool to send a test email using specified SMTP configuration for Neon Auth.

Send organization invitations

Creates and sends invitations to join an organization in the Neon B2B SaaS integration platform.

Set branch as default

Sets a specified branch as the default branch for a given project in Neon.

Start branch anonymization

Starts the anonymization process for an anonymized branch that is in the initialized, error, or anonymized state.

Start endpoint for project

Starts a suspended or idle compute endpoint for a Neon PostgreSQL project.

Suspend project endpoint by id

Suspends a specific endpoint within a project in the Neon B2B SaaS integration platform.

Transfer projects between organizations

Transfers selected projects from one organization to another organization.

Transfer user projects to organization

Transfers multiple projects from the authenticated user's personal account to a specified organization within the Neon B2B SaaS integration platform.

Update auth allow localhost

Updates the allow localhost configuration for a specific branch in a Neon project.

Update branch auth email provider

Updates the email provider configuration for a specific branch's authentication system.

Update branches data API

Updates the Neon Data API configuration for the specified branch.

Update branches masking rules

Updates the masking rules for the specified anonymized branch.

Update organization member role

Updates the role of a specific member within an organization in the Neon B2B SaaS integration platform.

Update project compute endpoint settings

Updates the configuration of a specific compute endpoint within a Neon project.

Update project settings by id

Updates the configuration and settings of a specific Neon project.

Update project snapshot

Tool to update the name of a specific snapshot in a Neon project.

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. Mastra AI 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.It takes 30 seconds.

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

Start building