# timescale/pg-aiguide

MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.

Repository: https://github.com/timescale/pg-aiguide
Canonical: https://ross.abutalabs.com/products/pg-aiguide
Language: Python
License: Apache-2.0
License Family: permissive
Topics: ai, ai-agents, ai-coding, claude-marketplace, claude-plugin, claude-skills, docs, documentation, mcp, mcp-server, postgres, postgresql, skills, claude-code-plugin, claude-code-plugins, claude-code-plugins-marketplace
Last push: 2026-06-26T19:47:09+00:00

## Health v2 (maintenance only)
Score: 74/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 89, release rhythm 81, longevity 29
- inputs: {"age_days": 406, "days_push": 68, "days_rel": 127, "gap_med": 22, "n_releases_24m": 10}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1824, forks 105 (observed 2026-08-28T04:05:41.151173+00:00)

## What it is
pg-aiguide is an MCP server and Claude plugin that gives AI coding tools versioned PostgreSQL expertise, including semantic search over the official PostgreSQL, TimescaleDB, and PostGIS manuals and curated best-practice skills. It helps AI agents generate more robust, modern PostgreSQL code with proper constraints, indexes, and current features.

## Use cases
- help claude code write better postgres schemas
- add postgres best-practice skills to cursor or codex
- semantic search over postgresql documentation from an ai agent
- stop ai tools generating outdated postgres code
- get timescaledb and postgis docs inside ai coding assistants
- install postgres skills via npx skills for 40+ agents

## When to choose
- you use AI coding agents and want them to follow modern PostgreSQL best practices
- you need version-aware semantic search over Postgres, TimescaleDB, or PostGIS manuals
- you use Claude Code and want a native plugin with curated skills

## When to avoid
- you need a general-purpose Postgres client or admin tool rather than AI guidance
- your project does not involve PostgreSQL or its extensions
- you need offline-only documentation without an MCP-capable agent

## Facets
- artifact type: service
- maturity: active
- function: mcp, documentation, search-engine, sdk
- domain: databases, developer-tools, artificial-intelligence, documentation
- platform: self-hosted, cli
- tags: postgresql, mcp-server, claude-plugin, agent-skills, timescaledb, ai-coding, semantic-search, ai-agents, web-server

## Member repositories
- timescale/pg-aiguide (main) score 74

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:41.151173+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T03:19:44.399889+00:00, confidence not recorded.
  - readme: https://github.com/timescale/pg-aiguide (fetched 2026-08-28T04:05:41.151173+00:00, sha 52bc623c2897)
- Data as of 2026-08-30T08:39:29.467469+00:00.