Skip to content

Changelog

Jump to bottom
Temp edited this page Dec 6, 2025 · 4 revisions

Changelog

All notable changes to the PostgreSQL MCP Server project are documented here.

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

[1.1.1] - 2025-12-06

Status: Production/Stable
Docker Image: writenotenow/postgres-mcp-enhanced:v1.1.1
PyPI Package: postgres-mcp-enhanced v1.1.1

Changed

  • Enhanced stability and error handling across all 63 tools
  • Improved connection pool management for better reliability
  • Optimized resource operations to reduce memory footprint
  • Faster schema introspection for large databases
  • Better handling of edge cases in complex queries

Fixed

  • Fixed edge case in connection pool management under high load
  • Improved error messages for extension-related failures
  • Enhanced handling of very large result sets
  • Corrected resource caching behavior in certain scenarios
  • Fixed minor type annotations for improved IDE support

Security

  • Updated dependencies to latest secure versions
  • Enhanced input validation for edge cases
  • Maintained zero-vulnerability status
  • Updated starlette>=0.49.1 (CVE-2025-62727, CVE-2025-54121)
  • Updated urllib3>=2.5.0 (CVE-2025-50181, CVE-2025-50182)
  • Updated requests>=2.32.4 (CVE-2024-47081)
  • Updated aiohttp>=3.12.14 (CVE-2025-53643)

Documentation

  • Updated installation guides with clearer instructions
  • Expanded troubleshooting section with real-world solutions
  • Improved examples in wiki documentation

[1.1.0] - 2025-10-04

Status: Production/Stable - Major Release
Docker Image: writenotenow/postgres-mcp-enhanced:v1.1.0
PyPI Package: postgres-mcp-enhanced v1.1.0

Added - MCP Resources (10 New Features)

Real-time database meta-awareness that AI can access automatically:

  • database://schema - Instant access to all tables, columns, types, and indexes
  • database://capabilities - Available extensions, features, and pg_stat_statements status
  • database://performance - Top queries, cache hit rates, slow queries
  • database://health - Connection pool, indexes, vacuum status
  • database://extensions - pgvector, PostGIS, hypopg availability with versions
  • database://indexes - Usage statistics, size, recommendations
  • database://connections - Active connections, utilization, pool status
  • database://replication - Replication lag and health monitoring
  • database://vacuum - Bloat, last vacuum/analyze times, transaction ID status
  • database://locks - Active locks, blocking queries, deadlock detection
  • database://statistics - Table statistics quality and staleness

Added - MCP Prompts (10 New Features)

Guided workflows for complex operations:

  • optimize_query - Step-by-step query optimization workflow
  • index_tuning - Comprehensive index recommendations and analysis
  • database_health_check - Full health assessment workflow
  • setup_pgvector - Complete vector search setup guide
  • setup_postgis - Complete geospatial setup guide
  • json_operations - JSONB best practices and optimization guide
  • performance_baseline - Establish performance baselines
  • backup_strategy - Comprehensive backup planning
  • extension_setup - Step-by-step extension installation
  • explain_analyze_workflow - Deep dive query analysis

Changed

  • Intelligent Assistant: Transformed from tool collection to database expert with proactive optimization suggestions
  • Type Safety: Resolved 2,000+ type issues for 100% type-safe codebase
  • Code Quality: Achieved Pyright strict mode compliance
  • Zero Linter Errors: Clean codebase with comprehensive type checking
  • Enhanced Reliability: Improved error handling and edge case management

Technical Improvements

  • Implemented intelligent context-aware recommendations
  • Added PostgreSQL-specific best practices integration
  • Reduced token usage through cached context via resources
  • Enhanced maintainability through comprehensive type coverage

Compatibility

  • ✅ Zero Breaking Changes - All existing tools work unchanged
  • All 63 tools from v1.0.x remain fully functional
  • Backward compatible with all v1.0.x configurations

[1.0.0] - 2025-10-03

Status: Production/Stable - First Stable Release 🎉
Docker Image: writenotenow/postgres-mcp-enhanced:v1.0.0
PyPI Package: postgres-mcp-enhanced v1.0.0

Added

  • Production Ready: Enterprise-grade PostgreSQL MCP server
  • 63 Specialized Tools: Complete feature set across 9 categories
  • Multi-Platform Support: Windows, Linux, macOS (amd64, arm64)
  • Comprehensive Documentation: 16-page wiki with examples and guides

Security

  • ✅ Zero Known Vulnerabilities - Comprehensive security audit passed
  • ✅ SQL Injection Prevention - All queries use parameter binding
  • ✅ 20+ Security Tests - All attack vectors covered
  • ✅ CodeQL Scanning - Continuous security monitoring
  • ✅ Dual Security Modes - Restricted (production) and unrestricted (development)

Quality

  • ✅ Type Safety - Pyright strict mode compliance
  • ✅ Clean Codebase - Zero linter errors
  • ✅ Comprehensive Testing - 90%+ test coverage
  • ✅ PostgreSQL 13-18 - Full version compatibility

[Phase 5] - 2025-10-03

Pre-release Development Phase

Added - Backup & Recovery Suite (4 Tools)

  • backup_create_plan - Create comprehensive backup strategies
  • backup_validate_restore - Validate backup integrity
  • backup_analyze_schedule - Analyze and optimize backup schedules
  • backup_estimate_resources - Estimate backup resource requirements

Added - Monitoring & Alerting Suite (5 Tools)

  • monitor_database_health - Real-time health monitoring
  • monitor_query_performance - Query performance tracking
  • monitor_connection_pool - Connection pool monitoring
  • monitor_capacity_planning - Capacity forecasting
  • monitor_alert_thresholds - Configure alerting thresholds

Technical

  • All 63 tools operational and tested
  • Ruff formatting and linting passing
  • Integration tests passing

[Phase 4] - 2025-10-03

Pre-release Development Phase

Added - Vector/Semantic Search (8 Tools)

  • vector_store_embedding - Store vector embeddings with pgvector
  • vector_similarity_search - Semantic similarity search
  • vector_cosine_similarity - Calculate cosine similarity
  • vector_euclidean_distance - Calculate Euclidean distance
  • vector_inner_product - Calculate inner product
  • vector_dimension_reduce - Dimensionality reduction
  • vector_cluster_kmeans - K-means clustering
  • vector_index_create - Create vector indexes (IVFFlat, HNSW)

Added - Geospatial Operations (7 Tools)

  • geo_calculate_distance - Distance between coordinates
  • geo_within_radius - Points within radius search
  • geo_create_point - Create PostGIS point geometries
  • geo_create_polygon - Create PostGIS polygon geometries
  • geo_spatial_index - Create spatial indexes
  • geo_transform_coordinates - Coordinate system transformation
  • geo_spatial_join - Spatial relationship joins

Extension Support

  • pgvector v0.8.0 - Full vector operations support
  • PostGIS v3.5.0 - Complete geospatial capabilities
  • Graceful Degradation - Informative errors for missing extensions

[Phase 3] - 2025-10-03

Pre-release Development Phase

Added - Statistical Analysis (8 Tools)

  • stats_descriptive - Mean, median, mode, std dev, variance
  • stats_correlation - Pearson/Spearman correlation analysis
  • stats_regression_linear - Linear regression modeling
  • stats_time_series_analysis - Time series trend analysis
  • stats_percentiles - Calculate percentiles and quartiles
  • stats_distribution_analysis - Distribution shape analysis
  • stats_outlier_detection - Statistical outlier identification
  • stats_hypothesis_test - T-tests and chi-square tests

Added - Performance Intelligence (6 Tools)

  • performance_analyze_query - EXPLAIN ANALYZE with insights
  • performance_suggest_indexes - DTA algorithm-based recommendations
  • performance_analyze_workload - Workload pattern analysis
  • performance_test_hypothetical_index - HypoPG integration
  • performance_buffer_cache_analysis - Cache hit ratio analysis
  • performance_query_plan_comparison - Compare execution plans

Technical

  • Microsoft SQL Server-inspired DTA (Database Tuning Advisor) algorithm
  • HypoPG integration for zero-risk index testing
  • Real-time analytics via pg_stat_statements
  • 99%+ accuracy buffer cache monitoring

[Phase 2] - 2025-10-02

Pre-release Development Phase

Added - Text Processing (6 Tools)

  • text_similarity_trigram - Trigram-based similarity matching
  • text_search_full_text - PostgreSQL full-text search
  • text_fuzzy_match - Levenshtein distance matching
  • text_soundex - Soundex phonetic matching
  • text_metaphone - Metaphone phonetic algorithm
  • text_create_tsvector - Create full-text search vectors

Added - JSON Operations (15 Tools)

  • json_validate - JSONB schema validation
  • json_extract - Extract values from JSONB
  • json_query - Query JSONB with path expressions
  • json_update - Update JSONB values
  • json_merge - Deep merge JSONB objects
  • json_diff - Compare JSONB structures
  • json_array_operations - Array manipulation
  • json_keys - Extract all keys from JSONB
  • json_transform - Transform JSONB structure
  • json_security_scan - Scan for security issues
  • json_validate_email - Email validation in JSONB
  • json_validate_url - URL validation in JSONB
  • json_extract_nested - Deep nested value extraction
  • json_flatten - Flatten nested JSONB
  • json_schema_validate - JSON schema compliance

Technical

  • Comprehensive JSONB operation support
  • Advanced validation and security scanning
  • Performance-optimized queries

[Phase 1] - 2025-10-01

Pre-release Development Phase - Initial Release

Added - Core Database Tools (9 Tools)

  • list_tables - List all tables in database
  • describe_table - Get table schema details
  • execute_query - Execute SELECT queries safely
  • get_table_row_count - Get accurate row counts
  • list_indexes - List table indexes
  • list_foreign_keys - List foreign key relationships
  • check_database_health - Database health check
  • list_extensions - List installed PostgreSQL extensions
  • analyze_table_stats - Table statistics analysis

Security

  • SQL injection prevention via parameter binding
  • Input validation framework
  • Query sanitization
  • Restricted mode implementation

Infrastructure

  • Docker support with multi-platform builds (amd64, arm64)
  • PyPI package distribution
  • MCP protocol integration
  • Connection pooling with psycopg3
  • Comprehensive error handling

Testing

  • Unit test framework
  • Integration tests
  • Security test suite
  • CI/CD pipeline setup

Version History Summary

Version Release Date Type Highlights
1.1.1 2025-12-06 Maintenance Stability, performance, security updates
1.1.0 2025-10-04 Major Resources, Prompts, Intelligent Assistant
1.0.0 2025-10-03 Major Production release, 63 tools
Phase 5 2025-10-03 Dev Backup & Monitoring (9 tools)
Phase 4 2025-10-03 Dev Vector & Geospatial (15 tools)
Phase 3 2025-10-03 Dev Stats & Performance (14 tools)
Phase 2 2025-10-02 Dev Text & JSON (21 tools)
Phase 1 2025-10-01 Dev Core Database (9 tools)

Feature Categories

Complete Tool Set (63 Tools)

Category Count Status
Core Database 9 ✅ Stable
JSON Operations 15 ✅ Stable
Text Processing 6 ✅ Stable
Statistical Analysis 8 ✅ Stable
Performance Intelligence 6 ✅ Stable
Vector/Semantic Search 8 ✅ Stable
Geospatial Operations 7 ✅ Stable
Backup & Recovery 4 ✅ Stable
Monitoring & Alerting 5 ✅ Stable
Total 63 ✅ Production

MCP Resources (10 Resources)

Resource Added Status
database://schema v1.1.0 ✅ Stable
database://capabilities v1.1.0 ✅ Stable
database://performance v1.1.0 ✅ Stable
database://health v1.1.0 ✅ Stable
database://extensions v1.1.0 ✅ Stable
database://indexes v1.1.0 ✅ Stable
database://connections v1.1.0 ✅ Stable
database://replication v1.1.0 ✅ Stable
database://vacuum v1.1.0 ✅ Stable
database://locks v1.1.0 ✅ Stable
database://statistics v1.1.0 ✅ Stable

MCP Prompts (10 Prompts)

Prompt Added Status
optimize_query v1.1.0 ✅ Stable
index_tuning v1.1.0 ✅ Stable
database_health_check v1.1.0 ✅ Stable
setup_pgvector v1.1.0 ✅ Stable
setup_postgis v1.1.0 ✅ Stable
json_operations v1.1.0 ✅ Stable
performance_baseline v1.1.0 ✅ Stable
backup_strategy v1.1.0 ✅ Stable
extension_setup v1.1.0 ✅ Stable
explain_analyze_workflow v1.1.0 ✅ Stable

PostgreSQL Compatibility

PostgreSQL Version Support Status Notes
18 ✅ Full Support Latest version
17 ✅ Full Support
16 ✅ Full Support
15 ✅ Full Support
14 ✅ Full Support
13 ✅ Full Support Minimum version
12 and below ❌ Not Supported Please upgrade

Extension Support

Extension Required Version Features
pg_stat_statements Recommended Built-in Query performance tracking
pg_trgm Recommended Built-in Text similarity search
fuzzystrmatch Recommended Built-in Fuzzy string matching
hypopg Optional Latest Hypothetical index testing
pgvector Optional v0.8.0+ Vector similarity search
PostGIS Optional v3.5.0+ Geospatial operations

Platform Support

Platform Architecture Status Notes
Linux amd64 ✅ Full Support Primary platform
Linux arm64 ✅ Full Support
macOS amd64 ✅ Full Support Intel Macs
macOS arm64 ✅ Full Support Apple Silicon
Windows amd64 ✅ Full Support WSL2 recommended

Distribution Channels

Channel Status Link
Docker Hub ✅ Active writenotenow/postgres-mcp-enhanced
PyPI ✅ Active postgres-mcp-enhanced
MCP Registry ✅ Active Official Listing
GitHub Releases ✅ Active Releases

Migration Guides

Upgrading from v1.1.0 to v1.1.1

This is a drop-in replacement with no breaking changes:

  • Update Docker image tag to v1.1.1
  • Or run pip install --upgrade postgres-mcp-enhanced
  • No configuration changes required

Upgrading from v1.0.x to v1.1.x

All v1.0.x tools remain fully functional. You gain:

  • ✨ 10 new MCP Resources for database meta-awareness
  • ✨ 10 new MCP Prompts for guided workflows
  • ✨ Enhanced AI assistant capabilities
  • ✨ Improved performance and stability

No breaking changes - Upgrade with confidence!

Security Advisories

No Known Vulnerabilities

As of v1.1.1, there are zero known security vulnerabilities in the PostgreSQL MCP Server.

Security Updates

All security advisories and updates are documented in this section:

December 2025 (v1.1.1)

  • Updated starlette to address CVE-2025-62727 and CVE-2025-54121
  • Updated urllib3 to address CVE-2025-50181 and CVE-2025-50182
  • Updated aiohttp to address CVE-2025-53643
  • Updated requests to address CVE-2024-47081

Reporting Security Issues

Report security vulnerabilities to: admin@adamic.tech

Known Issues

Current (v1.1.1)

No known critical issues.

Resolved

  • ✅ [v1.1.1] Connection pool edge case under high load
  • ✅ [v1.1.1] Resource caching behavior in certain scenarios
  • ✅ [v1.1.0] Type annotation coverage (2,000+ issues resolved)

Deprecations

Currently, there are no deprecated features.

The PostgreSQL MCP Server maintains backward compatibility across all releases. All tools, resources, and prompts introduced in previous versions continue to be fully supported.

Community & Support

Getting Help

Contributing

Contributions are welcome! See our Contributing Guide.

Release Schedule

  • Maintenance releases (patch versions): As needed for bug fixes and security updates
  • Feature releases (minor versions): Quarterly, with new tools and capabilities
  • Major releases (major versions): Annually, with significant architectural changes

License

This project is licensed under the MIT License - see the LICENSE file for details.

Acknowledgments

Special thanks to:

  • The PostgreSQL community for the incredible database
  • The Model Context Protocol team for the MCP framework
  • All contributors and users who provided feedback and bug reports
  • The maintainers of pgvector, PostGIS, and HypoPG extensions

⭐ If you find this project useful, please star it on GitHub!

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

Clone this wiki locally