Postgres Ai Guide

Created By

timescale8 months ago

Overview

What is pg-aiguide?

pg-aiguide is an AI-optimized tool designed to enhance PostgreSQL coding by providing AI coding assistants with better knowledge and practices for writing PostgreSQL code.

How to use pg-aiguide?

You can use pg-aiguide as a public MCP server with any AI coding agent or as a Claude Code plugin. Installation instructions are provided for various environments including VS Code, Visual Studio, and more.

Key features of pg-aiguide?

Semantic search across the official PostgreSQL manual, tailored for specific versions.
AI-optimized skills that incorporate best practices for PostgreSQL.
Documentation for the TimescaleDB extension and more to come.

Use cases of pg-aiguide?

Assisting AI coding tools in generating accurate PostgreSQL schemas.
Providing best practices for schema design and indexing strategies.
Enhancing the quality of PostgreSQL code generated by AI agents.

FAQ from pg-aiguide?

Can pg-aiguide be used with any AI coding agent?

Yes! It can be utilized as a public MCP server or as a plugin for Claude Code.

What types of best practices does pg-aiguide provide?

It offers guidance on schema design, indexing strategies, data integrity, and modern PostgreSQL features.

Is pg-aiguide free to use?

Yes! pg-aiguide is available for free.

Try in Playground

Server Config

{
  "mcpServers": {
    "pg-aiguide": {
      "url": "https://mcp.tigerdata.com/docs"
    }
  }
}

Project Info

Created At

8 months ago

Updated At

8 months ago

Author Name

timescale

Star

Language

License

Recommend Servers

9 days ago

9 days ago

Bucket Feature Flags MCP Server

@bucketco

Flag features directly from chat in your code editor, including VS Code, Cursor, Windsurf, Claude Code—any IDE with MCP support.

a year ago

Jina AI MCP Tools

@PsychArch

A Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.

JavaScript

a year ago

Denmark Payments Mcp

@junter1989k-ai

9 days ago

Hong Kong Payments Mcp

@junter1989k-ai

9 days ago

Playwright Mcp

@microsoft

Playwright MCP server

TypeScript

a year ago

9 days ago

MCP server for ArcGIS Portal and ArcGIS Online. Lets AI assistants search content, query feature layers, manage features, handle content operations, and administer users and groups. Built on the Model Context Protocol for integration with Claude Desktop, Cursor, VS Code Copilot, and other MCP clients. Disclaimer: This is an independent open-source project. It is not affiliated with, endorsed by, or sponsored by Esri Inc. "ArcGIS" is a registered trademark of Esri.

9 days ago

9 days ago

Web content fetching and conversion for efficient LLM usage

9 months ago

Creationloop

@marino129

9 days ago

Redis

@modelcontextprotocol

A Model Context Protocol server that provides access to Redis databases. This server enables LLMs to interact with Redis key-value stores through a set of standardized tools.

a year ago

Aws Kb Retrieval Server

@modelcontextprotocol

An MCP server implementation for retrieving information from the AWS Knowledge Base using the Bedrock Agent Runtime.

a year ago

9 days ago

Zhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.

a year ago

mcp-server-flomo MCP Server

@chatmcp

Write notes to Flomo

JavaScript

a year ago

ShareMyPage

@Henning Witzel-Acikgöz

Host the HTML or Markdown pages your AI generates and share each as a link with comments, versioning, and access control. Create, update, and organize pages and read reviewer comments over MCP.

9 days ago

Puppeteer

@modelcontextprotocol

Browser automation and web scraping

a year ago

PostgreSQL

@modelcontextprotocol

Read-only database access with schema inspection

a year ago

Costa Rica Payments Mcp

9 days ago

9 days ago

Query verified 2026 US dental cost data from Real Dental Costs: average implant, veneer, braces and procedure prices for all 50 states and 206 cities, state-vs-state comparisons, and the composite US Dental Cost Index. Open data (CC BY 4.0, Zenodo DOIs). Every response includes the source and a reference URL. Pricing/market research, not medical advice. Data: https://realdentalcosts.com

9 days ago

MiniMax MCP

@MiniMax-AI

Official MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.

Python

a year ago

9 days ago

A Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.

a year ago

9 days ago

9 days ago

9 days ago

Persistent Adaptive Planning Intelligence - structured loop engineering for AI coding assistants, with memory that persists across sessions, tools, and teammates.

9 days ago