GarethCott_enhanced-postgres-mcp-server

GarethCott_enhanced-postgres-mcp-server

3.2

If you are the rightful owner of GarethCott_enhanced-postgres-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The PostgreSQL MCP Server (Enhanced) is a Model Context Protocol server that provides both read and write access to PostgreSQL databases, allowing for comprehensive database management.

The PostgreSQL MCP Server (Enhanced) is an advanced server designed to facilitate interaction with PostgreSQL databases through the Model Context Protocol. Unlike its predecessor, which only allowed read-only access, this enhanced version supports both read and write operations, as well as schema management. This server is particularly useful for applications that require dynamic database interactions, such as inspecting database schemas, executing queries, modifying data, and creating or altering database schema objects. It is equipped with a variety of tools that enable users to perform complex database operations efficiently and securely. The server ensures that all data modification operations are executed within transactions, providing robust error handling with COMMIT/ROLLBACK mechanisms. Additionally, it supports the creation of functions, triggers, and indexes, making it a versatile tool for database administrators and developers. The server is compatible with various platforms, including Docker and NPX, making it easy to integrate into existing workflows.

Features

  • Read and write access to PostgreSQL databases
  • Schema management capabilities
  • Transaction handling with COMMIT/ROLLBACK
  • Support for creating functions, triggers, and indexes
  • Compatibility with Docker and NPX for easy integration

Tools

  1. query

    Execute read-only SQL queries against the connected database

  2. execute

    Execute a SQL statement that modifies data (INSERT, UPDATE, DELETE)

  3. insert

    Insert a new record into a table

  4. update

    Update records in a table

  5. delete

    Delete records from a table

  6. createTable

    Create a new table with specified columns and constraints

  7. createFunction

    Create a PostgreSQL function/procedure

  8. createTrigger

    Create a trigger on a table

  9. createIndex

    Create an index on a table

  10. alterTable

    Alter a table structure