io.github.timescale/pg-aiguide

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

What does this entry provide?

io.github.timescale/pg-aiguide is an MCP server entry in ChatHome Skills, sourced from Official MCP Registry and scored 73/100. As a Model Context Protocol server, it exposes tools that MCP-compatible LLM clients such as Claude, Cursor, and Copilot can call directly, extending an agent's reach beyond its built-in capabilities. ChatHome Skills discovered this entry through its daily ingest of official registries and GitHub discovery queries, and re-verifies repository facts, freshness signals, and install metadata on every run. The quality score weighs official-registry presence, a working install command, license clarity, GitHub star trajectory, and repository freshness — the full formula is on the Sources page. The install command above is ready to copy. Review the last-pushed date and repository status before adding io.github.timescale/pg-aiguide to a production agent workflow; the snapshot facts below are point-in-time values from the most recent ingest.

Snapshot facts

Source: Official MCP Registry
Quality: 73/100
Install method: streamable-http
Repo: timescale/pg-aiguide
Repo updated: Sep 4, 2026

Install command

mcp add io.github.timescale/pg-aiguide https://mcp.tigerdata.com/docs

Install method: streamable-http

Review the upstream source before running this command.

GitHub project Homepage

Quality

Repo stars

Repo updated

Sep 4, 2026

How is this score calculated?

Weighted across six dimensions, scored 0-100.
Provenance (25): listed in an official or curated registry.
Installability (25): a runnable install command beats a declared transport, which beats a source checkout.
Maintenance (20): recency of the last push; archived entries score zero here.
Adoption (20): repository stars on a log curve.

MCP manifest

{
  "_meta": {
    "io.modelcontextprotocol.registry/official": {
      "status": "active",
      "isLatest": true,
      "updatedAt": "2026-09-04T19:16:47.690447Z",
      "publishedAt": "2026-09-04T19:16:47.690447Z",
      "statusChangedAt": "2026-09-04T19:16:47.690447Z"
    }
  },
  "server": {
    "name": "io.github.timescale/pg-aiguide",
    "$schema": "https://static.modelcontextprotocol.io/schemas/2025-10-17/server.schema.json",
    "remotes": [
      {
        "url": "https://mcp.tigerdata.com/docs",
        "type": "streamable-http"
      }
    ],
    "version": "0.6.1",
    "packages": [
      {
        "version": "0.6.1",
        "transport": {
          "type": "stdio"
        },
        "identifier": "@tigerdata/pg-aiguide",
        "registryType": "npm",
        "environmentVariables": [
          {
            "name": "OPENAI_API_KEY",
            "format": "string",
            "isSecret": true,
            "isRequired": true,
            "description": "Your API key for text embeddings via OpenAI"
          },
          {
            "name": "PGHOST",
            "format": "string",
            "isSecret": true,
            "isRequired": true,
            "description": "PostgreSQL host to connect to"
          },
          {
            "name": "PGPORT",
            "format": "number",
            "isSecret": true,
            "isRequired": true,
            "description": "PostgreSQL port to connect to"
          },
          {
            "name": "PGUSER",
            "format": "string",
            "isSecret": true,
            "isRequired": true,
            "description": "PostgreSQL user to connect as"
          },
          {
            "name": "PGPASSWORD",
            "format": "string",
            "isSecret": true,
            "isRequired": true,
            "description": "PostgreSQL password to connect with"
          },
          {
            "name": "PGDATABASE",
            "format": "string",
            "isSecret": true,
            "isRequired": true,
            "description": "PostgreSQL database to connect to"
          },
          {
            "name": "DB_SCHEMA",
            "format": "string",
            "isSecret": true,
            "description": "PostgreSQL database schema to use"
          }
        ]
      },
      {
        "transport": {
          "type": "stdio"
        },
        "identifier": "ghcr.io/timescale/pg-aiguide:0.6.1",
        "registryType": "oci",
        "environmentVariables": [
          {
            "name": "OPENAI_API_KEY",
            "format": "string",
            "isSecret": true,
            "isRequired": true,
            "description": "Your API key for text embeddings via OpenAI"
          },
          {
            "name": "PGHOST",
            "format": "string",
            "isSecret": true,
            "isRequired": true,
            "description": "PostgreSQL host to connect to"
          },
          {
            "name": "PGPORT",
            "format": "number",
            "isSecret": true,
            "isRequired": true,
            "description": "PostgreSQL port to connect to"
          },
          {
            "name": "PGUSER",
            "format": "string",
            "isSecret": true,
            "isRequired": true,
            "description": "PostgreSQL user to connect as"
          },
          {
            "name": "PGPASSWORD",
            "format": "string",
            "isSecret": true,
            "isRequired": true,
            "description": "PostgreSQL password to connect with"
          },
          {
            "name": "PGDATABASE",
            "format": "string",
            "isSecret": true,
            "isRequired": true,
            "description": "PostgreSQL database to connect to"
          },
          {
            "name": "DB_SCHEMA",
            "format": "string",
            "isSecret": true,
            "description": "PostgreSQL database schema to use"
          }
        ]
      }
    ],
    "repository": {
      "url": "https://github.com/timescale/pg-aiguide",
      "source": "github"
    },
    "description": "Comprehensive PostgreSQL documentation and best practices, including ecosystem tools"
  }
}

Report an issue with this listing