Simple PostgreSQL MCP Server
A minimal Model Context Protocol (MCP) server for executing SQL queries on PostgreSQL databases with configurable permissions.
Features
- Execute SQL queries with optional read-only or write access
接入你的智能体
從發布者安裝。不是 PlugMCP 端點。
遠端 URL 還是本機指令? 兩種安裝方式的差異
來自發布者
A minimal Model Context Protocol (MCP) server for executing SQL queries on PostgreSQL databases with configurable permissions.
Minimal MCP server for PostgreSQL. Easily execute SQL queries with configurable read-only or write access, simple setup, and structured results—ideal for integrating PostgreSQL with MCP-compatible tool
git clone https://github.com/perrypixel/Simple-Postgres-MCP
cd Simple-Postgres-MCP
npm install
npm run build
Add the following to your MCP client configuration (mcp.json):
{
"mcpServers": {
"simple-postgresql-mcp": {
"command": "node",
"args": [
"/path/to/build/index.js",
"postgresql://username:password@localhost:5432/database_name",
"write"
]
}
}
}
{
"mcpServers": {
"simple-postgresql-mcp": {
"command": "node",
"args": [
"/path/to/build/index.js",
"postgresql://username:password@localhost:5432/database_name",
"readonly"
]
}
}
}
Note: Update the path in the configuration to point to the
index.jsfile inside yourbuildfolder.
mcp.json (e.g., Cursor, Windsurf, Copilot, etc.).If you find this tool helpful, you can support the development by:
Minimal MCP server for PostgreSQL. Easily execute SQL queries with configurable read-only or write access, simple setup, and structured results—ideal for integrating PostgreSQL with MCP-compatible too
總覽
Minimal MCP server for PostgreSQL. Easily execute SQL queries with configurable read-only or write access, simple setup, and structured results—ideal for integrating PostgreSQL with MCP-compatible tool
工具
尚無工具清單。遠端伺服器會在首次健康檢查後取得工具清單。
常見問題
在本頁複製適用於 Cursor、Claude Desktop、Claude Code 或 VS Code 的 stdio 設定。它使用發布者的安裝方式,而不是 PlugMCP 代理伺服器。
這筆記錄未列出必要的環境變數。
Easy Postgres 透過 stdio 在本機執行。
上次檢查時間:2026-10-28。 Minimal MCP server for PostgreSQL. Easily execute SQL queries with configurable read-only or write access, simple setup, and structured results—ideal for integrating PostgreSQL with MCP-compatible tool