Pg Aiguide

🚀 pg-aiguide

AI-optimized PostgreSQL expertise for coding assistants

pg-aiguide empowers AI coding tools to generate significantly better PostgreSQL code. It offers the following features:

• Semantic search: Conduct semantic searches across the official PostgreSQL manual, with version awareness.
• AI-optimized “skills”: These are curated, opinionated Postgres best practices that AI agents can automatically utilize.
• Extension ecosystem docs: Starting with TimescaleDB, more extensions will be supported soon.

You can use pg-aiguide in the following ways:

• As a public MCP server that can be integrated with any AI coding agent.
• As a Claude Code plugin optimized for use with Claude's native skill support.

✨ Features

Semantic Search (MCP Tools)

• 
  This function performs semantic searches over the official PostgreSQL manual, and the results are scoped to a specific Postgres version.

• It searches Tiger Data’s documentation corpus, which includes TimescaleDB and future ecosystem extensions.

Skills (AI-Optimized Best Practices)

• 
  This exposes curated, opinionated PostgreSQL best-practice skills that AI coding assistants can use automatically.

  These skills offer guidance on the following aspects:

  • Schema design
  • Indexing strategies
  • Data types
  • Data integrity and constraints
  • Naming conventions
  • Performance tuning
  • Modern PostgreSQL features

📦 Installation

pg-aiguide is available as a public MCP server:

https://mcp.tigerdata.com/docs

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

Install by environment

One-click installs

claude plugin marketplace add timescale/pg-aiguide
claude plugin install pg@aiguide

codex mcp add --url "https://mcp.tigerdata.com/docs" pg-aiguide

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

gemini mcp add -s user pg-aiguide "https://mcp.tigerdata.com/docs" -t http

code --add-mcp '{"name":"pg-aiguide","type":"http","url":"https://mcp.tigerdata.com/docs"}'

code-insiders --add-mcp '{"name":"pg-aiguide","type":"http","url":"https://mcp.tigerdata.com/docs"}'

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

💻 Usage Examples

Your First Prompt

Once installed, pg-aiguide can answer Postgres questions or design schemas.

Simple schema example prompt

Create a Postgres table schema for storing usernames and unique email addresses.

Complex schema example prompt

You are a senior software engineer. You are given a task to generate a Postgres schema for an IoT device company.
The devices collect environmental data on a factory floor. The data includes temperature, humidity, pressure, as
the main data points as well as other measurements that vary from device to device. Each device has a unique id
and a human-readable name. We want to record the time the data was collected as well. Analysis for recent data
includes finding outliers and anomalies based on measurements, as well as analyzing the data of particular devices for ad-hoc analysis. Historical data analysis includes analyzing the history of data for one device or getting statistics for all devices over long periods of time.

📚 Documentation

⭐ Why pg-aiguide?

AI coding tools often generate Postgres code with the following issues:

• Outdated
• Missing constraints and indexes
• Unaware of modern PG features
• Inconsistent with real-world best practices

pg-aiguide addresses these problems by providing AI agents with in-depth, versioned PostgreSQL knowledge and proven patterns.

See the difference

https://github.com/user-attachments/assets/5a426381-09b5-4635-9050-f55422253a3d

🔌 Ecosystem Documentation

Supported today:

• TimescaleDB (docs + skills)

Coming soon:

• pgvector
• PostGIS

We welcome contributions for additional extensions and tools.

🔧 Technical Details

See DEVELOPMENT.md for:

• running the MCP server locally
• adding new skills
• adding new docs

🤝 Contributing

We welcome:

• new Postgres best-practice skills
• additional documentation corpora
• search quality improvements
• bug reports and feature ideas

📄 License

This project is licensed under the Apache 2.0 license.