#136136th of 259 in Skills, plugins and prompts
pg-aiguide
Postgres skills and doc-search MCP server for AI coding agents
- Stars
- 1.9k
- License
- Apache-2.0
- Last commit
- Oct 2026
- Last release
- Sep 2026
- Language
- Python
1,641 on 31 Mar 20261,873 on 20 Oct 2026
From GitHub's daily star counts.
Checked on GitHub.
Overview
pg-aiguide gives coding agents PostgreSQL guidance on schema design, indexing, data types, constraints and naming. It also offers a hosted MCP server with semantic and BM25 search over the PostgreSQL, TimescaleDB and PostGIS docs. It installs as Agent Skills via `npx skills`, as an MCP endpoint, or as a Claude Code plugin.
Who it is for: Developers using AI coding agents to write PostgreSQL schemas and queries
Strengths
- Three install paths: npx skills, MCP URL, or Claude Code plugin
- Search is version-aware for the PostgreSQL manual and also covers TimescaleDB and PostGIS
- Hosted MCP endpoint means no local server is needed to start
- Config snippets for Cursor, Codex, Gemini CLI, VS Code, OpenCode and Windsurf
Weaknesses
- Docs search depends on a public endpoint hosted by TigerData
- pgvector docs are listed as coming soon
- Quality claims (4x constraints, 55% more indexes) come from a single demo prompt
- Skills are opinionated; the README does not say how to customize them
What it needs
- no GPU
- Docker + Compose
- Needs Node.js (for npx skills), TigerData-hosted MCP server (mcp.tigerdata.com/docs)
Also in Skills, plugins and prompts
See all 259| Rank | Project | Score |
|---|---|---|
| 1 | impeccableDesign skill with 24 slash commands for AI coding agents' frontend output | 96 out of 100 |
| 2 | cavemanCuts token use in coding agents with terse replies and compressed inputs | 95 out of 100 |
| 3 | skillsAgent skills for planning, TDD, debugging and code review | 94 out of 100 |
| #4 | eccAgents, skills, hooks and rules bundle for Claude Code, Codex and other harnesses | 94 out of 100 |
| #5 | oh-my-claudecodeMulti-agent orchestration plugin and CLI for Claude Code | 94 out of 100 |