AWS PostgreSQL MCP Server
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
Related MCP server: tusk-mcp
配置(用于 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
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Connectors
Query 40 databases from Claude, ChatGPT, or Cursor — on any device. Read-only, encrypted, audited.
Query your org's data in natural language — read-only MCP access to SQL, NoSQL, files & warehouses.
Query your warehouse or a CSV with Claude/ChatGPT over MCP, governed by table-level ACL + audit.
Cloud-hosted MCP server for secure AI access to enterprise data sources via CData Connect AI.
Related MCP Servers
- FlicenseDqualityDmaintenanceA secure Model Context Protocol server that allows Claude to execute read-only SQL queries against a PostgreSQL database, enabling natural language interaction with database data.1-
- AlicenseNot gradedqualityCmaintenanceA read-only PostgreSQL MCP server that enables AI agents to perform schema introspection and execute SELECT-only queries. It supports secure database connections through SSL and SSH tunnels while offering a structure-only mode to restrict query access.10MIT
- AlicenseNot gradedqualityDmaintenanceRead-only PostgreSQL MCP server that enables running SELECT queries, listing tables and schemas, and describing columns, with built-in protection against writes and malicious SQL attacks.607MIT
- FlicenseNot gradedqualityFmaintenanceA read-only MCP server that enables AI agents to explore database schemas and execute safe queries on PostgreSQL and MySQL.-