Pg Aiguide

Pg Aiguide is a remote MCP server: there is nothing to install. Its endpoint is https://mcp.tigerdata.com/docs, served over Streamable HTTP. In an assistant that accepts remote MCP servers (often under a setting named connectors, integrations or tools), add a new server and give it this URL; in a client configured by file, add it as a remote (HTTP) server with the same URL.

No headers are declared in the registry entry. If the server needs you to sign in, a client that supports MCP authorization opens the service's own sign-in page when it first connects.

It can also run locally from a Node.js package published to the npm registry: @tigerdata/pg-aiguide version 0.6.1. It speaks MCP over stdio, so the client starts it as a program and talks to it through standard input and output. It needs Node.js; clients usually start it with npx — the usual command is npx -y @tigerdata/pg-aiguide@0.6.1. It reads these environment variables: OPENAI_API_KEY (required, secret), PGHOST (required, secret), PGPORT (required, secret), PGUSER (required, secret), PGPASSWORD (required, secret), PGDATABASE (required, secret) and DB_SCHEMA (secret); set them in the client's configuration for this server.

It can also run locally from a container image in an OCI registry such as Docker Hub or GitHub Container Registry: ghcr.io/timescale/pg-aiguide:0.6.1. It speaks MCP over stdio, so the client starts it as a program and talks to it through standard input and output. It needs Docker or another OCI container runtime; started with docker run — the usual command is docker run -i --rm -e OPENAI_API_KEY -e PGHOST -e PGPORT -e PGUSER -e PGPASSWORD -e PGDATABASE -e DB_SCHEMA ghcr.io/timescale/pg-aiguide:0.6.1. It reads these environment variables: OPENAI_API_KEY (required, secret), PGHOST (required, secret), PGPORT (required, secret), PGUSER (required, secret), PGPASSWORD (required, secret), PGDATABASE (required, secret) and DB_SCHEMA (secret); set them in the client's configuration for this server.

In the mcpServers JSON format that many desktop and editor MCP clients read, the entry looks like this (placeholders in angle brackets):

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/pg-aiguide@0.6.1"
      ],
      "env": {
        "OPENAI_API_KEY": "<secret>",
        "PGHOST": "<secret>",
        "PGPORT": "<secret>",
        "PGUSER": "<secret>",
        "PGPASSWORD": "<secret>",
        "PGDATABASE": "<secret>",
        "DB_SCHEMA": "<secret>"
      }
    }
  }
}

Derived from the registry entry, not tested here. What the server does, and on what terms, is set by its publisher; check its repository or website before giving it access to your accounts or files. How to add an MCP server to an assistant · Before you connect