Skip to content

v1.1.0 - Intelligent Database Assistant Release 🎉

Choose a tag to compare

View all tags
@neverinfamous neverinfamous released this 04 Oct 13:50
· 52 commits to main since this release
v1.1.0
70ba765

PostgreSQL MCP Server v1.1.0 - Intelligent Database Assistant Release 🎉

Release Date: October 4, 2025
Type: Major Feature Release
Breaking Changes: None ✅

🌟 Major Features

NEW: MCP Resources (10) - Database Meta-Awareness

Real-time database meta-awareness enables AI to understand your database without explicit queries:

Resource Purpose
database://schema Complete database structure with tables, columns, indexes
database://capabilities Server features and installed extensions
database://performance Query performance metrics from pg_stat_statements
database://health Comprehensive health status and monitoring
database://extensions Installed extension inventory with versions
database://indexes Index usage statistics and recommendations
database://connections Active connections and pool status
database://replication Replication status and lag monitoring
database://vacuum Vacuum status and transaction ID wraparound
database://locks Current lock information and contention

💡 Key Benefits:

  • AI can access database context automatically
  • Reduces token usage by providing cached meta-information
  • Enables proactive optimization suggestions
  • Context-aware recommendations based on actual database state

NEW: MCP Prompts (10) - Guided Workflows

Step-by-step workflows for complex PostgreSQL operations:

Prompt Purpose
optimize_query Complete query optimization workflow with EXPLAIN analysis
index_tuning Comprehensive index analysis, tuning, and recommendations
database_health_check Full health assessment with actionable insights
setup_pgvector Complete pgvector setup guide for semantic search
json_operations JSONB best practices and optimization strategies
performance_baseline Establish and monitor performance baselines
backup_strategy Design enterprise-grade backup and recovery strategy
setup_postgis PostGIS installation and geospatial operations guide
explain_analyze_workflow Deep dive into query execution plans
extension_setup Extension installation and configuration guide

💡 Key Benefits:

  • Guided multi-step workflows with PostgreSQL best practices
  • Interactive prompts with dynamic content
  • Production-ready examples and templates
  • Expert-level guidance for complex operations

🔒 Code Quality & Reliability

Type Safety - 2000+ Issues Fixed

  • ✅ Pyright strict mode compliance - Zero type errors across entire codebase
  • ✅ 100% type-safe - All functions, parameters, and return types properly typed
  • ✅ Enhanced IDE support - Better autocomplete, refactoring, and error detection
  • ✅ Improved maintainability - Self-documenting code with explicit types

Bug Fixes

  • JSON Serialization: Fixed datetime, IPv4Address, and Decimal object serialization errors
  • SQL Queries: Fixed column name issues in database://indexes and database://statistics resources
  • Text Search: Added automatic operator conversion (AND/OR/NOT → &/|/!) for text_search_advanced
  • Parameter Binding: Fixed SQL placeholder issues in vector_performance tool
  • Schema Logic: Fixed schema counting in database://schema resource

Code Quality - Ruff Compliance

  • ✅ 67 files formatted - Consistent code style across entire project
  • ✅ Zero linting errors - Clean codebase with best practices
  • ✅ Import organization - Properly sorted and structured imports
  • ✅ Whitespace cleanup - No trailing whitespace or formatting issues
  • ✅ Line length fixes - Proper line wrapping for readability

✅ Comprehensive Testing

100% Verification

  • ✅ All 63 tools tested and verified working
  • ✅ All 10 resources tested and verified working
  • ✅ All 10 prompts validated with real examples
  • ✅ Zero breaking changes - All existing functionality preserved
  • ✅ Security audit - Zero known vulnerabilities

Test Coverage

  • Core Database Tools (9/9) ✅
  • JSON Operations (11/11) ✅
  • Text Processing (5/5) ✅
  • Statistical Analysis (8/8) ✅
  • Performance Intelligence (6/6) ✅
  • Vector/Semantic Search (7/8) ✅ (1 not implemented by design)
  • Geospatial Operations (7/7) ✅
  • Backup & Recovery (4/4) ✅
  • Monitoring & Alerting (5/5) ✅

📦 What's Included

Tools (63)

Specialized MCP tools across 9 categories for database operations

Resources (10)

Real-time database meta-awareness for intelligent AI assistance

Prompts (10)

Guided workflows for complex PostgreSQL operations

Security

  • Zero known vulnerabilities
  • SQL injection prevention with parameter binding
  • Dual security modes (restricted/unrestricted)
  • CodeQL security scanning passing

Docker Images

Multi-platform support:

  • linux/amd64 - x86_64 architecture
  • linux/arm64 - ARM64 architecture (Apple Silicon, AWS Graviton)

Docker Hub: writenotenow/postgres-mcp-enhanced:v1.1.0

🚀 Quick Start

Docker (Recommended)

docker pull writenotenow/postgres-mcp-enhanced:v1.1.0

docker run -i --rm \
  -e DATABASE_URI="postgresql://user:pass@localhost:5432/db" \
  writenotenow/postgres-mcp-enhanced:v1.1.0 \
  --access-mode=restricted

Python Installation

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

📚 Documentation

🎯 Why This Release Matters

v1.1.0 transforms the PostgreSQL MCP Server from a tool collection into an intelligent database assistant:

  1. Proactive Intelligence - AI understands your database context automatically via Resources
  2. Guided Expertise - Step-by-step workflows via Prompts ensure best practices
  3. Production Quality - 2000+ type issues fixed, zero linting errors, comprehensive testing
  4. Zero Breaking Changes - All existing integrations work unchanged
  5. Enhanced Reliability - 100% type-safe codebase with Pyright strict mode

🔗 Links

📊 Full Changelog

Added

  • 10 MCP Resources for real-time database meta-awareness
  • 10 MCP Prompts for guided workflows
  • Automatic text search operator conversion (AND/OR/NOT)
  • Enhanced type hints across all modules
  • pyrightconfig.json for Pyright strict mode compliance

Fixed

  • JSON serialization errors (datetime, IPv4Address, Decimal)
  • SQL query column name issues in resources
  • Text search operator handling in text_search_advanced
  • SQL parameter binding in vector_performance
  • Schema counting logic in database://schema

Changed

  • Applied Ruff formatting to all 67 Python files
  • Organized imports across all modules
  • Updated to Pyright strict mode compliance
  • Enhanced error messages and logging

Quality

  • Fixed 2000+ Pyright type issues
  • Achieved zero Ruff linting errors
  • 100% test coverage for new features
  • Zero breaking changes

🎉 Thank you for using PostgreSQL MCP Server!

Enterprise-grade PostgreSQL operations with intelligent AI assistance.

Assets 2
Loading