pg-aiguide
Comprehensive PostgreSQL documentation and best practices, including ecosystem tools
What you can do with it
Share of each task's required capabilities it coversPrefer a ready-made agent?
An MCP server is a connector for your own assistant. These finished products do the job for you: query databases in plain language.Similar tools
Listed for the same task: query databases in plain languageReviews
No review yet. Used pg-aiguide? Be the first to help others choose.What it does
pg-aiguide is an MCP server, a connector that lets an AI assistant use it as a tool. It can be used hosted (nothing to install) or installed locally.
From the publisher's description, Electra Index matched it to one capability: sql querying. That makes it a candidate for tasks such as query databases in plain language or build data pipelines.
Facts come from the Official MCP Registry, as declared by the publisher. Capabilities are matched automatically (low confidence). None of this is a test of the tool.
At a glance
How to connect
As declared in the Official MCP Registry · hosted endpoint tested by Electra Index 1d ago (live check)Hosted endpoint
https://mcp.tigerdata.com/docsstreamable-http
In Claude Code: claude mcp add --transport http pg-aiguide https://mcp.tigerdata.com/docs
Install packages
- NPM
@tigerdata/pg-aiguidev0.6.1 · runs locally (stdio) - DOCKER
ghcr.io/timescale/pg-aiguide:0.6.1· runs locally (stdio)
Required: OPENAI_API_KEY, PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE (get them from the publisher)
MCP settings (Claude Desktop, Cursor and other MCP clients)
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}Live check
Electra Index connected to the hosted endpoint 1d agoONLINE pg-aiguide answered an MCP connection on 16 Nov 2026 and introduced itself as pg-aiguide 1.0.0 (MCP protocol 2025-06-18).
3 tools offered to AI assistants
search_docs· Search documentation with hybrid semantic (vector) and keyword (BM25) search. Use semanticWeight to choose keyword-only (0), semantic-only (1), or a blend; mid values fuse rankings with RRF. Supports Tiger Cloud (TimescaleDB), PostgreSQL, aview_skill· Retrieve detailed skills for TimescaleDB operations and best practices. ## Available Skills <available_skills> [11 ]{name description}: design-postgis-tables Comprehensive PostGIS spatial table design reference covering geometry types, coorget_context· Opens any part of the docs (a section or a whole page) as markdown, with links to move around it. Use it on a search_docs hit before answering from it: a hit is one chunk, and often a fragment (a table row without the header that says which
What "online" means: the server answered an MCP connection at the time of the check. It is not a guarantee of security, quality or continuous uptime. How we test: we open an MCP session and ask for the tool list, as an AI assistant would. We never run a tool and never send a key. Checked every few days. Method
Is this your server? Monitoring Pro: a check every 30 minutes and an email within the hour when it stops answering. Launch offer: $39.99 once, for life.
Facts & evidence
Each fact shows where it was seen and when.| Fact | Value | Evidence | Source | Last confirmed |
|---|---|---|---|---|
| Install package | @tigerdata/pg-aiguide, ghcr.io/timescale/pg-aiguide:0.6.1 | DECLARED | SRC-001 Official MCP Registry | 1d ago |
| Hosted endpoint | https://mcp.tigerdata.com/docs | DECLARED | SRC-001 Official MCP Registry | 1d ago |
| Package registries | npm, oci | DECLARED | SRC-001 Official MCP Registry | 1d ago |
| Local install (package) | yes | DECLARED | SRC-001 Official MCP Registry | 1d ago |
| Remote access (hosted) | yes | DECLARED | SRC-001 Official MCP Registry | 1d ago |
| Repository | https://github.com/timescale/pg-aiguide | DECLARED | SRC-001 Official MCP Registry | 1d ago |
| Registry status | active | DECLARED | SRC-001 Official MCP Registry | 1d ago |
| Version | 0.6.1 | DECLARED | SRC-001 Official MCP Registry | 1d ago |
| MCP server | yes | DECLARED | SRC-001 Official MCP Registry | 1d ago |
Change history
Is this page accurate?
Flag it and our robot re-checks the official source. Reports never change a score.Is pg-aiguide still online?
Free alerts · no account▲ 0Do you run pg-aiguide? Know when it stops answering
For publishers · optionalIts hosted endpoint can be monitored. Monitoring Pro connects every 30 minutes like an AI assistant, emails you within the hour when it stops answering, keeps a 90-day availability history and adds your answer rate to your badge.
Monitoring never changes a score or a rank.
Questions about pg-aiguide
How do I connect pg-aiguide?
Use the hosted endpoint https://mcp.tigerdata.com/docs in your assistant's MCP settings. The exact settings are in "How to connect" above, as declared in the Official MCP Registry.
Does pg-aiguide need an API key or token?
Yes. The registry entry lists required values: OPENAI_API_KEY, PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE. Get them from the publisher.
What tools does pg-aiguide offer?
When Electra Index connected on 16 Nov 2026, it listed 3 tools: search_docs, view_skill, get_context. The full list is in "Live check" above.
Is pg-aiguide online?
Yes. Its hosted endpoint answered an MCP connection from Electra Index 1d ago.
What can I use pg-aiguide for?
Based on its description, it is most relevant to: query databases in plain language, build data pipelines.