mcp-psycopg2
MCP server exposing psycopg2 PostgreSQL database adapter functionality.
mcp-name: io.github.daedalus/mcp-psycopg2
接入你的智能体
發布者自己的指令。不是 PlugMCP 端點。
用我們的金鑰與日誌託管一份副本。
uvx mcp-psycopg2==0.1.0Claude Code 沒有本機指令的安裝連結。複製下方指令並在終端機中執行。
claude mcp add io.github.daedalus-mcp-psycopg2 -- uvx mcp-psycopg2==0.1.0在終端機中執行。
{ "mcpServers": { "io.github.daedalus-mcp-psycopg2": { "command": "uvx", "args": [ "mcp-psycopg2==0.1.0" ] } }}claude_desktop_config.json
遠端 URL 還是本機指令? 兩種安裝方式的差異
pip install mcp-psycopg2
from mcp_psycopg2 import mcp
# Run the MCP server
mcp.run()
The server exposes the following tools for interacting with PostgreSQL databases:
connect - Create a new database connectionclose_connection - Close an existing connectionget_connection_info - Get connection detailsbegin_transaction - Start a new transactioncommit_transaction - Commit the current transactionrollback_transaction - Rollback the current transactionset_isolation_level - Set transaction isolation levelcreate_cursor - Create a new cursorclose_cursor - Close a cursorexecute_query - Execute a SQL queryexecute_many - Execute a query with multiple parameter setsfetch_one - Fetch one rowfetch_many - Fetch multiple rowsfetch_all - Fetch all remaining rowsquote_identifier - Quote an SQL identifiermogrify - Return query string after parameter bindingregister_json - Register JSON type adapterregister_hstore - Register hstore type adapterregister_composite - Register composite type adaptercopy_from - Copy data from file to tablecopy_to - Copy data from table to filecopy_expert - Execute custom COPY statementcreate_named_cursor - Create a server-side named cursorscroll_cursor - Scroll through cursor resultscreate_large_object - Create or open a large objectread_large_object - Read from a large objectwrite_large_object - Write to a large objectget_server_version - Get PostgreSQL server versionget_backend_pid - Get backend process IDget_dsn_parameters - Get connection parametersget_notices - Get database noticesparse_dsn - Parse a connection stringmake_dsn - Create a connection stringcancel_query - Cancel the current database operationset_session - Set session parameterslist_connections - List all active connectionslist_cursors - List all active cursorsgit clone https://github.com/daedalus/mcp-psycopg2.git
cd mcp-psycopg2
pip install -e ".[test]"
# run tests
pytest
# format
ruff format src/ tests/
# lint
ruff check src/ tests/
# type check
mypy src/
MCP server exposing psycopg2 PostgreSQL database adapter functionality
{ "mcpServers": { "io.github.daedalus-mcp-psycopg2": { "command": "uvx", "args": [ "mcp-psycopg2==0.1.0" ] } }}工具
尚無工具清單。遠端伺服器會在首次健康檢查後取得工具清單。
常見問題
在本頁複製適用於 Cursor、Claude Desktop、Claude Code 或 VS Code 的 stdio 設定。它使用發布者的安裝方式,而不是 PlugMCP 代理伺服器。
這筆記錄未列出必要的環境變數。
MCP Psycopg2 透過 stdio 在本機執行。
上次檢查時間:2026-11-09。 MCP server exposing psycopg2 PostgreSQL database adapter functionality