MCP.so
登录

PostgreSQL

@divyanshu-vashu

代码仓库

关于 PostgreSQL

暂无概览

#mathgpt#math-solver#math-assistant

基本信息

分类

数据库

运行时

node

传输方式

stdio

发布者

divyanshu-vashu

配置

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

{
  "mcpServers": {
    "MCP-SERVER-PG": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "mcp/postgres",
        "-f",
        "src/postgres/Dockerfile",
        "."
      ]
    }
  }
}

工具

1

Execute read-only SQL queries against the connected database

概览

What is PostgreSQL?

A Model Context Protocol server that provides read‑only access to PostgreSQL databases. It enables LLMs to inspect database schemas and execute read‑only SQL queries against a connected PostgreSQL instance.

How to use PostgreSQL?

Configure the server in the mcpServers section of claude_desktop_config.json. Use either Docker (docker run -i --rm mcp/postgres postgresql://...) or NPX (npx -y @modelcontextprotocol/server-postgres). Provide a PostgreSQL connection URL, optionally including username and password.

Key features of PostgreSQL?

  • Execute read‑only SQL queries via the query tool.
  • Automatically discover and expose JSON table schemas.
  • Schemas include column names and data types.
  • All queries run inside a READ ONLY transaction.
  • Supports Docker and NPX deployment.
  • MIT licensed.

Use cases of PostgreSQL?

  • Let an LLM explore a live PostgreSQL database schema.
  • Run safe, read‑only analytical queries from a chat interface.
  • Allow users to ask natural‑language questions about database content.
  • Provide schema context to AI agents for generating accurate SQL.

FAQ from PostgreSQL

What type of queries does this server support?

Only read‑only SQL queries. All executions are wrapped in a READ ONLY transaction to prevent modifications.

How do I connect to a PostgreSQL database running on my local machine?

When using Docker on macOS, use host.docker.internal as the host in the connection URL. For example: postgresql://host.docker.internal:5432/mydb. Replace /mydb with your database name.

Can I include credentials in the connection URL?

Yes. Use the full PostgreSQL URI format: postgresql://user:password@host:port/db‑name.

What information does the server expose as resources?

For each table, a JSON schema resource (postgres://<host>/<table>/schema) is provided, containing column names and data types, automatically discovered from database metadata.

How do I run the server without Docker?

Use the NPX method: set the command to npx with arguments -y @modelcontextprotocol/server-postgres followed by your connection string.

评论

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

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

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

Elasticsearch MCP Server

elastic

685

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K