go-mcp-postgres

What it does

go-mcp-postgres provides a high-performance bridge between AI agents and PostgreSQL databases. Written in Go, it allows agents to perform database administration and data manipulation without requiring a Node.js or Python environment. It features a read-only mode for safety and an explain-check mechanism to validate query plans.

Tools

• list_database: List matching database names.
• list_table: List all or specific tables.
• create_table: Create new tables via SQL.
• alter_table: Modify existing table structures.
• desc_table: Describe the structure of a specific table.
• read_query: Execute read-only SQL queries.
• write_query: Execute data modification queries.
• update_query: Update existing records.
• delete_query: Remove records from tables.
• count_query: Quickly get the row count of a table.

Installation

{
  "mcpServers": {
    "postgres": {
      "command": "go-mcp-postgres",
      "args": [
        "--dsn",
        "postgresql://user:pass@host:port/db"
      ]
    }
  }
}

Supported hosts

• Claude Desktop