Neon: Auto-scaling Serverless PostgreSQL. Effortless Deployments.

Neon: Serverless Postgres that scales automatically. Effortless deployments, pay-as-you-go, and no server headaches. Fast, smart, future-ready.

Visit Repository

✨ Cloud Platforms

4.5(166 reviews)

249 saves

116 comments

This tool saved users approximately 5990 hours last month!

About Neon

What is Neon: Auto-scaling Serverless PostgreSQL. Effortless Deployments?

Neon is a serverless PostgreSQL service that automates scaling and deployment, paired with the Model Context Protocol (MCP) to enable natural language interactions. By integrating with tools like Claude Desktop, developers can manage databases using simple commands, eliminating manual configuration. For example, creating a new database or altering schemas becomes as straightforward as writing a sentence.

How to use Neon: Auto-scaling Serverless PostgreSQL. Effortless Deployments?

Start by installing the Neon MCP Server via Node.js (v18+). After obtaining your Neon API key from the console, run npx @neondatabase/mcp-server-neon init $NEON_API_KEY and restart Claude Desktop. You can then execute commands directly in Claude, such as List me all my Neon projects to view your database setups instantly.

Neon Features

Key Features of Neon: Auto-scaling Serverless PostgreSQL. Effortless Deployments?

Database Management: Create, delete, or describe projects and branches using commands like create_project or describe_table_schema.
Safe Migrations: Use start_database_migration to test schema changes in a temporary branch, then commit_database_migration to apply them safely.
SQL Execution: Run ad-hoc queries or multi-statement transactions via run_sql_transaction.

Use Cases of Neon: Auto-scaling Serverless PostgreSQL. Effortless Deployments?

Developers can automate repetitive tasks, like setting up test environments by saying Create a new branch for staging. Teams can collaborate seamlessly—imagine a non-technical user asking Show me all tables in the production project

Neon FAQ

FAQ from Neon: Auto-scaling Serverless PostgreSQL. Effortless Deployments?

Q: How do I install the MCP Server? Install via npm and follow the CLI setup steps outlined in the docs.
Q: Can I undo a migration? Always test changes in a migration branch first—rollbacks are possible if issues arise during the start phase.
Q: What if my API key expires? Regenerate it from the Neon console and re-run the initialization command.

Content

Neon MCP Server

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

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

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

Features

Supported Tools

list_projects
describe_project
create_project
delete_project
create_branch
delete_branch
describe_branch
run_sql
run_sql_transaction
get_database_tables
describe_table_schema
start_database_migration
commit_database_migration

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

In the current project folder, run:

bash npm install npm run watch node dist/index.js init $NEON_API_KEY

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