aws-postgress-mcp-server
If you are the rightful owner of aws-postgress-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
AWS PostgreSQL MCP Server provides read-only SQL query access to an AWS PostgreSQL database using the `query` tool.
The AWS PostgreSQL MCP Server is designed to facilitate read-only access to an AWS-hosted PostgreSQL database. It leverages the Model Context Protocol (MCP) to enable clients to execute SQL queries securely and efficiently. The server is configured using environment variables, ensuring that sensitive information such as database credentials is not hardcoded into the application. This server is particularly useful for applications that require access to database information without the need for write operations, thus maintaining data integrity and security. The server is integrated into MCP clients by adding it to the client's settings file, allowing for seamless interaction with the database through the `query` tool.
Features
- Read-only SQL query access to AWS PostgreSQL databases.
- Environment variable-based configuration for enhanced security.
- Integration with MCP clients for seamless database interaction.
- Supports standard SQL queries like SELECT and SHOW.
- Transport type is set to stdio for efficient communication.
Tools
query
Tool for executing read-only SQL queries on the PostgreSQL database.