mcp-postgres-full-access
支持全读写访问的增强版PostgreSQL MCP服务器. mcp-postgres-full-access is a Model Context Protocol (MCP) server maintained by syahiidkamil. It connects to MCP-compatible clients such as Claude Desktop, Cursor, Cline, and other agents that speak the protocol. It exposes 6 tools, including execute_query, execute_dml_ddl_dcl_tcl, execute_commit, execute_rollback, list_tables and describe_table, that an agent can call directly. It is categorized under Database/PostgreSQL and Integration/Claude.
什么是这个MCP
这是一个增强版模型上下文协议服务器,与官方只读版本不同,它提供对PostgreSQL数据库的完整读写访问权限。该服务器允许像Claude这样的LLM在完善的事务控制机制下安全执行查询、修改数据和管理数据库模式。
如何使用这个MCP
在Claude Desktop中通过编辑配置文件添加您的PostgreSQL连接字符串进行配置。服务器提供执行查询(execute_query)、修改数据(execute_dml_ddl_dcl_tcl)和管理事务(execute_commit/rollback)的工具。所有写入操作都需要通过Claude Desktop的'允许一次'提示获得用户的明确批准。
这个MCP的用途
该MCP支持AI辅助的数据库管理功能,包括:使用复杂查询进行数据分析、数据库模式修改、数据录入/更新以及事务管理。对于希望在保持安全控制的同时获得PostgreSQL管理AI辅助的开发者和数据专业人员特别有用。
AIMCP authority
DR and traffic signal for the AIMCP public domain.
Frequently asked questions
What is the mcp-postgres-full-access MCP server?
mcp-postgres-full-access is a Model Context Protocol server from syahiidkamil. It lets MCP-compatible AI clients call its tools over a standard interface, so agents like Claude, Cursor, and Cline can use it without custom integration.
How do I connect mcp-postgres-full-access to my AI client?
Add mcp-postgres-full-access to your client's MCP configuration using the stdio or SSE connection shown in the usage examples on this page, then restart the client to load the server.
What tools does mcp-postgres-full-access provide?
mcp-postgres-full-access provides 6 tools: execute_query, execute_dml_ddl_dcl_tcl, execute_commit, execute_rollback, list_tables and describe_table.
Is mcp-postgres-full-access free to use?
mcp-postgres-full-access is listed on AIMCP for free. Any API keys or accounts required by the underlying service are set by its provider.
Vernclaw Plugins for OpenClaw
Ready-to-use connectors for SEO data, social reading & content generation. Pay-as-you-go credits with audit logs.
