MCP server

Postgres AI guide MCP Server

PostgreSQL docs and best practices (schema design, indexes, extensions) for the model to search. Official: built and maintained by Tiger Data. It runs as a hosted remote server or locally. Setup below for 13 clients (checked 2026-10-25). Repo and registry data checked 2026-10-24.
Maintainer
Official · Tiger Data
Runs
Remote + local
GitHub
★ 1,872, last push 2026-10-22 (checked 2026-10-24)
License
Apache-2.0
URL
https://mcp.tigerdata.com/docs
Registry
io.github.timescale/pg-aiguide
Connects to
PostgreSQL

Install the Postgres AI guide MCP Server

Pick your client. Remote first: nothing to install, and you sign in with OAuth where the client supports it. Config shapes checked against each client's docs on 2026-10-25.

Needs OPENAI_API_KEY, PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE (replace the ... with your value).

Run in a terminal, then /mcp inside Claude Code to sign in. Add --scope project to share it via .mcp.json. docs

claude mcp add --transport http postgres-ai-guide https://mcp.tigerdata.com/docs

Security notes

  • The remote server runs at mcp.tigerdata.com, hosted by Tiger Data. You sign in with OAuth in clients that support it, and it acts with your account's permissions.
  • The local server runs with your user's permissions (npx downloads it from npm on first run).
  • Needs OPENAI_API_KEY, PGHOST, PGPORT, PGUSER, PGPASSWORD and PGDATABASE. Use a key or token with the narrowest scopes (read-only if there is one), and keep it out of config files you commit (.mcp.json, .vscode/mcp.json).
  • Context7official · ★ 64k

    Current, version-specific docs and code examples for thousands of libraries, pulled into the prompt.

  • Angular CLIofficial · ★ 27k

    Angular best practices, docs search and project info, built into the Angular CLI.

  • Microsoft Learnofficial · ★ 2k

    Search and fetch official Microsoft and Azure documentation and code samples.

  • Refofficial · ★ 1.2k

    Token-efficient search over public and private documentation.

  • Next.js DevToolsofficial · ★ 832

    Next.js docs, upgrade helpers and live errors and routes from your running dev server.

  • Svelteofficial · ★ 334

    Svelte 5 and SvelteKit docs plus a code checker that suggests fixes.

  • Search, read and get recommendations from AWS documentation.

  • DeepWikiofficial

    Ask questions about any public GitHub repo, answered from DeepWiki's generated docs.

Comparing servers for one product? PostgreSQL MCP servers

FAQ

What does the Postgres AI guide MCP Server do?+

PostgreSQL docs and best practices (schema design, indexes, extensions) for the model to search.

Is the Postgres AI guide MCP server official?+

Official: built and maintained by Tiger Data.

How do I add Postgres AI guide to Claude Code?+

Run: claude mcp add --transport http postgres-ai-guide https://mcp.tigerdata.com/docs, then /mcp inside Claude Code to sign in. Add --scope project to share it with your team through .mcp.json.

How do I use the Postgres AI guide MCP server in Cursor or VS Code?+

Open the Cursor or VS Code tab above: it has the mcp.json entry and a one-click install link. Cursor uses the "mcpServers" key; VS Code uses "servers" and needs a type ("http").

Does Postgres AI guide work in ChatGPT and claude.ai?+

Yes, it has a remote URL (https://mcp.tigerdata.com/docs). In claude.ai add it under Customize > Connectors > Add custom connector; in ChatGPT under chatgpt.com/plugins > Add custom MCP server.

What are the alternatives to the Postgres AI guide MCP server?+

Other documentation MCP servers: Context7, Angular CLI, Microsoft Learn, Ref and Next.js DevTools.

All MCP servers · What is an MCP server? · Agent skills