• Picks
  • Discover
  • Alternatives
  • About

© 2026 Willet

  • Newsletter
  • About
  • FAQ
  • Terms
  • Privacy & Cookies
Join the Discord (opens in a new tab)
Tiger Data avatar

pg-aiguide

PostgreSQL best-practice skills and doc search for AI coding agents

  • Agent skills and plugins
  • AI coding agents
View on GitHub

What it is

A set of agent skills plus an MCP server that gives coding agents version-aware semantic search over the PostgreSQL, TimescaleDB, and PostGIS manuals. The skills encode opinionated guidance on schema design, constraints, indexes, and newer Postgres features, and a separate skill helps explore an existing database. Developers who let Claude Code, Cursor, Codex, or similar agents write database code install it so the generated SQL follows current Postgres practice.

Images

Facts

Stars
1,872 GitHub stars.
1,872

Forks
135
Commits
163
Contributors
18
Language
Python
License
Apache-2.0
Last commit
Oct 7, 2026
On GitHub since
July 2025
First release
October 2025
Platforms
CLI
Self-hostable
No
Tags
  • agent-skills
  • mcp-server
  • semantic-search
  • agent-plugins
  • documentation
  • database

Last synced from GitHub on Oct 20, 2026

The 10 best overlooked open-source projects, every Monday.

Share and more

Comments

No comments yet. Start the conversation.

Similar projects

  • Amazon Web Services avatar

    Agent Toolkit for AWS

    AWS-maintained MCP server config, skills, and plugins for coding agents

    2.9k

What people are saying

Updated Oct 20, 2026
  • Hacker NewsShow HN: Pg-aiguide – Write better PostgreSQL code with AINov 24, 2025 · 3 points · 0 comments (opens Hacker News in a new tab)
  • Bluesky“A nice MCP for opinionated best (/recent) postgres practices for schema design, indexing and constraint Avoids the 35y history of old SQL practices LLMs have…”Dec 30, 2025 · 2 likes · 0 replies (opens Bluesky in a new tab)
  • Bluesky“Semantically searching all of PostgreSQL’s docs, then injecting that wisdom into AI code suggestions—pg-aiguide is pushing assistants closer to real-world…”Mar 21, 2026 · 0 likes · 0 replies (opens Bluesky in a new tab)
  • Bluesky“GitHub - timescale/pg-aiguide: MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.”Dec 31, 2025 · 0 likes · 0 replies (opens Bluesky in a new tab)
  • Bluesky“GitHub - timescale/pg-aiguide: MCP server and Claude plugin for Postgres skills and documentatio...”Dec 31, 2025 · 0 likes · 0 replies (opens Bluesky in a new tab)
  • Bluesky“timescale/pg-aiguide MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code. pg-aiguide…”Dec 31, 2025 · 0 likes · 0 replies (opens Bluesky in a new tab)