Skip to main content
Glama
Sign In
enesjakozh

AWS PostgreSQL MCP Server

by T1nker-1220
GitHub
JavaScript
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

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 服务器

模型上下文协议 (MCP) 服务器，通过query工具提供对 AWS PostgreSQL 数据库的只读 SQL 查询访问。配置使用环境变量。

设置

  1. 克隆：
    git clone https://github.com/T1nker-1220/aws-postgress-mcp-server.git cd aws-postgress-mcp-server
  2. 安装和构建：
    pnpm install pnpm run build

配置（用于 Cline/Windsurf）

将此服务器添加到您的 MCP 客户端的设置文件（例如， 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 ... } }

-> 将env对象中的占位符值替换为您的实际凭证。

用法

配置完成后，客户端将启动服务器。使用query工具：

<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>

笔记

  • 服务器仅允许只读查询（SELECT、SHOW 等）。
  • 要使用npx @t1nker-1220/aws-postgres-mcp-server ...配置客户端，必须先将包发布到 npm。配置仍将使用env对象作为凭证。

This server cannot be installed

-
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.

MCP 服务器允许 Claude 等 AI 助手对 AWS PostgreSQL 数据库执行只读 SQL 查询，从而实现数据检索同时防止数据库修改。

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

          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
            • Apple

          • 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/Gatewayofficial

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

          View all related MCP servers

          ID: 6v7tb94lsl