io.github.timescale/pg-aiguide✓

The full server descriptor as registered with IndusMCP.

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