OwnPG

io.github.devops-infinityPublished by GitHub account devops-infinityv0.1.2Updated Oct 27, 2026

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

VerifiedSTDIODesktop onlyDatabasesDeveloper Tools

Overview

AI-generated overview

OwnPG is a local PostgreSQL DBA tool exposed over MCP, scoped to one database and one schema, served read-only over stdio.

What you can do
  • Connect to a single PostgreSQL database and schema over stdio, read-only by default.
  • Inspect and administer that database through DBA-oriented tools (no individual tools are listed in the manifest).
  • Check connectivity before going live with the doctor command and read the full command reference with man.
  • Serve a chosen database and default schema, for example the public schema.
When to use it
When an assistant should inspect or help administer one PostgreSQL database (versions 14 through 18) from a desktop AI client, with read-only access by default. Note the project states it is in development and no version has been released yet.
Requirements
A local desktop install (stdio only, no web executable) via cargo, cargo binstall, shell or PowerShell installer, Homebrew, or npm; Rust 1.89 or newer only for cargo installs. A reachable PostgreSQL server, version 14 through 18, plus connection settings in OWNPG_HOST, OWNPG_PORT, OWNPG_USER and the secret OWNPG_PASSWORD.
Before you install
The server needs a PostgreSQL role password in OWNPG_PASSWORD; keep it out of logs and issue reports, as the README asks for doctor output with any password removed. It connects to a live database, so scope it to a single database and schema and prefer the read-only default. The README says the project is in development with no release yet and has a single maintainer.

Installation

In SourceWeft

  1. Open OwnPG in the dashboard and add it to a workspace.
  2. Enable the server for the chats that should use its tools.

Desktop only via STDIO. STDIO servers start a local process, so they need the SourceWeft desktop host.

Other MCP clients

Follow the launch instructions in the repository.

README

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.

Source: README.md at commit 805cf7b

Tools

0
SourceWeft has not started this package in its sandbox yet, so its tools are not known.

Version history

1
  1. v0.1.2LatestSep 24, 2026

Score

50% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

  • Reached in the last 30 days25 pts

    Keep the endpoint answering the MCP handshake; SourceWeft probes it every 30 days.

  • Auth declared10 pts

    Declare the credential headers in the registry entry, or keep the endpoint answering the probe so its auth can be classified.

  • Tools listed15 pts

    Answer tools/list without a credential, or ship a package that starts in a sandbox without one.

  • DescriptionRequired15 pts
  • Logo10 pts
  • Documentation15 pts
  • License10 pts