search_docsLABSCO SUMMARY
Postgres advice an agent can look up instead of remembering.
Two things are on offer and they solve different halves of the problem: search grounds an answer in the manual for the version you are actually on, and the skills carry the opinions a manual does not — which constraints and indexes belong on a table before it ships.
What it is
A hosted MCP server run by TigerData with semantic and keyword search over official database documentation, paired with a set of opinionated PostgreSQL skills an agent can pull in while it writes schema.
What you get
search_docs— one search tool across three corpora, supporting both semantic vector similarity and BM25 keyword search:postgresfor the official PostgreSQL manual scoped by version,tigerfor TimescaleDB and its ecosystem, andpostgisfor the spatial extensionview_skill— curated PostgreSQL best-practice skills covering schema design, indexing strategies, data types, data integrity and constraints, naming conventions, performance tuning and modern PostgreSQL features
Requirements
Nothing to install for the search half: point your client at the public endpoint https://mcp.tigerdata.com/docs over HTTP. The skills install separately with npx skills add timescale/pg-aiguide --skill postgres, which works with Claude Code, Cursor, Codex, Gemini CLI and VS Code. Claude Code users can instead take both at once through the plugin marketplace: claude plugin marketplace add timescale/pg-aiguide then claude plugin install pg@aiguide.
Setup effort
One command — npx skills add timescale/pg-aiguide --skill postgres
USE CASES
01
Designing a schema you will not regret
The skills carry conventions for constraints, indexes, data types and naming, so the first draft comes back with the parts that usually get added later already in place.
02
Checking a feature against your actual Postgres version
Search the official manual scoped by version rather than trusting the model's recollection of which release introduced what.
03
Working with TimescaleDB or PostGIS
The same search covers Tiger Data's TimescaleDB documentation and the PostGIS spatial manual, so extension-specific syntax comes from the extension's own docs.
04
Adding it to an agent you already use
The remote endpoint needs no install, and npx skills add covers Claude Code, Cursor, Codex, Gemini CLI, VS Code and other agents from one command.
2 tools
Listed in project docs. Your client may show a different list.
view_skillBEFORE YOU INSTALL
What to know first
Tools you get
2 tools named in the project's documentation.
Requires
A client that can reach a remote MCP server over HTTP
INSTALLATION
Connect your client
Server setup
npx
TERMINAL
npx skills add timescale/pg-aiguide --skill postgresHosted endpoint
ENDPOINT URL
https://mcp.tigerdata.com/docsAdd this hosted endpoint to your MCP client.
MCP Clients
Claude Code
CLAUDE CODE · TERMINAL
claude plugin marketplace add timescale/pg-aiguide
claude plugin install pg@aiguideCodex
CODEX · TERMINAL
codex mcp add --url "https://mcp.tigerdata.com/docs" pg-aiguideCursor
CURSOR · JSON
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}Gemini CLI
GEMINI CLI · TERMINAL
gemini mcp add -s user pg-aiguide "https://mcp.tigerdata.com/docs" -t httpVS Code
VS CODE · TERMINAL
code --add-mcp '{"name":"pg-aiguide","type":"http","url":"https://mcp.tigerdata.com/docs"}'VS Code Insiders
VS CODE INSIDERS · TERMINAL
code-insiders --add-mcp '{"name":"pg-aiguide","type":"http","url":"https://mcp.tigerdata.com/docs"}'Windsurf
WINDSURF · JSON
{
"mcpServers": {
"pg-aiguide": {
"serverUrl": "https://mcp.tigerdata.com/docs"
}
}
}
