What features does Neon MCP server provide?

Q: What features does Neon MCP server provide?

Project Management: Expose actions to list, describe, create and delete Neon projects, plus listing shared projects and organizations, enabling project lifecycle management via natural language.. Branch Management: Create, delete, describe branches; list branch computes; compare database schemas between branches; reset to parent state, enabling safe development workflows.. SQL Query Execution: Run single SQL statements or transactions, fetch connection strings, and inspect database tables and schemas, all through natural language prompts.. Database Migrations: Initiate and finalize schema migrations using a temporary branch workflow; test migrations safely before applying to the main branch.. Query Performance Optimization: Identify slow queries, obtain detailed execution plans, and test optimizations in a temporary branch before committing changes.. Neon Auth Provisioning: Provision Neon Auth for Neon projects, simplifying integration with authentication providers.. Search, Discovery & Resources: Search across organizations, projects and branches and fetch details; load Neon documentation and usage guidelines.

Neon MCP Server 2025: Features & Setup Guide

Overview

The Neon MCP Server is an open-source MCP (Model Context Protocol) server and installer for Neon, enabling natural language interaction with Neon Postgres databases through the Neon API. It acts as a bridge between LLM prompts and Neon services, translating natural language requests into the necessary API calls to create projects and branches, run queries, and perform database migrations. It exposes a set of tools for project lifecycle management (list, describe, create, delete projects; list organizations), branch operations (create, delete, describe, list computes; compare schemas; reset to parent), SQL execution (get connection string, run SQL and transactions, list tables, describe table schemas), and migrations tooling. It also covers performance tuning workflows (slow query detection, explain plans, and safe tuning on temporary branches) and authentication provisioning. The server can be run remotely (OAuth-based) against Neon’s managed MCP server or locally with a Neon API key, and supports two transports: Streamable HTTP (recommended) and SSE. A read-only mode is available to restrict destructive actions. Intended for local development and IDE integrations, it ships with guides and security guidance to review actions before execution.

Features

Project Management

Expose actions to list, describe, create and delete Neon projects, plus listing shared projects and organizations, enabling project lifecycle management via natural language.

Branch Management

Create, delete, describe branches; list branch computes; compare database schemas between branches; reset to parent state, enabling safe development workflows.

SQL Query Execution

Run single SQL statements or transactions, fetch connection strings, and inspect database tables and schemas, all through natural language prompts.

Database Migrations

Initiate and finalize schema migrations using a temporary branch workflow; test migrations safely before applying to the main branch.

Query Performance Optimization

Identify slow queries, obtain detailed execution plans, and test optimizations in a temporary branch before committing changes.

Neon Auth Provisioning

Provision Neon Auth for Neon projects, simplifying integration with authentication providers.

Search, Discovery & Resources

Search across organizations, projects and branches and fetch details; load Neon documentation and usage guidelines.