mcp-postgres-full-access
Enhanced PostgreSQL MCP server with full read-write access. 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.
What is this MCP
This is an enhanced Model Context Protocol server that provides full read-write access to PostgreSQL databases, unlike the official read-only version. It enables LLMs like Claude to safely execute queries, modify data, and manage database schema with proper transaction controls.
How to use this MCP
Configure it in Claude Desktop by editing the config file to include your PostgreSQL connection string. The server provides tools for executing queries (execute_query), modifying data (execute_dml_ddl_dcl_tcl), and managing transactions (execute_commit/rollback). All write operations require explicit user approval via Claude Desktop's 'Allow once' prompt.
What this MCP can be used for
This MCP enables AI-assisted database management including: data analysis with complex queries, database schema modifications, data entry/updates, and transaction management. It's particularly useful for developers and data professionals who want AI assistance with PostgreSQL administration while maintaining safety controls.
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.