
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.
概覽
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 等連線設定。
安裝
在 SourceWeft 中
- 開啟 儀表板中的 OwnPG,將其新增到工作區。
- 為需要使用其工具的對話啟用該服務。
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 installorcargo 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:
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版本歷史
1- v0.1.2最新Sep 24, 2026
評分
已滿足適用檢查項的 50%
該評分衡量此收錄條目的完整程度,依據註冊中心條目、端點與公開來源計算得出。它不是對伺服器本身的評價,也不表示伺服器安全或目前可用:可連通性是帶日期的檢查結果,評分也不包含安裝量或使用者評價。
- 近 30 天內可連通25 分
請保持端點能夠回應 MCP 握手;SourceWeft 每 30 天探測一次。
- 已宣告認證方式10 分
請在註冊中心條目中宣告憑證請求標頭,或保持端點能夠回應探測,以便判定其認證方式。
- 已列出工具15 分
請讓伺服器在無憑證時回應 tools/list,或發布可在沙箱中無憑證啟動的軟體包。
- 描述必需15 分
- 圖示10 分
- 文件15 分
- 授權條款10 分