Pg Aiguide MCP Server

This server provides comprehensive PostgreSQL documentation, best practices, and specialized guidance for TimescaleDB and PostGIS. It serves as an expert knowledge base for database design, optimization, and implementation patterns.

Core Capabilities

Documentation Search: Find PostgreSQL, TimescaleDB, and PostGIS documentation using semantic or keyword search. Covers core database concepts, advanced features, and troubleshooting guidance.

Skills Retrieval: Access detailed operational skills and best practices specifically for TimescaleDB time-series database management, including hypertable optimization and time-series patterns.

Design Templates: Seven specialized prompt templates covering:

• PostgreSQL table design fundamentals
• PostGIS spatial table design with geometry types and coordinate systems
• TimescaleDB hypertable setup and configuration
• Database migration strategies from PostgreSQL to TimescaleDB
• pgvector semantic search implementation for AI/ML applications
• Hybrid text search combining BM25 and vector similarity
• Hypertable candidate analysis for existing databases

Domain Focus

Specializes in time-series data patterns, spatial data management, and modern PostgreSQL features including vector similarity search. Particularly strong in TimescaleDB migration strategies and PostGIS spatial optimization.

Usage Notes

Templates are triggered by specific database design scenarios (table creation, migration planning, search implementation). Use documentation search for general PostgreSQL questions and skills retrieval for TimescaleDB-specific operational guidance.