Skip to content

PostgreSQL MCP Server v1.0.5 [Enhanced]

Choose a tag to compare

View all tags
@neverinfamous neverinfamous released this 03 Oct 19:16
· 78 commits to main since this release
v1.0.5
cde5f84

🎉 PostgreSQL MCP Server v1.0.5 - Production Ready Release

Enterprise-grade PostgreSQL operations with comprehensive security, real-time analytics, and AI-native capabilities.

🚀 What's New in v1.0.0

This is the first production-ready release of PostgreSQL MCP Server, featuring:

✅ Complete Feature Set

  • 63 Specialized MCP Tools across 9 categories
  • All Phase 5 Features Implemented (Backup & Recovery + Monitoring & Alerting)
  • Production-Ready Enterprise Capabilities

🔒 Security Excellence

  • Zero Known Vulnerabilities - Comprehensive security audit passed
  • SQL Injection Prevention - Parameter binding with automatic sanitization
  • Dual Security Modes - Restricted (production) and unrestricted (development)
  • 20+ Security Test Cases - All passing with 100% protection

⚡ Performance & Intelligence

  • Real-Time Analytics - pg_stat_statements integration
  • Hypothetical Index Testing - HypoPG for zero-risk optimization
  • AI-Powered Query Optimization - DTA algorithm implementation
  • Buffer Cache Analysis - 99%+ accuracy monitoring

🧠 AI-Native Operations

  • Vector Similarity Search - pgvector integration (v0.8.0+)
  • Geospatial Operations - PostGIS integration (v3.5.0+)
  • Semantic Search & Clustering - Advanced ML capabilities
  • Natural Language Database Interface

🏢 Enterprise Ready

  • PostgreSQL 13-17 - Full version compatibility
  • Multi-Platform - Windows, Linux, macOS (amd64, arm64)
  • Type Safety - Pyright strict mode with LiteralString enforcement
  • CI/CD Ready - Automated testing and security validation

📊 Tool Categories (63 Tools)

Category Tools Key Features
Core Database 9 Schema management, SQL execution, health monitoring
JSON Operations 11 JSONB operations, validation, security scanning
Text Processing 5 Similarity search, full-text search, fuzzy matching
Statistical Analysis 8 Descriptive stats, correlation, regression, time series
Performance Intelligence 6 Query optimization, index tuning, workload analysis
Vector/Semantic Search 8 Embeddings, similarity search, clustering
Geospatial Operations 7 Distance calculation, spatial queries, GIS
Backup & Recovery 4 Backup planning, restore validation, scheduling
Monitoring & Alerting 5 Real-time monitoring, capacity planning, alerting

📚 Documentation

Visit the Complete Wiki →

Quick links:

🚀 Quick Start

Docker (Recommended)

docker pull neverinfamous/postgres-mcp:latest

docker run -i --rm \
  -e DATABASE_URI="postgresql://user:pass@localhost:5432/db" \
  neverinfamous/postgres-mcp:latest \
  --access-mode=restricted

Python Installation

pip install postgres-mcp
postgres-mcp --access-mode=restricted

From Source

git clone https://github.com/neverinfamous/postgres-mcp.git
cd postgres-mcp
uv sync
uv run pytest -v

🔧 Configuration

Claude Desktop

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "docker",
      "args": ["run", "-i", "--rm", "-e", "DATABASE_URI", 
               "neverinfamous/postgres-mcp:latest", "--access-mode=restricted"],
      "env": {
        "DATABASE_URI": "postgresql://user:pass@localhost:5432/db"
      }
    }
  }
}

Cursor IDE

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "postgres-mcp",
      "args": ["--access-mode=restricted"],
      "env": {
        "DATABASE_URI": "postgresql://user:pass@localhost:5432/db"
      }
    }
  }
}

📈 Project Stats

  • Version 1.0.0 - Production ready release
  • 63 MCP Tools across 9 categories
  • 6,900+ lines of implementation code
  • 12 modules with specialized functionality
  • Phase 5 Complete - All enterprise features implemented
  • 100% Type Safe - Pyright strict mode compliance
  • Zero Vulnerabilities - Comprehensive security audit passed
  • PostgreSQL 13-17 - Full compatibility
  • Multi-platform - Windows, Linux, macOS (amd64, arm64)

🏆 Why Choose This Server?

  • ✅ Zero Known Vulnerabilities - Comprehensive security audit passed
  • ✅ Enterprise-Grade - Production-ready with advanced features
  • ✅ 63 Specialized Tools - Complete database operation coverage
  • ✅ Real-Time Analytics - pg_stat_statements integration
  • ✅ AI-Native - Vector search, semantic operations, ML-ready
  • ✅ Active Maintenance - Regular updates and security patches
  • ✅ Comprehensive Documentation - 16-page wiki with examples

🔗 Links

📄 License

MIT License - See LICENSE file

🙏 Acknowledgments

This release represents the culmination of comprehensive development across 5 phases, with a focus on security, performance, and enterprise-grade capabilities.

Report Security Issues: admin@adamic.tech

Enterprise-grade PostgreSQL MCP server with comprehensive security, real-time analytics, and AI-native operations.

Assets 2
Loading