MCP.so
登录

MCP Postgres Server

@MadeByNando

代码仓库

关于 MCP Postgres Server

暂无概览

#mcp-postgres-server#postgresql#database

基本信息

分类

数据库

运行时

node

传输方式

stdio

发布者

MadeByNando

配置

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

{
  "mcpServers": {
    "mcp-postgres-server-madebynando": {
      "command": "docker",
      "args": [
        "logs",
        "mcp-postgres-server"
      ]
    }
  }
}

工具

未检测到工具

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

概览

What is MCP Postgres Server?

MCP Postgres Server implements the Model Context Protocol (MCP) for Cursor, letting you use a PostgreSQL database as storage for model contexts. It is designed for developers who want to securely query and explore PostgreSQL databases directly from Cursor.

How to use MCP Postgres Server?

Clone the repository and start the server with Docker Compose (docker-compose up -d). Then configure a new MCP connection in Cursor (Settings > MCP) using the command docker exec -i mcp-postgres-server node dist/index.js.

Key features of MCP Postgres Server

  • Runs PostgreSQL as MCP storage via Docker.
  • Exposes three tools: query, list tables, describe table.
  • postgres_query executes read-only SQL queries.
  • postgres_list_tables lists all database tables.
  • postgres_describe_table returns a table’s schema.
  • Enables secure database exploration from Cursor.

Use cases of MCP Postgres Server

  • Querying a PostgreSQL database directly from Cursor’s agent.
  • Listing tables and inspecting schemas during development.
  • Integrating database context into AI‑assisted coding workflows.
  • Troubleshooting database structure without leaving the editor.

FAQ from MCP Postgres Server

What are the prerequisites to run MCP Postgres Server?

Docker and Docker Compose must be installed on your system.

How do I configure MCP Postgres Server in Cursor?

In Cursor, go to Settings > MCP, add a new connection with the command docker exec -i mcp-postgres-server node dist/index.js.

What tools does MCP Postgres Server expose?

It exposes three tools: postgres_query (read-only SQL), postgres_list_tables (list all tables), and postgres_describe_table (describe a table’s schema).

Is the query tool safe for production databases?

Yes, postgres_query is explicitly read-only, so it cannot modify data.

How do I troubleshoot if the server fails to start?

Check the container logs with docker logs mcp-postgres-server or restart the server with docker-compose restart.

评论

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

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531

Elasticsearch/OpenSearch MCP Server

cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.

295

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

mcp_mysql_server

xwb602625136

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

245

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617