pg-aiguide MCP server
MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
What pg-aiguide does
Summarised from the project README; check the repository for the latest details.
Features
- `searchdocs`
- `postgres` - Official PostgreSQL manual, scoped by version
- `tiger` - Tiger Data's documentation (TimescaleDB and ecosystem)
- `postgis` - PostGIS spatial extension documentation
- `viewskill`
- Exploring existing PostgreSQL schemas and objects
Requirements
- Remote server URL (no local install)
Repository: timescale/pg-aiguide
Stars: ★1869
Language: Python
Last updated: 2026-10-14
aiai-agentsai-codingclaude-code-pluginclaude-code-pluginsclaude-code-plugins-marketplaceclaude-marketplaceclaude-pluginclaude-skillsdocsdocumentationmcpmcp-serverpostgrespostgresqlskills
Stars: ★1869
Language: Python
Last updated: 2026-10-14
aiai-agentsai-codingclaude-code-pluginclaude-code-pluginsclaude-code-plugins-marketplaceclaude-marketplaceclaude-pluginclaude-skillsdocsdocumentationmcpmcp-serverpostgrespostgresqlskills
How to install pg-aiguide MCP in Claude Desktop, Cursor and VS Code
Install
Taken from the project README (README Cursor install link). Check the README for required API keys before use.
Claude Code
Terminal (claude CLI)
claude mcp add --transport http pg-aiguide https://mcp.tigerdata.com/docsClaude Desktop
Remote server: add it under Customize → Connectors → Add custom connector with the URL https://mcp.tigerdata.com/docs.
Cursor
~/.cursor/mcp.json
{
"mcpServers": {
"pg-aiguide": {
"name": "pg-aiguide",
"type": "http",
"url": "https://mcp.tigerdata.com/docs"
}
}
}VS Code
.vscode/mcp.json
{
"servers": {
"pg-aiguide": {
"type": "http",
"name": "pg-aiguide",
"url": "https://mcp.tigerdata.com/docs"
}
}
}Add to config generator – combine it with other servers, or get the Windsurf format.
Featured in: Best MCP servers for PostgreSQL
Maintain this project? Get it featured for free during launch →
Compare with codebase-memory-mcp →
Related Databases MCP servers
codebase-memory-mcp by DeusData · ★46608
High-performance code intelligence MCP server. Indexes codebases into a persistent knowledge graph — average repo in milliseconds. 158 langu
Databases
High-performance code intelligence MCP server. Indexes codebases into a persistent knowledge graph — average repo in milliseconds. 158 langu
Databases
nightingale by ccfos · ★13352
Open-source, self-hosted alerting for metrics, logs, and databases. Includes a built-in AI agent and MCP server.
Databases
Open-source, self-hosted alerting for metrics, logs, and databases. Includes a built-in AI agent and MCP server.
Databases
code-graph-rag by vitali87 · ★5258
The ultimate RAG for your monorepo. Query, understand, and edit multi-language codebases with the power of AI and knowledge graphs
Databases
The ultimate RAG for your monorepo. Query, understand, and edit multi-language codebases with the power of AI and knowledge graphs
Databases
Weekly MCP digest – new and trending MCP servers in your inbox.