pg-aiguide

Grade A: derived only from the two verdicts below. How grades work

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

ActiveCurrent depsChecked Oct 19, 2026Free

Visit pg-aiguide ↗Source on GitHub ↗

Why this verdict

How we check →

25 commits by 9 contributors in the last 90 days (10 in the last 30). receipt ↗
Latest release v0.6.1, 44 days ago. receipt ↗
On current major: Vercel AI SDK, Zod. receipt ↗

Snapshot: commit 187be00 on main, checked 2026-10-19 06:19 UTC. Receipts link to files at this exact commit.

Dependency freshness

Package	Declared	Latest	Status
TypeScript typescript	7.0.2	7.0.2	Current
Vercel AI SDK ai	7.0.93	7.0.143	Current
Zod zod	4.5.4	4.6.7	Current

Declared = lowest version the kit's dependency file (package.json, pyproject.toml or requirements.txt) allows. Latest = the npm "latest" tag or the newest PyPI release. TypeScript, the Stripe SDK, FastAPI and other 0.x packages are shown but not counted in the verdict.

What's in the stack

Database / ORM: node-postgres
AI: Vercel AI SDK

Detected from declared dependencies. A listed package means it's installed, not necessarily fully wired up.

What the README says you get

AI
Semantic doc searchSemantic search across the official PostgreSQL manual (version-aware)
AI
Agent Skills supportAgent Skills via npx skills
AI
Claude Code plugina Claude Code plugin optimized for use with Claude's native skill support
AI
Best-practice skills viewerExposes curated, opinionated PostgreSQL best-practice skills used automatically by AI coding assistants
API
Public MCP servera public MCP server that can be used with any AI coding agent
API
Unified search toolUnified search tool supporting semantic (vector similarity) and keyword (BM25) search
Data
Extension ecosystem docsExtension ecosystem docs, starting with TimescaleDB
Data
Schema exploration skillinstall the schema exploration skill to investigate an existing PostgreSQL database
Data
PostgreSQL manual searchOfficial PostgreSQL manual, scoped by version
Data
Tiger Data docsTiger Data's documentation (TimescaleDB and ecosystem)
Data
PostGIS docsPostGIS spatial extension documentation
Data
Schema design guidanceSchema design
Data
Indexing strategies guidanceIndexing strategies

Extracted from the kit's README by a local AI model (deepseek-flash) on Sep 29, 2026. Every item is checked against an exact README quote; 1 unverifiable item was discarded. A README claim is the maker's description, not something we tested.

Watch pg-aiguide

Get told if it goes dormant, gets archived, falls further behind on a core dependency, or changes its license or price.

RSS feed for pg-aiguide · all changes

History

Sep 29, 2026 → Oct 19, 2026. One square per check, colored by maintenance status. Hover for details.

Show as a table

Date	Maintenance	Dependencies	Commits (90d)
Oct 19, 2026	Active	Current deps	25
Oct 12, 2026	Active	Current deps	25
Sep 29, 2026	Active	Current deps	24

Sources

Every claim on this page comes from these public records, checked Oct 19, 2026. Open them to verify.

Commit history ↗ default branch (main) at the checked commit: pulse, contributors, last commit
Releases ↗ latest release
package.json ↗ declared dependency versions and stack (at commit 187be00)
README ↗ quoted features at the checked commit
npm registry ↗ latest versions (each linked in the table above)

Maintainer? Add the badge

It updates automatically every time we refresh the evidence. Clicking it opens this page.

[![kitproof](https://kitproof.dev/badge/pg-aiguide.svg)](https://kitproof.dev/kits/pg-aiguide/)