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 分