{"guide":{"$schema":"https://raw.githubusercontent.com/apideck-libraries/mcp-connect/main/proposals/connection-guide/0.1/schema.json","specVersion":"0.1-draft","id":"https://raw.githubusercontent.com/apideck-libraries/mcp-connect/main/proposals/connection-guide/0.1/catalog/guides/timescale-pg-aiguide.json","title":"io.github.timescale/pg-aiguide connection guide","locale":"en","binding":{"serverId":"io.github.timescale/pg-aiguide","connectionId":"timescale-pg-aiguide","source":{"format":"mcp-registry-server-json","url":"https://raw.githubusercontent.com/apideck-libraries/mcp-connect/main/proposals/connection-guide/0.1/catalog/sources/timescale-pg-aiguide.json","schema":"https://static.modelcontextprotocol.io/schemas/2025-10-17/server.schema.json","sha256":"131018bd12a5e4cb5bf10a15eadc1c4efa97cd1f7e181d0da3b29673ebc57150"},"pointer":"/remotes/0"},"inputs":[],"authentication":{"clientToServer":{"id":"mcp-access","scheme":"unknown","credentialSource":"unknown","inputRefs":[],"evidenceRefs":["registry"]},"downstreamStatus":"unknown","serverToApi":[]},"steps":[{"id":"review-setup","kind":"open-url","title":"Review the project’s setup and account requirements","url":"https://github.com/timescale/pg-aiguide","evidenceRefs":["project"]},{"id":"review-authentication","kind":"manual","title":"Confirm credentials and permissions before connecting","text":"Review the project documentation for account access, permissions and OAuth or credential requirements. Missing Registry headers do not imply anonymous access. Downstream authentication has not been established by this guide.","evidenceRefs":["registry","project"]},{"id":"initialize","kind":"verify","title":"Initialize the MCP connection after setup","check":"initialize","evidenceRefs":["registry"]}],"evidence":[{"id":"registry","url":"https://registry.modelcontextprotocol.io/v0.1/servers/io.github.timescale%2Fpg-aiguide/versions/0.6.1","reviewedAt":"2026-10-24","kind":"registry-metadata"},{"id":"project","url":"https://github.com/timescale/pg-aiguide","reviewedAt":"2026-10-24","kind":"project-documentation"}],"extensions":{"apideck.com/generation":{"status":"generated-needs-review","repository":"https://github.com/timescale/pg-aiguide","repositoryStars":1872,"rankingObservedAt":"2026-10-24T00:01:33.635683+00:00","rank":65,"downstreamAuthenticationReviewed":false,"declaredInputCount":0,"includedInputCount":0}}},"source":{"$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"}]},"documentationReview":null,"upstreamRevision":"9579bfcc3e8b0bd6abbc86c249119d6d9763c5a9"}