Interact with the Neon serverless Postgres platform

What is Neon

Neon MCP Server

*npm version* *npm downloads* *License: MIT* *smithery badge*

Model Context Protocol (MCP) is a new, standardized protocol for managing context between large language models (LLMs) and external systems. In this repository, we provide an installer as well as an MCP Server for Neon.

This lets you use Claude Desktop, or any MCP Client, to use natural language to accomplish things with Neon, e.g.:

  • Let's create a new Postgres database, and call it "my-database". Let's then create a table called users with the following columns: id, name, email, and password.
  • I want to run a migration on my project called "my-project" that alters the users table to add a new column called "created_at".
  • Can you give me a summary of all of my Neon projects and what data is in each one?

Claude Setup

Installing via Smithery

To install Neon MCP Server for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install neon --client claude

Requirements

  • Node.js >= v18.0.0
  • Claude Desktop
  • Neon API key - you can generate one through the Neon console. Learn more or click here for quick access.

How to use locally

  1. Run npx @neondatabase/mcp-server-neon init $NEON_API_KEY
  2. Restart Claude Desktop
  3. You should now be able to try a simple command such as List me all my Neon projects

Guides

  • Neon MCP Server Guide
  • Connect MCP Clients to Neon
  • Cursor with Neon MCP Server
  • Claude Desktop with Neon MCP Server
  • Cline with Neon MCP Server
  • Windsurf with Neon MCP Server

Features

Supported Tools

  • list_projects

  • describe_project

  • create_project

  • delete_project

  • create_branch

  • delete_branch

  • describe_branch

  • get_connection_string

  • run_sql

  • run_sql_transaction

  • get_database_tables

  • describe_table_schema

  • prepare_database_migration

  • complete_database_migration

  • provision_neon_auth

Migrations

Migrations are a way to manage changes to your database schema over time. With the Neon MCP server, LLMs are empowered to do migrations safely with separate "Start" and "Commit" commands.

The "Start" command accepts a migration and runs it in a new temporary branch. Upon returning, this command hints to the LLM that it should test the migration on this branch. The LLM can then run the "Commit" command to apply the migration to the original branch.

Development

Development with MCP CLI Client

The easiest way to iterate on the MCP Server is using the mcp-client/. Learn more in mcp-client/README.md.

npm install
npm run build
npm run watch # You can keep this open.
cd mcp-client/ && NEON_API_KEY=... npm run start:mcp-server-neon

Development with Claude Desktop

npm install
npm run build
npm run watch # You can keep this open.
node dist/index.js init $NEON_API_KEY

Then, restart Claude each time you want to test changes.

Testing

To run the tests you need to setup the .env file according to the .env.example file.

npm run test

How to Use

Leave a Comment

Frequently Asked Questions

What is MCP?

MCP (Model Context Protocol) is an open protocol that standardizes how applications provide context to LLMs. Think of MCP like a USB-C port for AI applications, providing a standardized way to connect AI models to different data sources and tools.

What are MCP Servers?

MCP Servers are lightweight programs that expose specific capabilities through the standardized Model Context Protocol. They act as bridges between LLMs like Claude and various data sources or services, allowing secure access to files, databases, APIs, and other resources.

How do MCP Servers work?

MCP Servers follow a client-server architecture where a host application (like Claude Desktop) connects to multiple servers. Each server provides specific functionality through standardized endpoints and protocols, enabling Claude to access data and perform actions through the standardized protocol.

Are MCP Servers secure?

Yes, MCP Servers are designed with security in mind. They run locally with explicit configuration and permissions, require user approval for actions, and include built-in security features to prevent unauthorized access and ensure data privacy.

Related MCP Servers

MasterGo MCP Server avatar

MasterGo MCP Server

MasterGo Magic MCP 是一个独立的 MCP (Model Context Protocol) 服务,用于连接 MasterGo 设计工具与 AI 模型。它允许 AI 模型直接从 MasterGo 设计文件中获取 DSL 数据。

DesignMastergoofficial
Filesystem MCP Server avatar

Filesystem MCP Server

A core MCP server that provides filesystem access capabilities for Claude. Enables secure reading, writing, and management of files on your local system with granular permission controls.

filesystemcoreofficial
Brave Search MCP avatar

Brave Search MCP

Integrate Brave Search capabilities into Claude through MCP. Enables real-time web searches with privacy-focused results and comprehensive web coverage.

searchapiofficial
PostgreSQL MCP Server avatar

PostgreSQL MCP Server

A Model Context Protocol server that provides read-only access to PostgreSQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

databasepostgresqlcommunity
prisma prisma avatar

prisma prisma

Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB

cockroachdbgomcp
yaoxiaolinglong mcp mongodb mysql server avatar

yaoxiaolinglong mcp mongodb mysql server

用于mysql和mongodb的mcp

mcpgodatabase
OpenLinkSoftware mcp pyodbc server avatar

OpenLinkSoftware mcp pyodbc server

A simple MCP ODBC server using FastAPI, ODBC and PyODBC.

mcpapidatabase
executeautomation mcp database server avatar

executeautomation mcp database server

MCP Database Server is a new MCP Server which helps connect with Sqlite, SqlServer and Posgresql Databases

posgresqlsqlitemcp
dreamfactorysoftware df mcp avatar

dreamfactorysoftware df mcp

DreamFactory MCP Server enables AI assistants like Claude to directly query your databases through DreamFactory's auto-generated REST APIs.

apimcpai
attarmau FastMCP RecSys avatar

attarmau FastMCP RecSys

A mockup full stack app built with React, FastAPI, MongoDB, and Docker, powered by AWS Rekognition & CLIP for multi-tagging and clothing recommendations

goapimcp

Submit Your MCP Server

Share your MCP server with the community

Submit Now