io.github.timescale/pg-aiguide
REMOTE · MCP.TIGERDATA.COM · 3 COMPONENTS · SCANNED SEP 20
Comprehensive PostgreSQL documentation and best practices, including ecosystem tools
How this component scores in each security and reliability category. Every signal is checked automatically against the live server, and we only credit what we can confirm. How we score → Why this is hard to score →
Endpoint Security63
- The endpoint's TLS certificate is valid, in date, and uses a strong key. View diagnostics → Pass
- Authorisation not fully verified: no authorisation is required to call this server, and 2 tool(s) never declared a destructiveHint. The MCP spec treats an absent hint as destructive by default, so we cannot call this surface safe. See how to fix → View diagnostics → Unverified
- HTTPS is enforced; there's no plaintext access path. View diagnostics → Pass
- The HSTS (Strict-Transport-Security) header is present. View diagnostics → Pass
- DNSSEC check failed: this domain isn't protected by DNSSEC. See how to fix → View diagnostics → Fail
Transport & Reachability100
- Verified streamable-http transport via a live MCP handshake. View diagnostics → Pass
Schema Quality & AI Usability72
- 100% of prompts and resources have a non-trivial description (not blank, and not just the item's name).Pass
- AI-judged instruction clarity (excellent).Pass
- Context-footprint check failed: tool/resource definitions use about 1958 tokens (~979/item across 2 items; 2 tools + 0 resources), over budget; trim descriptions and params. See how to fix → Fail
- Usage-examples check failed: none of the tools include examples. See how to fix → Fail
Stability & Change Management100
- No destabilizing schema changes in the last 30 days.Pass
Tool Coverage100
- 100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
- 100% of tool parameters carry a description.Pass
- Structured output schemas are declared (100% of tools); any adoption earns full credit.Pass
Tool Safety100
- No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.Pass
- We read all 2 captured tool definition(s), and no name or description among them implies an irreversible operation.Pass
- An AI judge read all 2 captured unit(s) of tool text and found none that tries to manipulate the model reading it.Pass
Capabilities100
- Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.Pass
How do I install the io.github.timescale/pg-aiguide MCP server?
io.github.timescale/pg-aiguide is a hosted endpoint at https://mcp.tigerdata.com/docs, so there is nothing to install locally. Ready-made configuration for Claude, Cursor, VS Code, Codex and 5 more is on this page, copied from each client's own documentation.
remote · mcp.tigerdata.com
claude mcp add --transport http timescale-pg-aiguide 'https://mcp.tigerdata.com/docs'
{
"mcpServers": {
"timescale-pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
} {
"servers": {
"timescale-pg-aiguide": {
"type": "http",
"url": "https://mcp.tigerdata.com/docs"
}
}
} [mcp_servers.timescale-pg-aiguide] url = "https://mcp.tigerdata.com/docs"
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"timescale-pg-aiguide": {
"type": "remote",
"url": "https://mcp.tigerdata.com/docs",
"enabled": true
}
}
} openclaw mcp add timescale-pg-aiguide --url 'https://mcp.tigerdata.com/docs' --transport streamable-http
mcp_servers:
timescale-pg-aiguide:
url: "https://mcp.tigerdata.com/docs" {
"McpServers": {
"timescale-pg-aiguide": {
"Transport": "http",
"Url": "https://mcp.tigerdata.com/docs"
}
}
} assistant mcp add timescale-pg-aiguide -t streamable-http -u 'https://mcp.tigerdata.com/docs'
{
"mcpServers": {
"timescale-pg-aiguide": {
"type": "http",
"url": "https://mcp.tigerdata.com/docs"
}
}
} The mcpServers block is a cross-client convention. Remote transports vary, so check your client's docs.
Every change we have recorded for this component, newest first. Security-relevant changes are always shown. ▲ marks a change for the better, ▼ a change for the worse; unmarked changes are neutral.
- 4 Sept 26 0
- Tool “view_skill” rewrote its description, which is the text the model reads security
- Prompt “ghost-database” was removed ▼ functional
- Schema quality: 1095 → 979 ▲ functional
- 26 Aug 26 0
- We updated how we score, so this day's move reflects our rubric, not a change to the server See what changed → functional
- 25 Aug 26 +1
- Stability: 0.97 → pass security
- 23 Aug 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 90 to 93. That category is still filling its 30-day observation window: 27 days of observed history at the previous scan, 28 at this one. The score rises as the window fills, whether or not the server changes.
- 11 Aug 26 0
- We updated how we score, so this day's move reflects our rubric, not a change to the server See what changed → functional
- 31 Jul 26 0
- We updated how we score, so this day's move reflects our rubric, not a change to the server See what changed → functional
- 30 Jul 26 0
- We updated how we score, so this day's move reflects our rubric, not a change to the server See what changed → functional
- 27 Jul 26 0
- We updated how we score, so this day's move reflects our rubric, not a change to the server See what changed → functional
Diagnostic detail from the automated scan of this channel: what the scanner observed at each step, so you can see exactly where a check passed or failed. It is informational only and never changes the trust score.
Captured 20 Sept 2026 · Probed https://mcp.tigerdata.com/docs
TLS valid
Negotiated TLS 1.3 with TLS_AES_256_GCM_SHA384 .
| Subject | Issuer | Valid from | Valid until | Key | Signature | Serial |
|---|---|---|---|---|---|---|
| CN=mcp.tigerdata.com | CN=YR2,O=Let's Encrypt,C=US | 13 Sept 2026 | 12 Dec 2026 | RSA 2048 | SHA256-RSA | 5e65a58817ed8b7c7ad532d67ed96461b41 |
| SANs: mcp.tigerdata.com | ||||||
| CN=YR2,O=Let's Encrypt,C=US (CA) | CN=Root YR,O=ISRG,C=US | 3 Sept 2025 | 2 Sept 2028 | RSA 2048 | SHA256-RSA | 4ebd24947e24d394802d84a52fd5b319 |
| CN=Root YR,O=ISRG,C=US (CA) | CN=ISRG Root X1,O=Internet Security Research Group,C=US | 13 May 2026 | 2 Sept 2032 | RSA 4096 | SHA256-RSA | f24b6d17f9d9ad7cb1c9fea78782699f |
Background: What to check on a remote MCP endpoint →
DNSSEC insecure
Validation of mcp.tigerdata.com. — Not signed
| Zone | DS | Keys | Algorithms | Outcome |
|---|---|---|---|---|
| . | trust_anchor | 20326, 38696 | 8, 8 | Verified |
| com. | present | 19718 | 13 | Verified |
| tigerdata.com. | present | 2371 | 13 | Verified |
| mcp.tigerdata.com. | absent | Unsigned (proven) parent-signed NSEC/NSEC3 proves an unsigned delegation |
Authentication No authorisation required
The endpoint answered without asking for a token. Anyone who knows the URL can reach it.
| Result | No authorisation required |
|---|---|
| HTTP status | 200 |
| Header | Value |
|---|---|
| strict-transport-security | max-age=31536000; includeSubDomains |
Background: How OAuth 2.1 works in the 2026 MCP spec →
Transports 2 probes
| Transport | URL | Outcome | Status | Location |
|---|---|---|---|---|
| streamable-http | https://mcp.tigerdata.com/docs | Verified | 200 | |
| http (plaintext) | http://mcp.tigerdata.com/docs | HTTPS enforced | 308 | https://mcp.tigerdata.com/docs |
The tools this component advertises to a client, with an estimated token cost for each. Expand a tool to see its parameters and schema. The per-tool counts are indicative and are not scored directly; the schema's total context footprint is one signal in Schema Quality & AI Usability. A tool's description is untrusted text the model reads on every call, which is what makes this list a security surface and not just an inventory: how tool poisoning works →
search_docs Search Documentation ~211
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, and PostGIS.
| Name | Type | Req | Description |
|---|---|---|---|
| limit | – | yes | The maximum number of matches to return. Defaults to 20. |
| query | string | yes | The search query. Used for BM25 when keyword or hybrid search applies, and for the embedding when semantic or hybrid search applies. |
| semanticWeight | – | yes | Controls the balance between semantic and keyword search. 0 = keyword only, 0.5 = equal mix, 1 = semantic only. Default is 0.7 (favor semantic search). |
| source | string | yes | The documentation source to search. "tiger" for Tiger Cloud and TimescaleDB, "postgres" for PostgreSQL, "postgis" for PostGIS spatial extension. Specific versions provided with _X.X suffixes. |
| Name | Type | Req | Description |
|---|---|---|---|
| results | array | yes | – |
No examples provided.
view_skill View Skill ~1,747
Retrieve detailed skills for TimescaleDB operations and best practices. ## Available Skills <available_skills> [9 ]{name description}: design-postgis-tables Comprehensive PostGIS spatial table design reference covering geometry types, coordinate systems, spatial indexing, and performance patterns for location-based applications design-postgres-tables "Use this skill for general PostgreSQL table design.\n\n**Trigger when user asks to:**\n- Design PostgreSQL tables, schemas, or data models when creating new tables and when modifying existing ones.\n- Choose data types, constraints, or indexes for PostgreSQL\n- Create user tables, order tables, reference tables, or JSONB schemas\n- Understand PostgreSQL best practices for normalization, constraints, or indexing\n- Design update-heavy, upsert-heavy, or OLTP-style tables\n\n\n**Keywords:** PostgreSQL schema, table design, data types, PRIMARY KEY, FOREIGN KEY, indexes, B-tree, GIN, JSONB, constraints, normalization, identity columns, partitioning, row-level security\n\nComprehensive reference covering data types, indexing strategies, constraints, JSONB patterns, partitioning, and PostgreSQL-specific best practices.\n" find-hypertable-candidates "Use this skill to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables.\n\n**Trigger when user asks to:**\n- Analyze database tables for hypertable conversion potential\n- Identify time-series or event tables in an existing schema\n- Evaluate if a table would benefit from Timescale/TimescaleDB\n- Audit PostgreSQL tables for migration to Timescale/TimescaleDB/TigerData\n- Score or rank tables for hypertable candidacy\n\n\n**Keywords:** hypertable candidate, table analysis, migration assessment, Timescale, TimescaleDB, time-series detection, insert-heavy tables, event logs, audit tables\n\nProvides SQL queries to analyze table statistics, index patterns, and query patterns. Includes scoring criteria (8+ p…
| Name | Type | Req | Description |
|---|---|---|---|
| path | string | yes | A relative path to a file or directory within the skill to view. If empty, will view the `SKILL.md` file by default. Use `.` to list the root directory of the skill. |
| skill_name | string | yes | The name of the skill to browse, or `.` to list all available skills. |
| Name | Type | Req | Description |
|---|---|---|---|
| content | string | yes | The content of the file or directory listing. |
No examples provided.
What is the io.github.timescale/pg-aiguide MCP server?
io.github.timescale/pg-aiguide is an MCP server listed in the public MCP registry as io.github.timescale/pg-aiguide. Comprehensive PostgreSQL documentation and best practices, including ecosystem tools. This page covers its hosted endpoint (https://mcp.tigerdata.com/docs).
Is the io.github.timescale/pg-aiguide MCP server safe to use?
io.github.timescale/pg-aiguide scores 80 out of 100 on VerifyMCP. That is a record of what we were able to check automatically, not an endorsement. The category breakdown on this page shows every signal behind the number, including the ones we could not confirm.
What tools does the io.github.timescale/pg-aiguide MCP server expose?
io.github.timescale/pg-aiguide exposes 2 tools: search_docs, view_skill. Their descriptions and schemas cost roughly 1,958 tokens of context every time the server is loaded.
Does the io.github.timescale/pg-aiguide MCP server require authentication?
No. We connected to io.github.timescale/pg-aiguide without credentials and it answered, so anything it exposes is reachable by anyone who knows the address.
Is the io.github.timescale/pg-aiguide MCP server still maintained?
io.github.timescale/pg-aiguide is still listed as active in the MCP registry. We last reached this channel on 20 September 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.