timescale/pg-aiguide

latest · 0.6.1

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

GitHub: timescale/pg-aiguide
npm: @tigerdata/pg-aiguide
MCP registry: io.github.timescale/pg-aiguide

Install

Needs env vars: OPENAI_API_KEY, PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE — replace the <placeholders> with your values.

claude mcp add io-github-timescale-pg-aiguide --env OPENAI_API_KEY=<OPENAI_API_KEY> --env PGHOST=<PGHOST> --env PGPORT=<PGPORT> --env PGUSER=<PGUSER> --env PGPASSWORD=<PGPASSWORD> --env PGDATABASE=<PGDATABASE> -- npx @tigerdata/pg-aiguide

/mcp confirms it's connected.

Install

Or add it manually in ~/.cursor/mcp.json:

{
  "mcpServers": {
    "io-github-timescale-pg-aiguide": {
      "command": "npx",
      "args": [
        "@tigerdata/pg-aiguide"
      ],
      "env": {
        "OPENAI_API_KEY": "<OPENAI_API_KEY>",
        "PGHOST": "<PGHOST>",
        "PGPORT": "<PGPORT>",
        "PGUSER": "<PGUSER>",
        "PGPASSWORD": "<PGPASSWORD>",
        "PGDATABASE": "<PGDATABASE>"
      }
    }
  }
}

In claude_desktop_config.json (Settings → Developer → Edit Config), then restart:

{
  "mcpServers": {
    "io-github-timescale-pg-aiguide": {
      "command": "npx",
      "args": [
        "@tigerdata/pg-aiguide"
      ],
      "env": {
        "OPENAI_API_KEY": "<OPENAI_API_KEY>",
        "PGHOST": "<PGHOST>",
        "PGPORT": "<PGPORT>",
        "PGUSER": "<PGUSER>",
        "PGPASSWORD": "<PGPASSWORD>",
        "PGDATABASE": "<PGDATABASE>"
      }
    }
  }
}

Config entry, any MCP client:

{
  "command": "npx",
  "args": [
    "@tigerdata/pg-aiguide"
  ],
  "env": {
    "OPENAI_API_KEY": "<OPENAI_API_KEY>",
    "PGHOST": "<PGHOST>",
    "PGPORT": "<PGPORT>",
    "PGUSER": "<PGUSER>",
    "PGPASSWORD": "<PGPASSWORD>",
    "PGDATABASE": "<PGDATABASE>"
  }
}

Community score

Community62/ 100

from web signals · no reviews yet (community v3)

Web signals (ecosystem baseline)62/100 · 100% of the weight

Used it? Rate v0.6.1

No reviews yet — be the first.

What the web says

Ecosystem baseline62/ 100

Objective public usage & activity (formula v3) — the community score's web-signals input, and its own sort.

GitHubsource ↗

GitHub stars · 8 days ago: ★ 1.9K
Last commit · 8 days ago: 4 days ago
Issue close rate · 8 days ago: 72%
Release cadence · 8 days ago: about every 26 days
Latest release · 8 days ago: v0.6.1
License · 8 days ago: Apache-2.0

Packages

No package-registry data collected yet.

Listed on

Glama · 9 days ago: Listed ↗

Mentions

Quotes1

Show HN: Pg-aiguide – Write better PostgreSQL code with AI ↗
Hi HN,<p>I built a suite of tools to help ai generate better PostgreSQL code. The most interesting part is an opinionated set of skills to help it design better Postgres schemas. Also includes search over the manual.<p>Deployeable as both a…
Hacker News · @cevian · 3 points

Docs & liveness

No liveness or verification signals yet.

Version history1

0.6.1release date unknown

Badge for your README

Shows this page's community score and its sample, kept current, and links readers here to review.

[![rateme12 community score](https://api.rateme12.com/servers/8a2de16f-9691-4213-954f-95460cfb39a2/badge.svg)](https://rateme12.com/servers/8a2de16f-9691-4213-954f-95460cfb39a2)

Details

Transport: stdio
Status: listed
Source: Imported from the MCP registry
Repository: source ↗