MCP.so
ログイン

Neon PostgreSQL MCP Server

@spragginsdesigns

リポジトリ

Neon PostgreSQL MCP Server について

概要はまだありません

#neon-pg#postgresql#mcp-server

基本情報

カテゴリ

データベース

ランタイム

node

トランスポート

stdio

公開者

spragginsdesigns

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

ツール

ツールは検出されませんでした

ツールは 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.

FAQ from Neon PostgreSQL MCP Server

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.

コメント

「データベース」の他のコンテンツ

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245

Elasticsearch MCP Server

elastic

685

Snowflake MCP Server

isaacwasserman

185

mcp_mysql_server

wenb1n-dev

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245