io.github.timescale/pg-aiguide

io.github.timescale/pg-aiguide·v0.5.0·Databases

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

Trust verdict · v1 advisory · method

NOT YET SCREENEDno verdict on file

Verdict not yet evaluated for this tool. The semantic screen takes adversarial cases first; coverage rolls out as the corpus expands (15/150 labels to graduation). The deterministic conformance probe is built but has not yet run on the public corpus, so a recorded verdict here is REVIEW or UNVERIFIED, never a clearing ALLOW. Until a verdict is recorded, an agent should treat this tool as not-yet-cleared and fall back to its own checks. Method: the eval, four-state verdict, honest limits.

Own this server? Screen its description →

Environment variables

OPENAI_API_KEY

requiredsecret

Your API key for text embeddings via OpenAI

PGHOST

requiredsecret

PostgreSQL host to connect to

PGPORT

requiredsecret

PostgreSQL port to connect to

PGUSER

requiredsecret

PostgreSQL user to connect as

PGPASSWORD

requiredsecret

PostgreSQL password to connect with

PGDATABASE

requiredsecret

PostgreSQL database to connect to

DB_SCHEMA

secret

PostgreSQL database schema to use

OPENAI_API_KEY

requiredsecret

Your API key for text embeddings via OpenAI

PGHOST

requiredsecret

PostgreSQL host to connect to

PGPORT

requiredsecret

PostgreSQL port to connect to

PGUSER

requiredsecret

PostgreSQL user to connect as

PGPASSWORD

requiredsecret

PostgreSQL password to connect with

PGDATABASE

requiredsecret

PostgreSQL database to connect to

DB_SCHEMA

secret

PostgreSQL database schema to use

MCP quality score · maturity, not trust · methodology

freshness

completeness

installability

documentation

stability

Alternatives in Databases

ai.haymon/dbmcp

Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite with PII redaction and write-prevention

ai.smithery/MisterSandFR-supabase-mcp-selfhosted

Manage Supabase projects end to end across database, auth, storage, realtime, and migrations. Moni…

ai.smithery/afgong-sqlite-mcp-server

Explore your Messages SQLite database to browse tables and inspect schemas with ease. Run flexible…

Install

Remote endpoint

Streamable HTTP / SSE endpoint. Add to any MCP client that supports remote servers.

https://mcp.tigerdata.com/docs

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/pg-aiguide"
      ],
      "env": {
        "OPENAI_API_KEY": "<your-openai_api_key>",
        "PGHOST": "<your-pghost>",
        "PGPORT": "<your-pgport>",
        "PGUSER": "<your-pguser>",
        "PGPASSWORD": "<your-pgpassword>",
        "PGDATABASE": "<your-pgdatabase>",
        "DB_SCHEMA": "<your-db_schema>"
      }
    }
  }
}

Cursor (.cursor/mcp.json)

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/pg-aiguide"
      ],
      "env": {
        "OPENAI_API_KEY": "<your-openai_api_key>",
        "PGHOST": "<your-pghost>",
        "PGPORT": "<your-pgport>",
        "PGUSER": "<your-pguser>",
        "PGPASSWORD": "<your-pgpassword>",
        "PGDATABASE": "<your-pgdatabase>",
        "DB_SCHEMA": "<your-db_schema>"
      }
    }
  }
}

Cline (cline_mcp_settings.json)

npx -y @tigerdata/pg-aiguide

Claude Desktop (Docker)

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "docker",
      "args": [
        "run",
        "--rm",
        "-i",
        "ghcr.io/timescale/pg-aiguide:0.5.0"
      ],
      "env": {
        "OPENAI_API_KEY": "<your-openai_api_key>",
        "PGHOST": "<your-pghost>",
        "PGPORT": "<your-pgport>",
        "PGUSER": "<your-pguser>",
        "PGPASSWORD": "<your-pgpassword>",
        "PGDATABASE": "<your-pgdatabase>",
        "DB_SCHEMA": "<your-db_schema>"
      }
    }
  }
}

Verdict API

curl -s mcpindex.ai/api/v1/trust/server/io-github-timescale-pg-aiguide

Free-tier verdict as JSON: decision + dimensions + severity. Call it from your agent before it invokes a tool it just discovered.

Details

version: v0.5.0
category: Databases
quality: 79 / 100
operator: timescale

Provenance

Verdict history is anchored to Bitcoin via OpenTimestamps. The free tier returns the current verdict only; the anchored record is served on the authenticated tier.

Links

Repository →Remote endpoint →