[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_136":137},"routes/modules.$creator.$moduleId",{"_14":15,"_16":17,"_18":19,"_20":21},"routes/modules.$creator.$moduleId.endpoints",{"_11":12,"_13":-5},"error","Module not found","tools","module",{"_20":22,"_23":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":34,"_35":26,"_36":37,"_38":-5,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_57":49,"_58":59,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":49,"_84":-5,"_85":86,"_87":88,"_89":90,"_91":92,"_93":94,"_95":96,"_97":98},"apiUrl","https://odel.app/api","creator","timescale","moduleId","pg-aiguide","@timescale/pg-aiguide","displayName","pg aiguide","tagline","Comprehensive PostgreSQL documentation and best practices, including ecosystem tools","iconKey","https://avatars.githubusercontent.com/u/8986001?v=4","category","remote","status","published","visibility","public","metaDescription","deploymentType","external","workerName","bindingName","mcpConfig","{\"url\":\"https://mcp.tigerdata.com/docs\",\"transport\":\"streamable-http\",\"authType\":\"none\"}","pricingModel","free","creatorUserId","system:external-import","createdAt",1783398859000,"updatedAt",1788583610000,"sourceRegistry","official-mcp-registry","sourceUrl","https://registry.modelcontextprotocol.io/v0/servers?search=io.github.timescale%2Fpg-aiguide","sourceVerified",true,"sourceMissingSince","importedAt","upstreamStars",1835,"upstreamUpdatedAt",1788550233000,"detectedTransport","streamable-http","detectedAuthType","none","probeStatus","ok","lastProbedAt",1787554882000,"githubRepoUrl","https://github.com/timescale/pg-aiguide","githubRepoFullName","timescale/pg-aiguide","releaseId","ext-timescale-pg-aiguide","version","0.6.1","descriptionMarkdown","# pg-aiguide\n\n**AI-optimized PostgreSQL expertise for coding assistants**\n\npg-aiguide helps AI coding tools write dramatically better PostgreSQL code. It provides:\n\n- **Semantic search** across the official PostgreSQL manual (version-aware)\n- **AI-optimized “skills”** — curated, opinionated Postgres best practices used automatically by AI agents\n- **Extension ecosystem docs**, starting with TimescaleDB, with more coming soon\n\nUse it as:\n\n- **Agent Skills** via `npx skills` — works with Claude Code, Cursor, Codex, Gemini CLI, and 40+ other agents\n- a **public MCP server** that can be used with any AI coding agent, or\n- a **Claude Code plugin** optimized for use with Claude's native skill support.\n\n## ⭐ Why pg-aiguide?\n\nAI coding tools often generate Postgres code that is:\n\n- outdated\n- missing constraints and indexes\n- unaware of modern PG features\n- inconsistent with real-world best practices\n\npg-aiguide fixes that by giving AI agents deep, versioned PostgreSQL knowledge and proven patterns.\n\n### See the difference\n\nhttps://github.com/user-attachments/assets/5a426381-09b5-4635-9050-f55422253a3d\n\n

Video Transcript

\n\nPrompt given to Claude Code:\n\n> Please describe the schema you would create for an e-commerce website two times, first with the tiger mcp server disabled, then with the tiger mcp server enabled. For each time, write the schema to its own file in the current working directory. Then compare the two files and let me know which approach generated the better schema, using both qualitative and quantitative reasons. For this example, only use standard Postgres.\n\nResult (summarized):\n\n- **4× more constraints**\n- **55% more indexes** (including partial/expression indexes)\n- **PG17-recommended patterns**\n- **Modern features** (`GENERATED ALWAYS AS IDENTITY`, `NULLS NOT DISTINCT`)\n- **Cleaner naming & documentation**\n\nConclusion: _pg-aiguide produces more robust, performant, maintainable schemas._\n\n

\n\n## 🚀 Quickstart\n\n### Agent Skills\n\nInstall curated PostgreSQL best-practice skills for your AI coding agent:\n\n```bash\nnpx skills add timescale/pg-aiguide --skill postgres\n```\n\nOr pick individual skills interactively:\n\n```bash\nnpx skills add timescale/pg-aiguide\n```\n\nWorks with Claude Code, Cursor, Codex, Gemini CLI, VS Code, and [40+ other agents](https://agentskills.io).\n\nFor even deeper PostgreSQL knowledge, also add the [MCP server](#mcp-server) to give your agent semantic search over the official PostgreSQL, TimescaleDB, and PostGIS manuals.\n\n### MCP Server\n\nFor semantic search over PostgreSQL, TimescaleDB, and PostGIS documentation, add the **public MCP server**:\n\n[https://mcp.tigerdata.com/docs](https://mcp.tigerdata.com/docs)\n\n

Manual MCP configuration using JSON

\n\n```json\n{\n \"mcpServers\": {\n \"pg-aiguide\": {\n \"url\": \"https://mcp.tigerdata.com/docs\"\n }\n }\n}\n```\n\n

\n\nOr it can be used as a **Claude Code Plugin**:\n\n```bash\nclaude plugin marketplace add timescale/pg-aiguide\nclaude plugin install pg@aiguide\n```\n\n#### Install by environment\n\n[![Install in Cursor](https://img.shields.io/badge/Install_in-Cursor-000000?style=flat-square&logoColor=white)](https://cursor.com/en/install-mcp?name=pg-aiguide&config=eyJuYW1lIjoicGctYWlndWlkZSIsInR5cGUiOiJodHRwIiwidXJsIjoiaHR0cHM6Ly9tY3AudGlnZXJkYXRhLmNvbS9kb2NzIn0=)\n[![Install in VS Code](https://img.shields.io/badge/Install_in-VS_Code-0098FF?style=flat-square&logo=visualstudiocode&logoColor=white)](https://vscode.dev/redirect/mcp/install?name=pg-aiguide&config=%7B%22type%22%3A%22http%22%2C%22url%22%3A%22https%3A%2F%2Fmcp.tigerdata.com%2Fdocs%22%7D)\n[![Install in VS Code Insiders](https://img.shields.io/badge/Install_in-VS_Code_Insiders-24bfa5?style=flat-square&logo=visualstudiocode&logoColor=white)](https://insiders.vscode.dev/redirect/mcp/install?name=pg-aiguide&config=%7B%22type%22%3A%22http%22%2C%22url%22%3A%22https%3A%2F%2Fmcp.tigerdata.com%2Fdocs%22%7D&quality=insiders)\n[![Install in Visual Studio](https://img.shields.io/badge/Install_in-Visual_Studio-C16FDE?style=flat-square&logo=visualstudio&logoColor=white)](https://vs-open.link/mcp-install?%7B%22type%22%3A%22http%22%2C%22url%22%3A%22https%3A%2F%2Fmcp.tigerdata.com%2Fdocs%22%7D)\n[![Install in Goose](https://block.github.io/goose/img/extension-install-dark.svg)](https://block.github.io/goose/extension?cmd=&arg=&id=pg-aiguide&name=pg-aiguide&description=MCP%20Server%20for%20pg-aiguide)\n[![Add MCP Server pg-aiguide to LM Studio](https://files.lmstudio.ai/deeplink/mcp-install-light.svg)](https://lmstudio.ai/install-mcp?name=pg-aiguide&config=eyJuYW1lIjoicGctYWlndWlkZSIsInR5cGUiOiJodHRwIiwidXJsIjoiaHR0cHM6Ly9tY3AudGlnZXJkYXRhLmNvbS9kb2NzIn0=)\n\n

Claude Code

\n\nThis repo serves as a claude code marketplace plugin. To install, run:\n\n```bash\nclaude plugin marketplace add timescale/pg-aiguide\nclaude plugin install pg@aiguide\n```\n\nThis plugin uses the skills available in the `skills` directory as well as our\npublicly available MCP server endpoint hosted by TigerData for searching PostgreSQL documentation.\n\n

\n\n

Codex

\n\nRun the following to add the MCP server to codex:\n\n```bash\ncodex mcp add --url \"https://mcp.tigerdata.com/docs\" pg-aiguide\n```\n\n

\n\n

Cursor

\n\nOne-click install:\n\n[![Install MCP Server](https://cursor.com/deeplink/mcp-install-dark.svg)](https://cursor.com/en-US/install-mcp?name=pg-aiguide&config=eyJ1cmwiOiJodHRwczovL21jcC50aWdlcmRhdGEuY29tL2RvY3MifQ%3D%3D)\n\nOr add the following to `.cursor/mcp.json`\n\n```json\n{\n \"mcpServers\": {\n \"pg-aiguide\": {\n \"url\": \"https://mcp.tigerdata.com/docs\"\n }\n }\n}\n```\n\n

\n\n

Gemini CLI

\n\nRun the following to add the MCP server to Gemini CLI:\n\n```bash\ngemini mcp add -s user pg-aiguide \"https://mcp.tigerdata.com/docs\" -t http\n```\n\n

\n\n

OpenCode

\n\nAdd the following to your global OpenCode config file (`~/.config/opencode/opencode.json`), or to a\nproject level `opencode.json`. See the [OpenCode config docs](https://opencode.ai/docs/config/) for\nmore about file locations, and the [MCP server docs](https://opencode.ai/docs/mcp-servers/) for more\nabout the `mcp` options.\n\n```json\n{\n \"$schema\": \"https://opencode.ai/config.json\",\n \"mcp\": {\n \"pg-aiguide\": {\n \"type\": \"remote\",\n \"url\": \"https://mcp.tigerdata.com/docs\"\n }\n }\n}\n```\n\nAdd `use pg-aiguide` to your prompts to use the pg-aiguide tools.\n\n

\n\n

Visual Studio

\n\nClick the button to install:\n\n[![Install in Visual Studio](https://img.shields.io/badge/Install_in-Visual_Studio-C16FDE?style=flat-square&logo=visualstudio&logoColor=white)](https://vs-open.link/mcp-install?%7B%22type%22%3A%22http%22%2C%22url%22%3A%22https%3A%2F%2Fmcp.tigerdata.com%2Fdocs%22%7D)\n\n

\n\n

VS Code

\n\nClick the button to install:\n\n[![Install in VS Code](https://img.shields.io/badge/Install_in-VS_Code-0098FF?style=flat-square&logo=visualstudiocode&logoColor=white)](https://vscode.dev/redirect/mcp/install?name=pg-aiguide&config=%7B%22type%22%3A%22http%22%2C%22url%22%3A%22https%3A%2F%2Fmcp.tigerdata.com%2Fdocs%22%7D)\n\nAlternatively, run the following to add the MCP server to VS Code:\n\n```bash\ncode --add-mcp '{\"name\":\"pg-aiguide\",\"type\":\"http\",\"url\":\"https://mcp.tigerdata.com/docs\"}'\n```\n\n

\n\n

VS Code Insiders

\n\nClick the button to install:\n\n[![Install in VS Code Insiders](https://img.shields.io/badge/Install_in-VS_Code_Insiders-24bfa5?style=flat-square&logo=visualstudiocode&logoColor=white)](https://insiders.vscode.dev/redirect/mcp/install?name=pg-aiguide&config=%7B%22type%22%3A%22http%22%2C%22url%22%3A%22https%3A%2F%2Fmcp.tigerdata.com%2Fdocs%22%7D&quality=insiders)\n\nAlternatively, run the following to add the MCP server to VS Code Insiders:\n\n```bash\ncode-insiders --add-mcp '{\"name\":\"pg-aiguide\",\"type\":\"http\",\"url\":\"https://mcp.tigerdata.com/docs\"}'\n```\n\n

\n\n

Windsurf

\n\nAdd the following to `~/.codeium/windsurf/mcp_config.json`\n\n```json\n{\n \"mcpServers\": {\n \"pg-aiguide\": {\n \"serverUrl\": \"https://mcp.tigerdata.com/docs\"\n }\n }\n}\n```\n\n

\n\n### 💡 Your First Prompt\n\nOnce installed, pg-aiguide can answer Postgres questions or design schemas.\n\n**Simple schema example prompt**\n\n> Create a Postgres table schema for storing usernames and unique email addresses.\n\n**Complex schema example prompt**\n\n> You are a senior software engineer. You are given a task to generate a Postgres schema for an IoT device company.\n> The devices collect environmental data on a factory floor. The data includes temperature, humidity, pressure, as\n> the main data points as well as other measurements that vary from device to device. Each device has a unique id\n> and a human-readable name. We want to record the time the data was collected as well. Analysis for recent data\n> includes finding outliers and anomalies based on measurements, as well as analyzing the data of particular devices for ad-hoc analysis. Historical data analysis includes analyzing the history of data for one device or getting statistics for all devices over long periods of time.\n\n## Features\n\n### Documentation Search (MCP Tools)\n\n- [**`search_docs`**](https://github.com/timescale/pg-aiguide/blob/main/API.md#search_docs)\n Unified search tool supporting semantic (vector similarity) and keyword (BM25) search across multiple documentation sources:\n - `postgres` - Official PostgreSQL manual, scoped by version\n - `tiger` - Tiger Data's documentation (TimescaleDB and ecosystem)\n - `postgis` - PostGIS spatial extension documentation\n\n### Skills (AI-Optimized Best Practices)\n\n- **[`view_skill`](https://github.com/timescale/pg-aiguide/blob/main/API.md#view_skill)** \n Exposes curated, opinionated PostgreSQL best-practice skills used automatically by AI coding assistants.\n\n These skills provide guidance on:\n - Schema design\n - Indexing strategies\n - Data types\n - Data integrity and constraints\n - Naming conventions\n - Performance tuning\n - Modern PostgreSQL features\n\n## 🔌 Ecosystem Documentation\n\nSupported today:\n\n- **TimescaleDB** (docs + skills)\n- **PostGIS** (docs)\n\nComing soon:\n\n- **pgvector**\n\nWe welcome contributions for additional extensions and tools.\n\n## 🛠 Development\n\nSee [DEVELOPMENT.md](https://github.com/timescale/pg-aiguide/blob/main/DEVELOPMENT.md) for:\n\n- running the MCP server locally\n- adding new skills\n- adding new docs\n\n## 🤝 Contributing\n\nWe welcome:\n\n- new Postgres best-practice skills\n- additional documentation corpora\n- search quality improvements\n- bug reports and feature ideas\n\n## 📄 License\n\nApache 2.0\n","changelogMarkdown","videoKey","requiredSecretsJson","publishedAt","priceCents","trialDays",0,"iconType","image","upstream",{"_114":115,"_116":117,"_118":119,"_120":121,"_122":-5,"_123":124},"requiredSecrets",[],"tags",[101,102,103,104,105,106,107,108,109,110,111,112,113],"assets",[],"stats",{"_99":86,"_100":86},"ratingAvg","reviewCount","ai","ai-agents","ai-coding","claude-code-plugin","claude-code-plugins","claude-code-plugins-marketplace","claude-marketplace","claude-plugin","claude-skills","docs","documentation","postgresql","skills","topics",[101,102,103,104,105,106,107,108,109,110,111,133,134,135,112,113],"license","Apache-2.0","language","Python","registryName","io.github.timescale/pg-aiguide","homepage","packages",[125,126],{"_127":131,"_129":132,"_76":77},{"_127":128,"_129":130,"_76":-5},"registryType","oci","identifier","ghcr.io/timescale/pg-aiguide:0.6.1","npm","@tigerdata/pg-aiguide","mcp","mcp-server","postgres","ENV",{"_138":139,"_140":141,"_142":143},"ENVIRONMENT","production","TURNSTILE_SITE_KEY","0x4AAAAAAB8-rEI2gNDf_QhU","SENTRY_DSN","https://45fd1229f78089d5c3ee78be128030e1@o4510583261757440.ingest.de.sentry.io/4510584253448272"]