pg-aiguide
pg-aiguide aims to make AI coding tools write better PostgreSQL. The README says assistants often produce outdated SQL, miss constraints and indexes and ignore modern Postgres features, and offers three things: semantic search over the official PostgreSQL manual that is scoped to a version, curated and opinionated best-practice skills, and documentation for extensions, starting with TimescaleDB (pgvector and PostGIS are listed as coming soon). The skills cover schema design, indexing, data types, constraints, naming conventions, performance tuning and modern features.
It can be used as a public MCP server at `https://mcp.tigerdata.com/docs`, which any MCP client can add with a URL, or as a Claude Code plugin with `claude plugin marketplace add timescale/pg-aiguide` and `claude plugin install pg@aiguide`. One-click installs are listed for Cursor, VS Code, Goose and LM Studio. The tools are `semantic_search_postgres_docs`, `semantic_search_tiger_docs` and `view_skill`. The README includes a before-and-after demo of an e-commerce schema generated with and without the server, which is the project's own example. It is Apache 2.0 licensed.
Features
Why choose it
Trade-offs
Maintenance check
- Last commit
- 2026-11-06
- Commits, last 90 days
- 38
- Releases, last 90 days
- 2
- Latest release
- v0.6.1 (2026-09-04)
- Open issues
- 15
- Recent issues with at least one comment
- 0/6
Oldest week on the left; the latest four weeks are orange. Source: GitHub commit activity.
Status rule: archived on GitHub = Archived; last commit within 90 days = Active; 91 to 365 days = Slowing; older = Stale. All figures come from the GitHub API on the date shown.
Most discussed open issues
- #184 Dependency Dashboard0 comments · 2026-11-06
- #175 search_docs REST endpoint rejects semanticWeight from the query string0 comments · 2026-10-25
- #174 Documentation and example corrections in timescale/pg-aiguide0 comments · 2026-10-24
- #128 Make Type-Conversion Validation Exact and NULL-Safe0 comments · 2026-07-19
- #127 Prevent Resumable Backfills From Stopping at Sparse or Prefilled IDs0 comments · 2026-07-19
Issue titles are quoted from GitHub. Open the link to check whether a problem still applies to the version you use.
Who it fits
- You want your coding assistant to write better PostgreSQL: version-aware search over the official manual plus best-practice skills for schema, indexing and constraints.
- You use TimescaleDB and want its docs available to the assistant.
- You want to connect with a URL (mcp.tigerdata.com/docs) or install as a Claude Code plugin.
- You want an assistant to query your own database: this serves documentation and skills, not database access.
- You do not want queries sent to a hosted service; the default setup uses a public hosted MCP server.
- You need extension docs beyond TimescaleDB today; pgvector and PostGIS are listed as coming soon.
How it differs
They solve different problems and can be used together. DBHub gives an agent access to live databases; pg-aiguide gives it Postgres knowledge so the SQL it writes is better.
Compatibility
Quick start
Use cases
Alternatives
Featured in these lists
Comments
No comments yet. Be the first!