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

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

Model Context Protocol PostgreSQL Server
endaoment
-
security
F
license
-
quality
A server that allows AI models to interact with PostgreSQL databases through a standardized protocol, providing database schema information and SQL query execution capabilities.
Last updated -
JavaScript
MariaDB MCP Server
abel9851
-
security
A
license
-
quality
An MCP server implementation that enables Claude to execute read-only queries against MariaDB databases and explore database schemas through natural language.
Last updated -
5
Python
MIT License
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
6
3
JavaScript
CentralMind/Gateway
centralmind
-
security
A
license
-
quality
MCP-Server from your Database optimized for LLMs and AI-Agents. Supports PostgreSQL, MySQL, ClickHouse, Snowflake, MSSQL, BigQuery, Oracle Database, SQLite, ElasticSearch, DuckDB
Last updated -
358
Go
Apache 2.0

View all related MCP servers

AWS PostgreSQL MCP Server