AWS PostgreSQL

Provides read-only SQL query access to an AWS PostgreSQL database via the query tool for MCP clients.

javascript

GitHub Stars

javascript

Language

7 months ago

First Indexed

3 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "t1nker-1220-aws-postgress-mcp-server": {
      "command": "node",
      "args": [
        "C:\\Users\\NATH\\Documents\\Cline\\MCP\\aws-postgress-mcp-server\\build\\index.js"
      ],
      "env": {
        "DB_HOST": "YOUR_HOST.rds.amazonaws.com",
        "DB_NAME": "YOUR_DB_NAME",
        "DB_PORT": "5432",
        "DB_USER": "YOUR_DB_USER",
        "DB_PASSWORD": "YOUR_PASSWORD"
      }
    }
  }
}

This MCP server provides read-only SQL query access to an AWS PostgreSQL database through a dedicated query tool. It enables you to run safely scoped SQL queries from an MCP client, making it easy to fetch data without granting full database access.

How to use

After you configure the MCP client to connect to this server, you can run read-only SQL queries against your AWS PostgreSQL database using the query tool. Typical usage includes inspecting database schema, listing tables, and executing SELECT statements to retrieve data. Each query runs with the permissions defined by the database user you supply in the configuration.

How to install

Prerequisites you need before installing this MCP server are Node.js and a modern operating system. You will also need a MCP client setup capable of loading and running local MCP servers.

Additional configuration and usage notes

{
  "mcpServers": {
    // ... other servers ...

    "aws_postgres_mcp": {
      "command": "node",
      "args": [
        "C:\\Users\\NATH\\Documents\\Cline\\MCP\\aws-postgress-mcp-server\\build\\index.js"
      ],
      "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 ...
  }
}

Security and usage cautions

This server is designed for read-only access. Only SELECT, SHOW, and other read-only commands are permitted. Handle credentials securely and restrict access to trusted MCP clients.

Available tools

query

Executes read-only SQL queries against the configured AWS PostgreSQL database using the MCP client’s query tool.

Built by

VeilStrat

AI signals for GTM teams