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