pg-aiguide

AI-optimized PostgreSQL expertise and skills for MCP servers

Provides PostgreSQL expertise optimized for AI coding tools. Supports better PostgreSQL code generation through semantic search of official PostgreSQL manuals, curated best practices, and extension documentation.

Author: timescale

Stars: 1,679

GitHub

Install: https://mcp.tigerdata.com/docs

Key Features

• Semantic search of PostgreSQL manuals
• AI-curated best practices and patterns
• Extension documentation including TimescaleDB
• Support for modern PostgreSQL code generation
• Constraint and index design recommendations

Use Cases

• AI-assisted coding — Enhance AI coding tools with PostgreSQL expertise to generate accurate, high-quality database code.
• Query optimization — Improve slow queries by suggesting indexes, constraints, and modern PostgreSQL patterns.
• Extension learning — Learn extension capabilities like TimescaleDB to enhance schema design with AI assistance.