mcp server neon
Lets you use Claude Desktop, or any MCP Client, to use natural language to accomplish things with [Neon](https://neon.tech/).
Lets you use Claude Desktop, or any MCP Client, to use natural language to accomplish things with [Neon](https://neon.tech/).
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?To install Neon MCP Server for Claude Desktop automatically via Smithery:
npx -y @smithery/cli install neon --client claude
npx @neondatabase/mcp-server-neon init $NEON_API_KEYList me all my Neon projectslist_projectsdescribe_projectcreate_projectdelete_project
create_branch
delete_branchdescribe_branch
get_connection_string
run_sqlrun_sql_transactionget_database_tablesdescribe_table_schema
prepare_database_migration
complete_database_migration
provision_neon_auth
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.
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
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.
To run the tests you need to setup the .env file according to the .env.example file.
npm run test