mcp-postgres-full-access
8
The PostgreSQL Full Access MCP Server enables robust and secure read-write interactions with PostgreSQL databases via Model Context Protocol. It supports advanced transaction management and can be integrated with Claude Desktop for extended functionality.
PostgreSQL Full Access MCP Server
A server providing full read-write access to PostgreSQL databases via the Model Context Protocol. It allows Large Language Models to query and modify database content with transaction management and safety controls.
Features
- Full read-write access with DML operations and DDL management.
- Advanced safety controls, including SQL query classification and transaction monitoring.
Tools
- Execute queries and data modification operations.
- Maintenance commands execution like VACUUM.
- Manage transactions with explicit commit and rollback.
Using with Claude Desktop
- Integration steps with Claude Desktop.
- Approve SQL changes with "Allow once" for safety.
Security Considerations
- Best practices for database user permissions and safe operations.
License
Licensed under MIT License.
Comparison with Official PostgreSQL MCP Server
- This server provides write access, enhanced schema details, and more, compared to the official version.