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

Clone:
git clone https://github.com/T1nker-1220/aws-postgress-mcp-server.git cd aws-postgress-mcp-server
Install & Build:
pnpm install pnpm run build

Configuration (for Cline/Windsurf)

Add this server to your MCP client's settings file (e.g., 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 ...
  }
}

-> 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:

<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>

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.

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.

An MCP server allowing AI assistants like Claude to execute read-only SQL queries against AWS PostgreSQL databases, enabling data retrieval while preventing database modifications.

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
8
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
42
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

AWS PostgreSQL MCP Server