AWS PostgreSQL MCP ServerServer

T1nker-1220
GitHub
Database IntegrationPostgreSQLMCP Server

Loading subscription status...

💡 Description

An MCP server that allows AI models like Claude to execute read-only SQL queries against an AWS PostgreSQL database, ensuring that data retrieval is done without modifying the database.

📝 JSON Entries

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

🛠️ Tools

query

Features

  • Read-only access to PostgreSQL database
  • Environment variable configuration

💬 Example Queries

  • SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';