OwnPG
Provides PostgreSQL database administration capabilities for AI clients, allowing a read-only connection to a single database over stdio, connection checks via doctor, and command reference for managing PostgreSQL instances.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@OwnPGRun doctor to diagnose the PostgreSQL connection."
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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.
Related MCP server: Postgres MCP Server
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 --lockedA prebuilt binary through cargo:
cargo binstall ownpgThe shell installer (macOS and Linux) and the PowerShell installer (Windows) are attached to every release.
Homebrew:
brew install devops-infinity/tap/ownpgnpm:
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 appRun 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.
This server cannot be deployed
Maintenance
Related MCP Connectors
- dataOAuthco.thinair
PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.
Analytical memory for AI agents: a real Postgres queried in plain English over MCP. One command.
Hosted MCP server for PostgreSQL diagnostics: slow queries, missing indexes, connection pressure.
Related MCP Servers
- AlicenseAqualityCmaintenanceEnables secure querying of PostgreSQL databases through MCP-compatible clients. Supports read-only SQL execution, table exploration, and connection management with built-in security validation.330 npm9MIT
- FlicenseNot gradedqualityDmaintenanceEnables interaction with PostgreSQL databases through MCP, allowing users to explore database structures, inspect table schemas, and execute read-only SQL queries.-
- -licenseNot gradedqualityNot gradedmaintenanceEnables users to perform SQL query execution, schema exploration, and performance analysis on PostgreSQL databases through any MCP-compatible client. It prioritizes security with read-only protection by default and provides guided workflows for database documentation and optimization.-
- AlicenseNot gradedqualityDmaintenanceEnables inspecting database schemas and executing read-only SQL queries on a PostgreSQL database via MCP tools.8 npmMIT