AWS PostgreSQL MCP 服务器

模型上下文协议 (MCP) 服务器，通过query工具提供对 AWS PostgreSQL 数据库的只读 SQL 查询访问。配置使用环境变量。

设置

克隆：
git clone https://github.com/T1nker-1220/aws-postgress-mcp-server.git cd aws-postgress-mcp-server
安装和构建：
pnpm install pnpm run build

配置（用于 Cline/Windsurf）

将此服务器添加到您的 MCP 客户端的设置文件（例如， c:\Users\<User>\AppData\Roaming\Windsurf\User\globalStorage\saoudrizwan.claude-dev\settings\cline_mcp_settings.json ）：

{
  "mcpServers": {
    // ... other servers ...

    "aws-postgres-mcp-server": {
      "command": "node",
      "args": [
        // Full path to the built index.js
        "C:\\Users\\NATH\\Documents\\Cline\\MCP\\aws-postgress-mcp-server\\build\\index.js" 
      ],
      // Database credentials go in the 'env' object
      "env": {
        "DB_HOST": "YOUR_HOST.rds.amazonaws.com",
        "DB_PORT": "5432",
        "DB_NAME": "YOUR_DB_NAME",
        "DB_USER": "YOUR_DB_USER",
        "DB_PASSWORD": "YOUR_PASSWORD"
      },
      "transportType": "stdio",
      "disabled": false,
      "autoApprove": [] 
    }
    // ... other servers ...
  }
}

-> 将env对象中的占位符值替换为您的实际凭证。

用法

配置完成后，客户端将启动服务器。使用query工具：

<use_mcp_tool>
  <server_name>aws-postgres-mcp-server</server_name>
  <tool_name>query</tool_name>
  <arguments>
  {
    "sql": "SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';"
  }
  </arguments>
</use_mcp_tool>

笔记

服务器仅允许只读查询（SELECT、SHOW 等）。
要使用npx @t1nker-1220/aws-postgres-mcp-server ...配置客户端，必须先将包发布到 npm。配置仍将使用env对象作为凭证。

This server cannot be installed

security - not tested

license - not found

quality - not tested

How are these scores calculated?

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

MCP 服务器允许 Claude 等 AI 助手对 AWS PostgreSQL 数据库执行只读 SQL 查询，从而实现数据检索同时防止数据库修改。

Related MCP Servers

AWS CLI MCP Server
IcyKallen
-
security
F
license
-
quality
An MCP server that enables Claude to generate and execute AWS CLI commands, allowing users to manage AWS resources through natural language conversations.
Last updated -
2
TypeScript
Database Tools for Claude AI
elber-code
A
security
F
license
A
quality
MCP server that allows Claude AI to interact directly with MySQL databases, enabling query execution and table information retrieval through natural language.
Last updated -
1
3
4
JavaScript
FastPostgresMCP
llm-graph
A
security
A
license
A
quality
A blazing fast MCP server that enables AI agents to interact with multiple PostgreSQL databases, providing functionality to list tables, inspect schemas, execute queries, and run transactions.
Last updated -
4
98
TypeScript
MIT License
PostgreSQL Remote Cloudflare MCP Worker
wgh1992
-
security
F
license
-
quality
A Cloudflare Workers-based MCP server that provides PostgreSQL database access capabilities to AI assistants, allowing them to query and manipulate PostgreSQL databases through the Model Context Protocol.
Last updated -
TypeScript

View all related MCP servers

Appeared in Searches

How to connect to my AWS accounts

AWS PostgreSQL MCP Server