mcp-server-neon

npmGitHub
Official
  • Databases
TypeScript
MIT
274
19
-
security - not tested
A
license - permissive license (MIT)
-
quality - not tested

Lets you use Claude Desktop, or any MCP Client, to use natural language to accomplish things with Neon.

  1. Tools
  2. Prompts
  3. Resources
  4. Server Configuration
  5. README.md

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription

No tools

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
NEON_API_KEYYesNeon API key, which can be generated through the Neon console.
Need Help?View Source CodeReport Issue
README.md

Neon MCP Server

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

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

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 watch # You can keep this open. cd mcp-client/ && NEON_API_KEY=... npm run start:mcp-server-neon

GitHub Badge

Glama performs regular codebase and documentation scans to:

  • Confirm that the MCP server is working as expected.
  • Confirm that there are no obvious security issues with dependencies of the server.
  • Extract server characteristics such as tools, resources, prompts, and required parameters.

Our directory badge helps users to quickly asses that the MCP server is safe, server capabilities, and instructions for installing the server.

Copy the following code to your README.md file:

Alternative MCP servers

  • mcp-server-gemini

    -
    security
    A
    license
    -
    quality
    Model Context Protocol (MCP) server implementation that enables Claude Desktop to interact with Google's Gemini AI models.
    MIT
    • Apple
    • Linux

  • mcp-github-project-manager

    -
    security
    A
    license
    -
    quality
    Provides comprehensive tools for managing GitHub projects, milestones, tasks, and sprints. This server integrates deeply with GitHub Projects V2, offering features like automated kanban workflows, sprint planning, and custom field management.
    MIT

  • servers

    -
    security
    A
    license
    -
    quality
    A Model Context Protocol server for Git repository interaction and automation. This server provides tools to read, search, and manipulate Git repositories via Large Language Models.
    MIT

  • mcp-knowledge-graph

    A
    security
    A
    license
    A
    quality
    An improved implementation of persistent memory using a local knowledge graph with a customizable --memory-path. This lets Claude remember information about the user across chats.
    MIT