Postgres

Created By
guoling2008a year ago
Overview

what is go-mcp-postgres?

go-mcp-postgres is a Model Context Protocol (MCP) server designed for interacting with Postgres databases, allowing for easy CRUD operations and automation without the need for a Node.js or Python environment.

how to use go-mcp-postgres?

To use go-mcp-postgres, you can either download the latest release and add it to your PATH or build it from source using Go. You can then run the server with command line arguments to connect to your Postgres database.

key features of go-mcp-postgres?

  • Zero burden, ready-to-use MCP server for Postgres.
  • Supports CRUD operations on Postgres databases and tables.
  • Read-only mode to prevent unintended write operations.
  • Ability to check query plans using the EXPLAIN statement before execution.

use cases of go-mcp-postgres?

  1. Automating database interactions without complex setups.
  2. Performing safe read-only operations on production databases.
  3. Quickly creating and managing Postgres tables and data.

FAQ from go-mcp-postgres?

  • Is go-mcp-postgres production-ready?

No, it is still a work in progress and may not be ready for production use.

  • What programming environments are required?

No Node.js or Python environment is needed; it runs independently.

  • Can I use it for read-only operations?

Yes, you can enable a read-only mode to restrict operations.

Server Config

{
  "mcpServers": {
    "postgres": {
      "command": "go-mcp-postgres",
      "args": [
        "--dsn",
        "postgresql://user:pass@host:port/db"
      ]
    }
  }
}
Project Info
Created At
a year ago
Updated At
a year ago
Author Name
guoling2008
Star
-
Language
-
License
-
Category
databases

Recommend Servers

View All
Tavily Mcp
@tavily-ai

JavaScript
a year ago
Orkestr

9 hours ago