aws-postgress-mcp-server
AWS PostgreSQL MCP Server
Documentation
AWS PostgreSQL MCP Server
A Model Context Protocol (MCP) server providing read-only SQL query access to an AWS PostgreSQL database via the `query` tool. Configuration uses environment variables.
Setup
1. Clone:
git clone https://github.com/T1nker-1220/aws-postgress-mcp-server.git
cd aws-postgress-mcp-server2. Install & Build:
pnpm install
pnpm run buildConfiguration (for Cline/Windsurf)
Add this server to your MCP client's settings file (e.g., `c:\Users\\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 ...
}
}-> Replace the placeholder values in the `env` object with your actual credentials.
Usage
Once configured, the client will start the server. Use the `query` tool:
aws-postgres-mcp-server
query
{
"sql": "SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';"
}Notes
- The server only allows read-only queries (SELECT, SHOW, etc.).
- To configure clients using `npx @t1nker-1220/aws-postgres-mcp-server ...`, the package must first be published to npm. The configuration would still use the `env` object for credentials.
Frequently asked questions
What is aws-postgress-mcp-server?
aws-postgress-mcp-server is AWS PostgreSQL MCP Server
How do I install aws-postgress-mcp-server?
Open the GitHub repository and follow its README. Most MCP servers are added to your client's MCP config, then called by your agent.
Is aws-postgress-mcp-server open source?
Yes — it is hosted on GitHub at https://github.com/T1nker-1220/aws-postgress-mcp-server.
Related MCP tools
🔥 Official Firecrawl MCP Server - Adds powerful web scraping and search to Cursor, Claude and any other LLM clients.
Use any LLMs (Large Language Models) for Deep Research. Support SSE API and MCP server.
Enhanced MCP server for interactive user feedback and command execution in AI-assisted development, featuring dual interface support (Web UI and Desktop Application) with intelligent environment detection and cross-platform compatibility.
A powerful Zotero AI and MCP plugin with ChatGPT, Gemini 3.7, Claude Fable 5, Claude Opus 5, DeepSeek V4, Grok, OpenRouter, Kimi k3, GLM 5.3, SiliconFlow, GPT-oss, Gemma 4, Qwen 3.8
Connect your browser to AI models. Just use Dia on Chrome, Arc or Firefox.
文颜 MCP Server 可以让 AI 自动将 Markdown 文章排版后发布至微信公众号。
Run your own MCP server? See who uses it and what to fix.
Measure it with TrackMCP