Skip to main content
Glama

AWS PostgreSQL MCP Server

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对象作为凭证。
-
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. 设置
    1. 配置(用于 Cline/Windsurf)
      1. 用法
        1. 笔记

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

          View all related MCP servers

          MCP directory API

          We provide all the information about MCP servers via our MCP API.

          curl -X GET 'https://glama.ai/api/mcp/v1/servers/T1nker-1220/aws-postgress-mcp-server'

          If you have feedback or need assistance with the MCP directory API, please join our Discord server