OwnPG

PostgreSQL DBA tools over MCP, scoped to one database and one schema.

Databasesv0.1.2

OwnPG releases

Release artifacts, installers, and bug reports for OwnPG, the PostgreSQL DBA tool for AI clients over the Model Context Protocol. This repository is where every install path resolves and where problems are reported.

Status

OwnPG is in development. No version has been released yet. The first release appears on the Releases page of this repository when the maintainer declares the tool stable.

Prerequisites

  • A reachable PostgreSQL server, version 14 through 18.
  • Rust 1.89 or newer, only if you install with cargo install or cargo binstall.

Installing

Every path below resolves against the releases here.

  • From crates.io, building locally: cargo install ownpg --locked
  • A prebuilt binary through cargo: cargo binstall ownpg
  • The shell installer (macOS and Linux) and the PowerShell installer (Windows) are attached to every release.
  • Homebrew: brew install devops-infinity/tap/ownpg
  • npm: npm install -g @devops-infinity/ownpg

Eight prebuilt targets ship with every release: macOS on Apple Silicon and Intel, Linux with glibc and fully static with musl on x86_64 and aarch64, and Windows on x86_64 and ARM64.

Usage

Serve one database over stdio, read-only, with the default schema public:

ownpg serve -d app

Run ownpg doctor to check the connection before serving it live, and ownpg man for the full command reference.

Verifying a download

Every release carries sha256.sum with the checksum of every archive, and sha256.sum.minisig, a minisign signature over that file. The public key is published in this README at the first release. Verify with minisign -Vm sha256.sum -P <public key>, then sha256sum -c sha256.sum (or shasum -a 256 -c on macOS). Every archive also carries a CycloneDX SBOM and THIRD-PARTY.txt with the license of every dependency, and the binary embeds its dependency list for cargo audit bin.

Reporting a problem

Open an issue here with the template that fits: a bug, or a connection problem. Include the ownpg --version line and the ownpg doctor output with any password removed.

Security problems go through private vulnerability reporting on this repository, never through a public issue. See SECURITY.md.

Maintenance

OwnPG has one maintainer and one publisher. Outside code contributions are not accepted; bug reports are welcome. A successor will be named before the project is relied on by others.

License

The artifacts are licensed under either of the MIT license (LICENSE-MIT) or the Apache License, Version 2.0 (LICENSE-APACHE), at your option.

Setup from the maintainer

This listing does not have a supported local package template. Use the maintainer’s documentation for its hosted endpoint, authentication, and client-specific setup. No install command has been inferred.

Package

ownpgother

Compatible MCP Clients

OwnPG works with any MCP-compatible client. Copy the config snippet from the Configuration section above and add it to the file shown for your client, then restart the application.

  • Claude Desktop~/Library/Application Support/Claude/claude_desktop_config.jsonRestart Claude Desktop completely for changes to take effect.
  • Cursor~/.cursor/mcp.jsonRestart Cursor for changes to take effect.
  • VS Code.vscode/mcp.jsonReload VS Code window for changes to take effect.
  • Windsurf~/.codeium/windsurf/mcp_config.jsonRestart Windsurf for changes to take effect.
  • Claude Code.mcp.jsonSave at the project root, then start Claude Code in that project and review the MCP server approval prompt. Keep real credentials out of shared files.

Learn More