{
    "$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.1",
    "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"
                }
            ]
        }
    ],
    "remotes": [
        {
            "type": "streamable-http",
            "url": "https://mcp.tigerdata.com/docs"
        }
    ],
    "_meta": {
        "io.modelcontextprotocol.registry/official": {
            "status": "active",
            "statusChangedAt": "2026-06-26T19:20:59.847123Z",
            "publishedAt": "2026-06-26T19:20:59.847123Z",
            "updatedAt": "2026-06-26T19:20:59.847123Z",
            "isLatest": true
        }
    }
}