SERVER

Pg Aiguide

Rank #619

io.github.timescale/pg-aiguide

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

8 versions

1,869 GitHub stars

by timescale (8 servers)View repository ↗

First listed

Jul 23, 2025

Last publish date

Sep 4, 2026

PURPOSE

What you can do with Pg Aiguide

Pg Aiguide is a Model Context Protocol (MCP) server published by timescale. It ranks #619 of 144,396 active servers on MCP Toplist, and its repository has 1,869 GitHub stars. Pg Aiguide is listed across 4 registries — Official MCP, Glama, PulseMCP and mcp.so, with 8 tracked versions. It was first listed on Jul 23, 2025 and most recently updated on Sep 4, 2026.

Not verifiedMCP Toplist has not yet written a checked profile for this server, so the paragraph above is assembled from registry data only. The repository README is the authority on what it does.

CAPABILITIES AND LIMITATIONS

What Pg Aiguide can and cannot do

Not verifiedMCP Toplist has not catalogued this server's tools or limitations. The repository README lists them.

REQUIREMENTS

What you need before using Pg Aiguide

DeclaredNo credentialsNo credentials declared

The registry listing declares no required environment variables or authentication. This is declared metadata, not a verified install — the repository README is the authority.

MCP Toplist probed the public endpoint on Oct 11, 2026 and could not complete the MCP handshake (jsonrpc error). Requirements remain unverified.

Declared by Glama, last synced Oct 16, 2026. Not independently verified by MCP Toplist.

Declared in the registry install config

OPENAI_API_KEY · required
PGHOST · required
PGPORT · required
PGUSER · required
PGPASSWORD · required
PGDATABASE · required
DB_SCHEMA · optional

Hosted endpoint declared as public.

INSTALLATION AND FIRST TASK

Connect Pg Aiguide and confirm it works

Remote · HTTP

claude mcp add --transport http pg-aiguide https://mcp.tigerdata.com/docs

npm package

claude mcp add pg-aiguide -e "OPENAI_API_KEY=<your OPENAI_API_KEY>" -e "PGHOST=<your PGHOST>" -e "PGPORT=<your PGPORT>" -e "PGUSER=<your PGUSER>" -e "PGPASSWORD=<your PGPASSWORD>" -e "PGDATABASE=<your PGDATABASE>" -e "DB_SCHEMA=<your DB_SCHEMA>" -- npx -y @tigerdata/pg-aiguide

Replace each placeholder with your own value before saving.

Docker image

claude mcp add pg-aiguide -e "OPENAI_API_KEY=<your OPENAI_API_KEY>" -e "PGHOST=<your PGHOST>" -e "PGPORT=<your PGPORT>" -e "PGUSER=<your PGUSER>" -e "PGPASSWORD=<your PGPASSWORD>" -e "PGDATABASE=<your PGDATABASE>" -e "DB_SCHEMA=<your DB_SCHEMA>" -- docker run -i --rm ghcr.io/timescale/pg-aiguide:0.6.1

Replace each placeholder with your own value before saving.

Remote · HTTP

[mcp_servers.pg-aiguide]
url = "https://mcp.tigerdata.com/docs"

Add to ~/.codex/config.toml.

npm package

[mcp_servers.pg-aiguide]
command = "npx"
args = ["-y", "@tigerdata/pg-aiguide"]

[mcp_servers.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>"

Add to ~/.codex/config.toml. Replace each placeholder with your own value before saving.

Docker image

[mcp_servers.pg-aiguide]
command = "docker"
args = ["run", "-i", "--rm", "ghcr.io/timescale/pg-aiguide:0.6.1"]

[mcp_servers.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>"

Add to ~/.codex/config.toml. Replace each placeholder with your own value before saving.

Remote · HTTP

https://mcp.tigerdata.com/docs

Settings → Connectors → “Add custom connector”, then paste this URL.

npm package

{
  "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>"
      }
    }
  }
}

Add to claude_desktop_config.json (Settings → Developer → Edit Config). Replace each placeholder with your own value before saving.

Docker image

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/timescale/pg-aiguide:0.6.1"
      ],
      "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>"
      }
    }
  }
}

Add to claude_desktop_config.json (Settings → Developer → Edit Config). Replace each placeholder with your own value before saving.

Remote · HTTP

{
  "mcpServers": {
    "pg-aiguide": {
      "url": "https://mcp.tigerdata.com/docs"
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project).

npm package

{
  "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>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). Replace each placeholder with your own value before saving.

Docker image

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/timescale/pg-aiguide:0.6.1"
      ],
      "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>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). Replace each placeholder with your own value before saving.

Remote · HTTP

{
  "servers": {
    "pg-aiguide": {
      "type": "http",
      "url": "https://mcp.tigerdata.com/docs"
    }
  }
}

Save as .vscode/mcp.json in your workspace.

npm package

{
  "servers": {
    "pg-aiguide": {
      "type": "stdio",
      "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>"
      }
    }
  }
}

Save as .vscode/mcp.json in your workspace. Replace each placeholder with your own value before saving.

Docker image

{
  "servers": {
    "pg-aiguide": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/timescale/pg-aiguide:0.6.1"
      ],
      "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>"
      }
    }
  }
}

Save as .vscode/mcp.json in your workspace. Replace each placeholder with your own value before saving.

Remote · HTTP

{
  "mcpServers": {
    "pg-aiguide": {
      "serverUrl": "https://mcp.tigerdata.com/docs"
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.

npm package

{
  "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>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json. Replace each placeholder with your own value before saving.

Docker image

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/timescale/pg-aiguide:0.6.1"
      ],
      "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>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json. Replace each placeholder with your own value before saving.

Remote · HTTP

{
  "mcpServers": {
    "pg-aiguide": {
      "url": "https://mcp.tigerdata.com/docs"
    }
  }
}

npm package

{
  "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>"
      }
    }
  }
}

Replace each placeholder with your own value before saving.

Docker image

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/timescale/pg-aiguide:0.6.1"
      ],
      "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>"
      }
    }
  }
}

Replace each placeholder with your own value before saving.

First successful task

After adding the config, ask your client to list this server's tools. A tool list confirms the connection; an empty list or an error means the server did not start or needs credentials.

ALTERNATIVES

When to choose another server

Other servers by timescale

View all timescale servers →

No task-specific alternatives are catalogued for Pg Aiguideyet; the list above is its publisher's other servers.

MAINTENANCE AND EVIDENCE

What changed, and when this was checked

First listed: Jul 23, 2025
Latest version published: Sep 4, 2026
Version history: 8 versions tracked (below)
Requirements evidence: MCP Toplist probed the public endpoint on Oct 11, 2026 and could not complete the MCP handshake (jsonrpc error). Requirements remain unverified.
Profile checked: Not yet — purpose, capabilities and requirements above come from registry data only
Ranking data as of: Oct 16, 2026

Registry sightings

Official MCP ↗listed since Apr 25, 2026 · still listed
Glama ↗listed since Jun 4, 2026 · still listed
PulseMCP ↗listed since Jun 4, 2026 · still listed
mcp.so ↗listed since Aug 26, 2026 · still listed

Do you maintain Pg Aiguide? to correct or enrich this profile.

VERSIONS

Available versions (8)

Version	Published
0.6.1	Sep 4, 2026
0.5.1	Jun 26, 2026
0.5.0	Apr 28, 2026
0.4.0	Mar 18, 2026
0.3.1	Feb 23, 2026
0.2.4	Dec 10, 2025
0.2.3	Dec 9, 2025
0.1.0	Nov 25, 2024

STANDING

#619of 144,396 active serversTop 0.5%

Ranks ahead of 143,777 of 144,396 servers on MCP Toplist.

Recent momentum

+160GitHub stars since Apr 27 (+9%)

BADGE

Show your rank

Maintain this server? Add the live rank badge to your README — it updates automatically as the leaderboard changes.

Markdown

[![MCP Toplist](https://mcptoplist.com/badge/io.github.timescale%2Fpg-aiguide.svg)](https://mcptoplist.com/server/io.github.timescale%2Fpg-aiguide)

HTML

<a href="https://mcptoplist.com/server/io.github.timescale%2Fpg-aiguide"><img src="https://mcptoplist.com/badge/io.github.timescale%2Fpg-aiguide.svg" alt="MCP Toplist: Top 1% of 144,396" /></a>

Variants: append ?metric=score or ?metric=stars to the image URL.

FAQ

Frequently asked questions

Who maintains Pg Aiguide?: Pg Aiguide is maintained by timescale, which publishes 8 MCP servers (38 total versions) tracked on MCP Toplist.
Is Pg Aiguide listed on the Official MCP Registry?: Yes — Pg Aiguide is listed on the Official MCP Registry, alongside Glama, PulseMCP and mcp.so.
How many versions does Pg Aiguide have?: MCP Toplist tracks 8 versions of Pg Aiguide, most recently published on Sep 4, 2026.
Where can I find the source code for Pg Aiguide?: The source code for Pg Aiguide is hosted at github.com/timescale/pg-aiguide.

Used in projects

Do you run this server?

Community projects list the MCP servers behind real agents and apps. Publish yours and this page will link to it.

EXPLORE

All MCP Servers Official MCP Servers GitHub MCP Servers Best MCP Servers Most Active MCP Servers New MCP Servers Best New MCP Servers