mcpField
A
AWS PostgreSQL MCP Server

AWS PostgreSQL MCP Server

Local
github.com/T1nker-1220Cloud & Infra0Updated 79w ago
Repository

About AWS PostgreSQL MCP Server

An MCP server that provides read-only SQL query access to an AWS PostgreSQL database. It is configured with environment variables and exposes database queries through a single `query` tool.

Key features

  1. 01Queries AWS PostgreSQL databases
  2. 02Provides a `query` tool
  3. 03Restricts queries to read-only operations
  4. 04Uses environment variables for configuration

Use cases

  1. 01Inspect tables in a PostgreSQL database
  2. 02Run read-only SQL queries from an MCP client

MCP support

Exposes a `query` tool to MCP clients for read-only SQL access to an AWS PostgreSQL database.

#aws#postgresql#mcp-server

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

No install method listed yet

We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.

Repository

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

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.

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.