OwnPG

io.github.devops-infinity由 GitHub 帳號 devops-infinity 發布v0.1.2更新於 Oct 27, 2026

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

已驗證STDIO僅桌面資料庫開發者工具

概覽

AI 產生的概覽

OwnPG 是透過 MCP 提供的本機 PostgreSQL DBA 工具,範圍限定單一資料庫與單一 schema,預設以唯讀方式經 stdio 提供服務。

可以做什麼
  • 透過 stdio 以唯讀方式連線單一 PostgreSQL 資料庫與 schema。
  • 以面向 DBA 的工具檢視與管理該資料庫(清單未列出個別工具)。
  • 正式上線前可用 doctor 指令檢查連線,並用 man 查看完整指令參考。
  • 為指定資料庫與預設 schema(例如 public)提供服務。
適用情境
當需要讓助手在桌面 AI 用戶端中檢視或協助管理某一個 PostgreSQL 資料庫(14 至 18 版),且預設維持唯讀存取時使用。請注意專案自述仍在開發中,尚未發布任何版本。
執行需求
需本機桌面安裝(僅 stdio,無網頁可執行版本),可透過 cargo、cargo binstall、shell 或 PowerShell 安裝程式、Homebrew 或 npm 安裝;僅 cargo 安裝需要 Rust 1.89 或更新版本。另需可連線的 PostgreSQL 伺服器(14 至 18 版),以及 OWNPG_HOST、OWNPG_PORT、OWNPG_USER 與密鑰 OWNPG_PASSWORD 等連線設定。
安裝前請注意
伺服器需要 PostgreSQL 角色密碼,存放於 OWNPG_PASSWORD;請勿寫入日誌或問題回報,README 要求提交 doctor 輸出時移除任何密碼。它會連線實際資料庫,應限定單一資料庫與 schema,並盡量使用預設唯讀模式。README 說明專案仍在開發中、尚無發布版本,且僅有一位維護者。

安裝

在 SourceWeft 中

  1. 開啟 儀表板中的 OwnPG,將其新增到工作區。
  2. 為需要使用其工具的對話啟用該服務。

Desktop only,透過 STDIO。 STDIO 服務會啟動本機處理程序,因此需要 SourceWeft 桌面主機。

其他 MCP 客戶端

參照 儲存庫 中的啟動說明。

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.

來源:README.md,提交 805cf7b

工具

0
SourceWeft 尚未在沙箱中啟動過該軟體包,因此其工具未知。

版本歷史

1
  1. v0.1.2最新Sep 24, 2026

評分

已滿足適用檢查項的 50%

該評分衡量此收錄條目的完整程度,依據註冊中心條目、端點與公開來源計算得出。它不是對伺服器本身的評價,也不表示伺服器安全或目前可用:可連通性是帶日期的檢查結果,評分也不包含安裝量或使用者評價。

  • 近 30 天內可連通25 分

    請保持端點能夠回應 MCP 握手;SourceWeft 每 30 天探測一次。

  • 已宣告認證方式10 分

    請在註冊中心條目中宣告憑證請求標頭,或保持端點能夠回應探測,以便判定其認證方式。

  • 已列出工具15 分

    請讓伺服器在無憑證時回應 tools/list,或發布可在沙箱中無憑證啟動的軟體包。

  • 描述必需15 分
  • 圖示10 分
  • 文件15 分
  • 授權條款10 分