go-mcp-postgres

go-mcp-postgres

3.3

If you are the rightful owner of go-mcp-postgres 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.

go-mcp-postgres is a Model Context Protocol server for interacting with Postgres databases, offering automation and CRUD operations.

go-mcp-postgres is a zero-burden, ready-to-use Model Context Protocol (MCP) server designed for seamless interaction with Postgres databases. It eliminates the need for Node.js or Python environments, providing a straightforward solution for database operations. The server supports CRUD operations and includes a read-only mode to prevent unintended write operations. Additionally, it offers a feature to check query plans using the `EXPLAIN` statement before executing queries, ensuring optimal performance. This project is a work in progress and may not be fully ready for production use. Users can install the server by downloading the latest release or building it from source if Go is installed. The server supports multiple languages and allows users to add custom language support. It provides various schema and data tools for database management, making it a versatile choice for developers working with Postgres.

Features

  • Zero-burden setup with no need for Node.js or Python environments.
  • Supports CRUD operations and a read-only mode for safe database interactions.
  • Query plan checking with `EXPLAIN` statement for optimized query execution.
  • Multi-language support with customizable language options.
  • Tools for schema and data management, including table creation, alteration, and query execution.