io.github.timescale/pg-aiguide

io.github.timescale/pg-aiguide

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

View repository →

Connect this server

Add this to your MCP client config — claude_desktop_config.json (Claude Desktop) or .cursor/mcp.json (Cursor).Suits: Claude Desktop · Cursor.

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/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>"
      }
    }
  }
}
Environment variables
  • OPENAI_API_KEYrequiredsecretYour API key for text embeddings via OpenAI
  • PGHOSTrequiredsecretPostgreSQL host to connect to
  • PGPORTrequiredsecretPostgreSQL port to connect to
  • PGUSERrequiredsecretPostgreSQL user to connect as
  • PGPASSWORDrequiredsecretPostgreSQL password to connect with
  • PGDATABASErequiredsecretPostgreSQL database to connect to
  • DB_SCHEMAsecretPostgreSQL database schema to use

A starting point — check the repository for exact arguments and setup. Restart your client after editing the config.

Category
Developer Tools
Version
0.6.1
Registry
active
Published
9/4/2026

Remotes

  • streamable-httphttps://mcp.tigerdata.com/docs

More Developer Tools servers

Browse all Developer Tools →

Tiger MCP

timescale

Provides programmatic access to Tiger Cloud services, databases, and documentation.

Developer ToolsAdded 2 weeks ago

io.github.timescale/tiger-skills

timescale

Provider agnostic skills implementation, with skills sourced from local paths or GitHub repositories

Developer ToolsAdded 11 months ago

Timesheet

timesheetIO

timesheet.io MCP server - manage timers, projects, tasks and reports

Developer ToolsAdded 1 month ago

MSGraph MCP

timfurlong

MCP server for Microsoft Graph: Outlook mail and calendar, plus read-only Microsoft Teams

Developer ToolsAdded 1 month ago

Staylong: Thailand long-stay visas

Timgrassin

Thai visa rules, eligibility checks, 90-day reports, immigration offices and places to live.

Developer ToolsAdded 6 days ago

HalloFelix von InsurMagic

timgutberlet

HalloFelix von InsurMagic: AI phone & WhatsApp assistant for insurance brokers.

Developer ToolsAdded 1 week ago

Add the badge to your site

Show visitors that io.github.timescale/pg-aiguide is listed here — it’s also the link we check for a free listing.

io.github.timescale/pg-aiguide — listed on Serverdex

HTML — for your website

<a href="https://serverdex.io/server/io-github-timescale-pg-aiguide?utm_source=badge"><img src="https://serverdex.io/brand/badge.svg" alt="io.github.timescale/pg-aiguide — listed on Serverdex" width="123" height="40" loading="lazy"></a>

Recommended. A dofollow link from your own domain is the one that counts for search engines, and it's the link we check for a free listing.

Markdown — for your README

[![io.github.timescale/pg-aiguide — listed on Serverdex](https://serverdex.io/brand/badge.svg)](https://serverdex.io/server/io-github-timescale-pg-aiguide?utm_source=badge)

Nice for visibility, but GitHub marks README links nofollow, so it doesn't pass authority. Use the HTML badge on your site as well.