subnetmarco/pgmcp v0.3.0

on GitHub

PGMCP v0.3.0

PostgreSQL Model Context Protocol Server - Pre-compiled binaries for multiple platforms.

Quick Start

1. Download the appropriate binary for your platform below
2. Extract the archive
3. Set up your environment variables:

   export DATABASE_URL="postgres://user:password@localhost:5432/mydb"
   export OPENAI_API_KEY="your-api-key"  # Optional

4. Run the server: ./pgmcp-server
5. Test with the client: ./pgmcp-client -ask "What tables do I have?" -format table

Platform Support

• Linux: x86_64 and ARM64
• macOS: Intel and Apple Silicon (M1/M2/M3)
• Windows: x86_64 and ARM64

Changelog

Installation via Package Managers

# Homebrew (macOS/Linux)
brew tap subnetmarco/homebrew-tap
brew install pgmcp

# Linux packages
sudo apt install ./pgmcp_0.3.0_linux_amd64.deb  # Debian/Ubuntu
sudo rpm -i pgmcp_0.3.0_linux_amd64.rpm         # RedHat/CentOS

Docker

# Server
docker run -e DATABASE_URL=your_db_url -e OPENAI_API_KEY=your_key ghcr.io/subnetmarco/pgmcp:v0.3.0

Full Changelog: 0.2...v0.3.0