AWS PostgreSQL MCP Server

Integrations

  • Allows cloning the MCP server repository to set up and configure the PostgreSQL integration.

  • Provides read-only SQL query access to an AWS PostgreSQL database, allowing users to execute SELECT queries and retrieve database information through the 'query' tool.

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-server
  2. 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.
-
security - not tested
F
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.

  1. Setup
    1. Configuration (for Cline/Windsurf)
      1. Usage
        1. Notes

          Related MCP Servers

          • -
            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
          • -
            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
            • Apple
          • 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
          • -
            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 -
            257
            Go
            Apache 2.0
            • Linux

          View all related MCP servers

          ID: 6v7tb94lsl