AWS PostgreSQL MCP Server
AWS PostgreSQL MCP 서버
query 도구를 통해 AWS PostgreSQL 데이터베이스에 대한 읽기 전용 SQL 쿼리 액세스를 제공하는 모델 컨텍스트 프로토콜(MCP) 서버입니다. 구성에는 환경 변수가 사용됩니다.
설정
복제:
지엑스피1
설치 및 빌드:
pnpm install pnpm run build
Related MCP server: tusk-mcp
구성(클라인/윈드서프용)
이 서버를 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 deployed
Maintenance
Related MCP Connectors
Hosted PostgreSQL MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Draxlr's remote MCP server connects AI assistants to your SQL databases and dashboards. Explore schemas, run read-only queries, manage saved queries and dashboards, and export results, all with row-level security so each user sees only their own data.
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
Related MCP Servers
- AlicenseDqualityDmaintenanceA secure Model Context Protocol server that allows Claude to execute read-only SQL queries against a PostgreSQL database, enabling natural language interaction with database data.1ISC
- AlicenseNot gradedqualityDmaintenanceA read-only PostgreSQL MCP server that enables AI agents to perform schema introspection and execute SELECT-only queries. It supports secure database connections through SSL and SSH tunnels while offering a structure-only mode to restrict query access.7 npmMIT
- AlicenseNot gradedqualityDmaintenanceRead-only PostgreSQL MCP server that enables running SELECT queries, listing tables and schemas, and describing columns, with built-in protection against writes and malicious SQL attacks.706 npmMIT
- FlicenseNot gradedqualityFmaintenanceA read-only MCP server that enables AI agents to explore database schemas and execute safe queries on PostgreSQL and MySQL.-