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.