广告合作
MCP.so
登录

MCP Postgres Query Server

@RathodDarshil

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

RathodDarshil

关于 MCP Postgres Query Server

暂无概览

MCP Postgres Query Server 配置

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

{
  "mcpServers": {
    "postgres-query": {
      "command": "node",
      "args": [
        "/path/to/your/mcp-postgres-query-server/dist/index.js",
        "postgresql://username:password@hostname:port/database"
      ]
    }
  }
}

MCP Postgres Query Server 工具

工具列表暂未提供

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

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

概览

What is MCP Postgres Query Server?

MCP Postgres Query Server is a Model Context Protocol server that provides a secure, read-only interface to a PostgreSQL database. It is designed for use with Claude Desktop and other MCP clients, allowing users to execute SELECT queries safely.

How to use MCP Postgres Query Server?

Clone the repository, install dependencies (npm install), and build (npm run build). Configure Claude Desktop by adding the server to claude_desktop_config.json with the command node and an argument pointing to the built dist/index.js followed by your PostgreSQL connection string. Then restart Claude Desktop.

Key features of MCP Postgres Query Server

  • Read-only database access (SELECT queries only)
  • Query validation to block non-SELECT SQL
  • Automatic 10-second query timeout
  • Full MCP protocol implementation
  • Structured JSON query results

Use cases of MCP Postgres Query Server

  • Query a PostgreSQL database securely through Claude Desktop
  • Generate read-only database reports using natural language
  • Explore database schemas and data without write permissions
  • Integrate PostgreSQL data into MCP-based AI workflows

常见问题

1

What queries are allowed?

Only SQL SELECT queries are permitted; all other SQL statements are rejected by the validation logic.

2

What runtime dependencies are required?

Node.js v14 or later, npm, and a PostgreSQL database with connection credentials.

3

How do I connect the server to Claude Desktop?

Edit the `claude_desktop_config.json` file (accessible from Settings > Developer > Edit Config) and add a `postgres-query` entry with the correct path to the built server and your PostgreSQL connection string.

4

Does the server support write operations?

No, the server is strictly read-only. Query validation ensures only SELECT queries can execute.

5

How are database credentials handled?

Credentials are passed directly as a command-line argument (the connection string) and are not stored in configuration files.

评论

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

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

广告合作