# pg-aiguide

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

- **URL**: https://www.freshcrate.ai/projects/pg-aiguide
- **Author**: timescale
- **Category**: MCP Servers
- **Latest version**: `v0.5.0` (2026-04-23)
- **License**: Apache-2.0
- **Source**: https://github.com/timescale/pg-aiguide
- **Language**: Python
- **GitHub**: 1,696 stars, 84 forks
- **Registry**: github (`timescale/pg-aiguide`)
- **Tags**: `ai`, `ai-agents`, `ai-coding`, `claude-code-plugin`, `claude-code-plugins`, `claude-code-plugins-marketplace`, `claude-marketplace`, `claude-plugin`, `python`

## Description

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

## Recent releases

| Version | Date | Urgency | Changes |
| --- | --- | --- | --- |
| `v0.5.0` | 2026-04-23 | High | ## What's Changed * [AGE-430] Add PostGIS versioning (and combine source+version) by @gregsaab in https://github.com/timescale/pg-aiguide/pull/90 * Update secrets to ORG_AUTOMATION_TOKEN by @dsanroman96 in https://github.com/timescale/pg-aiguide/pull/91 * [CHORE] update lock file by @gregsaab in https://github.com/timescale/pg-aiguide/pull/92 * [CHORE] use non-prod instead of github's runners by @gregsaab in https://github.com/timescale/pg-aiguide/pull/93 * [CHORE] revert by @gregsaab in ht |
| `v0.4.0` | 2026-03-18 | Low | ## What's Changed * feat(postgis): add PostGIS documentation support by @cbc3929 in https://github.com/timescale/pg-aiguide/pull/59 * [AGE-383] Refactor Postgres/PostGIS import by @gregsaab in https://github.com/timescale/pg-aiguide/pull/83 * Add hint annotations to tools by @murrayju in https://github.com/timescale/pg-aiguide/pull/85  ## New Contributors * @cbc3929 made their first contribution in https://github.com/timescale/pg-aiguide/pull/59 * @gregsaab made their first contribution i |
| `v0.3.1` | 2026-02-23 | Low | ## What's Changed * Update skills descriptions to match Claude best practices by @antonum in https://github.com/timescale/pg-aiguide/pull/75 * fix: permission denied to create extension "pg_textsearch" by @wachawo in https://github.com/timescale/pg-aiguide/pull/78 * Add Cursor Marketplace plugin support by @murrayju in https://github.com/timescale/pg-aiguide/pull/79  ## New Contributors * @wachawo made their first contribution in https://github.com/timescale/pg-aiguide/pull/78  **Full Ch |
| `v0.3.0` | 2026-01-28 | Low | ## What's Changed * chore(deps): bump qs from 6.14.0 to 6.14.1 by @dependabot[bot] in https://github.com/timescale/pg-aiguide/pull/61 * use bun instead of node, biome as linter by @murrayju in https://github.com/timescale/pg-aiguide/pull/63 * import skills implementation from boilerplate lib by @murrayju in https://github.com/timescale/pg-aiguide/pull/66 * Refactor: Consolidate search tools and enable BM25 for Postgres docs by @murrayju in https://github.com/timescale/pg-aiguide/pull/68 * A |
| `v0.2.4` | 2025-12-10 | Low | **Full Changelog**: https://github.com/timescale/pg-aiguide/compare/v0.2.3...v0.2.4 |
| `v0.2.3` | 2025-12-09 | Low | ## What's Changed * MCP Registry publish by @murrayju in https://github.com/timescale/pg-aiguide/pull/55   **Full Changelog**: https://github.com/timescale/pg-aiguide/compare/v0.2.2...v0.2.3 |
| `v0.2.2` | 2025-12-09 | Low | ## What's Changed * add eslint config by @murrayju in https://github.com/timescale/pg-aiguide/pull/46 * docs: major README overhaul with clearer value proposition by @cevian in https://github.com/timescale/pg-aiguide/pull/47 * fix schema definitions for broader compatibillity by @murrayju in https://github.com/timescale/pg-aiguide/pull/48 * Don't recommend legacy geometry types by @Komzpa in https://github.com/timescale/pg-aiguide/pull/50 * fix to scrape tiger docs at new location by @murra |
| `v0.2.1` | 2025-11-17 | Low | **Full Changelog**: https://github.com/timescale/pg-aiguide/compare/v0.2.0...v0.2.1 |
| `v0.2.0` | 2025-11-17 | Low | ## What's Changed * Use name as title by @murrayju in https://github.com/timescale/pg-aiguide/pull/37 * chore: add Apache 2.0 license and notice by @jgpruitt in https://github.com/timescale/pg-aiguide/pull/40 * fix: change SELECT to CALL for add_columnstore_policy procedure by @cevian in https://github.com/timescale/pg-aiguide/pull/38 * feat: migrate to skills format and add Claude plugin support by @cevian in https://github.com/timescale/pg-aiguide/pull/43 * Prepare for repository rename t |
| `v0.1.3` | 2025-10-20 | Low | Release v0.1.3 |

## Citation

- HTML: https://www.freshcrate.ai/projects/pg-aiguide
- Markdown: https://www.freshcrate.ai/projects/pg-aiguide.md
- Dependencies JSON: https://www.freshcrate.ai/api/projects/pg-aiguide/deps

_Generated by freshcrate.ai. Indexes github releases for AI-agent ecosystem packages._