{"server":{"$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.6.1","packages":[{"registryType":"npm","identifier":"@tigerdata/pg-aiguide","version":"0.6.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.6.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-09-04T19:16:47.690447Z","publishedAt":"2026-09-04T19:16:47.690447Z","updatedAt":"2026-09-04T19:16:47.690447Z","isLatest":true}}}