MCP server
Postgres AI guide MCP Server
- 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
Customize > Connectors > Add > Add custom connector, paste this URL and sign in. It syncs to Claude Desktop and mobile. docs
https://mcp.tigerdata.com/docs
The free plan allows one custom connector. On Team and Enterprise an owner adds it under Organization settings > Connectors.
chatgpt.com/plugins > + > Add custom MCP server, paste the URL, set up sign-in and create it as a plugin. Then @-mention it in a chat. docs
https://mcp.tigerdata.com/docs
Workspace admins can turn custom MCP plugins off.
Add to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project), or use the install button. docs
{
"mcpServers": {
"postgres-ai-guide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}Add to .vscode/mcp.json (note the "servers" key and the type), or use the install button. Command Palette > "MCP: Open User Configuration" for all workspaces. docs
{
"servers": {
"postgres-ai-guide": {
"type": "http",
"url": "https://mcp.tigerdata.com/docs"
}
}
}Run codex mcp add postgres-ai-guide --url https://mcp.tigerdata.com/docs (then codex mcp login postgres-ai-guide), or add this to ~/.codex/config.toml. The CLI, IDE extension and Codex app share it. docs
[mcp_servers.postgres-ai-guide] url = "https://mcp.tigerdata.com/docs"
Run in a terminal (-s user adds it for all projects), then /mcp auth to sign in. In ~/.gemini/settings.json the key is httpUrl. docs
gemini mcp add -s user --transport http postgres-ai-guide https://mcp.tigerdata.com/docs
Run in a terminal; it writes ~/.copilot/mcp-config.json. docs
copilot mcp add --transport http postgres-ai-guide https://mcp.tigerdata.com/docs
Add to mcp_config.json: ~/.config/devin/mcp_config.json on macOS and Linux (older installs: ~/.codeium/windsurf/mcp_config.json), %APPDATA%\devin\ on Windows. docs
{
"mcpServers": {
"postgres-ai-guide": {
"serverUrl": "https://mcp.tigerdata.com/docs"
}
}
}Add to Zed's settings.json (or Settings > AI > MCP Servers > Add Server). Remote servers without an Authorization header sign in with OAuth. docs
{
"context_servers": {
"postgres-ai-guide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}Add to opencode.json in the project (or ~/.config/opencode/opencode.json). Sign in with opencode mcp auth postgres-ai-guide. docs
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"postgres-ai-guide": {
"type": "remote",
"url": "https://mcp.tigerdata.com/docs",
"enabled": true
}
}
}Add to ~/.kiro/settings/mcp.json (all projects) or .kiro/settings/mcp.json (this project). docs
{
"mcpServers": {
"postgres-ai-guide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}MCP Servers > Configure > Configure MCP Servers opens cline_mcp_settings.json; add this entry. docs
{
"mcpServers": {
"postgres-ai-guide": {
"type": "streamableHttp",
"url": "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).
Alternatives
- 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.
- AWS Documentationofficial
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.