AWS PostgreSQL MCP Server

A Model Context Protocol (MCP) server providing read-only SQL query access to an AWS PostgreSQL database via thequerytool. Configuration uses environment variables.
- Clone:

git clone https://github.com/T1nker-1220/aws-postgress-mcp-server.git cd aws-postgress-mcp-server

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 theenvobject with your actual credentials.

Once configured, the client will start the server. Use thequerytool:

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

- The server only allows read-only queries (SELECT, SHOW, etc.).
- To configure clients usingnpx @t1nker-1220/aws-postgres-mcp-server ..., the package must first be published to npm. The configuration would still use theenvobject for credentials.

Multi-database agent access (PostgreSQL, SQLite, MySQL, Oracle, SQL Server) with batch queries, pre-configured connections, and SQLGlot-enforced read-only safety

Run SQL queries on data in Amazon S3 using AWS Athena.

An MCP server for querying and interacting with AWS Athena.

A read-only MCP server for AlloyDB, enabling LLMs to query live data directly from AlloyDB databases.

Access and manage Amazon Redshift data using the CData MCP Server, which requires an external CData JDBC Driver.

A read-only MCP server by CData that enables LLMs to query live data from EnterpriseDB databases.

A server for direct interaction with CockroachDB databases.

Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite

A single-binary MCP server for MySQL, MariaDB, PostgreSQL, and SQLite

A Model Context Protocol (MCP) server that provides multi-database query execution capabilities with support for SQLite, PostgreSQL, and MySQL databases. Includes a built-in Web UI for managing database connections.