Neon PostgreSQL MCP Server

@spragginsdesigns

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

spragginsdesigns

关于 Neon PostgreSQL MCP Server

暂无概览

#neon-pg#postgresql #mcp-server

Neon PostgreSQL MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "neon-pg-mcp-server": {
      "command": "node",
      "args": [
        "pg-mcp-server.js"
      ]
    }
  }
}

Neon PostgreSQL MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Neon PostgreSQL MCP Server?

A Model Context Protocol (MCP) server that provides secure access to Neon PostgreSQL databases, enabling AI assistants like Claude to interact with your database through standardized tools for querying, modifying, listing tables, and describing table structures.

How to use Neon PostgreSQL MCP Server?

Clone the repository, install dependencies with npm install, and set the NEON_PG_CONNECTION_STRING environment variable to your Neon PostgreSQL connection string. Run one of the provided server implementations (e.g., node pg-mcp-server.js for the ES module version) and configure your MCP-compatible client (e.g., Claude Desktop or Cursor IDE) to point to the server script with the environment variable set.

Key features of Neon PostgreSQL MCP Server

Secure SSL/TLS encrypted connections to Neon PostgreSQL.
Connection pooling with configurable maximum connections and idle timeout.
Input validation and type safety for all operations.
Comprehensive error handling with meaningful messages.
Full implementation of the Model Context Protocol specification.
Multiple server implementations (ES module, CommonJS, basic, TypeScript).

Use cases of Neon PostgreSQL MCP Server

AI assistants querying database tables using SELECT statements.
Data modification tasks (INSERT, UPDATE, DELETE) via the Execute tool.
Exploring database schema by listing tables and describing column structures.
Integrating Neon PostgreSQL capabilities into Claude Desktop or Cursor IDE workflows.

常见问题

What are the prerequisites to use this server?

Node.js 18+, a Neon PostgreSQL database account with a connection string, and an MCP-compatible client such as Claude Desktop or Cursor IDE.

How do I secure my database connection?

The server enforces SSL/TLS connections to Neon PostgreSQL. Store your connection string as an environment variable and never commit it to version control. Use parameterized queries to prevent SQL injection.

Can I adjust the connection pool settings?

Yes, you can modify the default pool settings (maximum connections: 10, idle timeout: 30 seconds) in the connection pool initialization code within the server file.

What tools does the server expose?

It provides four tools: Query (for SELECT statements), Execute (for INSERT, UPDATE, DELETE), Get Tables (lists public schema tables), and Describe Table (returns column details and primary keys).

How do I integrate this server with Claude Desktop?

Open Claude Desktop settings, navigate to Developer → MCP Servers, add a new server with command `node`, args pointing to the server script path, and env including `NEON_PG_CONNECTION_STRING`.

数据库分类下的更多 MCP 服务器

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes