广告合作
MCP.so
登录

Postgres MCP Server

@RonHouben

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

RonHouben

关于 Postgres MCP Server

MCP Server for postgres

Postgres MCP Server 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

Postgres MCP Server 工具

工具列表暂未提供

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

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

概览

What is postgres-mcp-server?

A PostgreSQL Model Context Protocol server that lets an LLM interact with a local database. It is experimental and not intended for real databases.

How to use postgres-mcp-server?

Install Node.js, run npm install, and set the environment variables DATABASE_NAME, DATABASE_USER, DATABASE_PASSWORD, and DATABASE_SCHEMA_NAME. A VSCode configuration snippet is provided to integrate the server via stdio.

Key features of postgres-mcp-server

  • Experimental PostgreSQL MCP server for local databases
  • Connects using environment variable configuration
  • Supports read and write SQL queries
  • Runs via npm start with stdio transport
  • Integrates with VSCode chat’s MCP discovery

Use cases of postgres-mcp-server

  • Letting an LLM query a local development database
  • Experimenting with database interactions in a safe environment

常见问题

1

Is postgres-mcp-server safe for production databases?

No, it is experimental; do not use it on real databases and be careful with write queries.

2

What are the prerequisites to run postgres-mcp-server?

You need Node.js installed and must run `npm install` to install dependencies.

3

What environment variables are required?

`DATABASE_NAME`, `DATABASE_USER`, `DATABASE_PASSWORD`, and `DATABASE_SCHEMA_NAME` (typically `public`).

4

How do I configure postgres-mcp-server in VSCode?

Add a configuration block in your `settings.json` with the command `npm`, type `stdio`, args `["start", "--prefix", "/path/to/code/postgres-mcp-server"]`, and set the required environment variables.

5

What transport does postgres-mcp-server use?

It uses stdio transport, as shown in the VSCode configuration example.

评论

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

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

4

Elasticsearch MCP Server

elastic

685

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

广告合作