MCP Server MCP

io.github.timescale/pg-aiguide

By github 👁 1 views ▲ 0 votes

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

Homepage Verified source GitHub

Install

npx -y @tigerdata/[email protected]

Configuration Example

{
  "remotes": [
    {
      "type": "streamable-http",
      "url": "https://mcp.tigerdata.com/docs"
    }
  ],
  "packages": [
    {
      "registryType": "npm",
      "identifier": "@tigerdata/pg-aiguide",
      "version": "0.5.1",
      "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.1",
      "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"
        }
      ]
    }
  ]
}

mcp model-context-protocol streamable-http npm oci