3.3.5

[call518]

Release v3.3.5 - First Official GitHub Release

Release Date: 2026-04-28
Tag: 3.3.5
PyPI: mcp-postgresql-ops

---

Overview

This is the first official GitHub Release for MCP-PostgreSQL-Ops, a professional MCP (Model Context Protocol) server for PostgreSQL database operations, monitoring, and management.

The project has evolved through 90 releases from 0.0.1 to 3.3.5, growing from a basic MCP scaffold into a production-ready PostgreSQL observability and operations platform.

---

Key Features

PostgreSQL Version Support

• Supports PostgreSQL 12 through 18 with automatic version detection
• Version-aware query execution with graceful degradation for older versions
• PostgreSQL 17+: wait event catalog, WAL summarizer monitoring
• PostgreSQL 18+: async I/O subsystem monitoring, per-backend I/O and WAL statistics
• PostgreSQL 16+: enhanced I/O statistics with byte-level columns

Monitoring and Diagnostics Tools

• Connection monitoring and session analysis
• Lock and deadlock detection
• Background process and checkpoint analysis
• Replication status and WAL monitoring
• Table and index I/O statistics
• Slow query identification via pg_stat_statements and pg_stat_monitor

Schema and Relationship Discovery

• get_table_schema_info: Column-level schema detail per table
• get_database_schema_info: Full database schema overview
• get_table_relationships: Foreign key and relationship mapping across tables

Autovacuum and Bloat Analysis

• get_autovacuum_status: Global autovacuum configuration and health
• get_autovacuum_activity: Real-time autovacuum worker activity
• get_table_bloat_analysis: Per-table bloat estimation
• get_database_bloat_overview: Database-wide bloat summary

Security and Authentication

• Bearer token authentication for streamable-http mode
• Gitleaks integration via pre-commit hook for secret scanning
• Read-only operation model — safe for production use
• RDS and Aurora compatible with regular user permissions

Deployment and Integration

• Docker-based quickstart with bundled PostgreSQL 17 (Percona image)
• docker-compose.custom-db.yml for connecting to an existing PostgreSQL instance
• mcp-mcpo server support for OpenAPI/Swagger access via OpenWebUI
• Smithery.ai deployment support
• PyPI package published on every tagged release via GitHub Actions

Developer Experience

• Python 3.12 runtime
• uv-based dependency management throughout
• Pre-commit hooks: Ruff (Python linting/formatting), Prettier (YAML/JSON), Gitleaks (secrets)
• Automated test suite with Docker lifecycle management and PostgreSQL readiness checks
• GitHub Actions CI: test matrix, PyPI publish, Docker image build and push

---

Changelog by Major Version

v0.0.x — Initial Setup

Project scaffold, Docker Compose with PostgreSQL 17, .env configuration, and basic MCP tool scaffolding.

v1.0.x — First Stable Toolset

Core monitoring tools added: WAL status, replication status, lock/deadlock monitoring. pg_stat_statements and pg_stat_monitor integration. Claude Desktop configuration examples.

v1.1.x — PostgreSQL 16 Support

Version-aware query paths for PostgreSQL 16 features. Healthcheck improvements in Docker Compose. Bug fixes for numeric rounding in tool outputs.

v1.2.x — Schema Discovery Tools

New tools: get_table_schema_info, get_database_schema_info, get_table_relationships. PostgreSQL version handling improvements.

v1.3.x — Bloat, Autovacuum, and PostgreSQL 12 Compatibility

New tools: get_table_bloat_analysis, get_database_bloat_overview, get_autovacuum_status, get_autovacuum_activity. Full compatibility down to PostgreSQL 12. docker-compose.custom-db.yml for external PostgreSQL connections.

v1.4.x — Environment and Port Improvements

Configurable internal/external port mapping. Environment variable loading improvements. Docker Compose dependency ordering.

v2.0.x — Authentication and HTTP Mode

Bearer token authentication for streamable-http mode. Docker healthcheck for MCP server container. Quickstart flow diagram added to README. host.docker.internal support enabled.

v3.0.x — Python 3.12 and Smithery.ai

Runtime upgraded from Python 3.11 to 3.12. Smithery.ai deployment integration. OpenWebUI Docker image version pinned for reproducibility.

v3.1.x — PostgreSQL 17/18 Support and Security Hardening

PostgreSQL 17 and 18 feature support (contributed via PR #30). Gitleaks pre-commit hook for secret scanning. Authentication argument handling improvements. CI workflow permissions restricted to read-only GITHUB_TOKEN. MCP server renamed to mcp-postgresql-ops.

v3.2.x — Test Infrastructure and Dependency Hygiene

Test suite refactored to use uv. Docker lifecycle management in tests with PostgreSQL readiness checks. Automated dependency updates via Dependabot (fastmcp, starlette, authlib, requests, cryptography, pytest, GitHub Actions).

v3.3.x — Dependency and Versioning Maintenance

pre-commit>=4.6.0 added as a declared dependency. Versioning strategy updated in pyproject.toml via setuptools-scm. Dependency bumps: python-dotenv 1.2.2, authlib 1.6.11, python-multipart 0.0.26.

---

Installation

Via PyPI

pip install mcp-postgresql-ops
# or
uv add mcp-postgresql-ops

Via Docker (Quickstart)

git clone https://github.com/call518/MCP-PostgreSQL-Ops.git
cd MCP-PostgreSQL-Ops
cp .env.example .env
docker compose up -d

---

Links

• PyPI: https://pypi.org/project/mcp-postgresql-ops/
• Docker Hub: https://hub.docker.com/r/call518/mcp-server-postgresql-ops
• DeepWiki (Architecture): https://deepwiki.com/call518/MCP-PostgreSQL-Ops
• Smithery.ai: https://smithery.ai/server/@call518/mcp-postgresql-ops

---

This discussion was created from the release 3.3.5.