ahel
Start free

pg-aiguide

MCP serverDatabases & data

Once added, your AI can answer PostgreSQL questions using comprehensive documentation and established best practices. It helps you work through database tasks with recommended approaches and explains how ecosystem tools fit in. pg-aiguide is a data integration maintained at github.com/timescale/pg-aiguide.

Use pg-aiguide in Claude, ChatGPT or Ahel Desktop

Free. Sign in, add pg-aiguide and connect your AI. About a minute.

ClaudeChatGPTAhel Desktop

Also: Claude Code · Cursor · Codex

Then ask your AI: use pg-aiguide to search docs

Details

Available today. Use it from your connected AI after setup.

Add pg-aiguide, then ask your AI a PostgreSQL question or describe a database task you are working on to see it draw on the documentation and best practices.

pg-aiguideStart free

What your AI can do with it

  • Answer questions about PostgreSQL using its documentation
  • Suggest best practices for common database tasks
  • Explain how PostgreSQL ecosystem tools work together
  • Look up recommended approaches before making database changes
  • Point to relevant documentation while helping with database work

Install pg-aiguide

The server’s own address, for the clients that take one directly. Or connect Ahel once and every client you use reads it from one address, with the account kept on Ahel rather than in each client’s config.

  • Claude Code

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

    Run it once in your project, then open /mcp to approve any sign-in the server asks for.

  • Claude Desktop

    https://mcp.tigerdata.com/docs

    Add a custom connector in Settings, paste this address, and approve the sign-in.

  • Cursor

    cursor://anysphere.cursor-deeplink/mcp/install?name=pg-aiguide&config=eyJ1cmwiOiJodHRwczovL21jcC50aWdlcmRhdGEuY29tL2RvY3MifQ==

    Open the link and Cursor adds the server at that address.

  • ChatGPT

    https://mcp.tigerdata.com/docs

    In Settings, enable Developer mode, create an MCP app, and paste this address. Your plan and workspace must allow custom apps.

  • Codex

    codex mcp add pg-aiguide --url 'https://mcp.tigerdata.com/docs'

    Run it once, then sign in with codex mcp login pg-aiguide if the server asks for an account.

From the project's README

As published by timescale/pg-aiguide in README.md. This repository publishes several servers, so only the opening is shown here.

AI-optimized PostgreSQL expertise for coding assistants

pg-aiguide helps AI coding tools write dramatically better PostgreSQL code. It provides:

  • Semantic search across the official PostgreSQL manual (version-aware)
  • AI-optimized “skills” — curated, opinionated Postgres best practices used automatically by AI agents
  • Extension ecosystem docs, starting with TimescaleDB, with more coming soon

Use it as:

  • Agent Skills via npx skills — works with Claude Code, Cursor, Codex, Gemini CLI, and 40+ other agents
  • a public MCP server that can be used with any AI coding agent, or
  • a Claude Code plugin optimized for use with Claude's native skill support.

⭐ Why pg-aiguide?

AI coding tools often generate Postgres code that is:

  • outdated
  • missing constraints and indexes
  • unaware of modern PG features
  • inconsistent with real-world best practices

pg-aiguide fixes that by giving AI agents deep, versioned PostgreSQL knowledge and proven patterns.

See the difference

https://github.com/user-attachments/assets/5a426381-09b5-4635-9050-f55422253a3d

Prompt given to Claude Code:

Shortened here. Read the whole README on GitHub.

Tools it offers (2)

What this server listed when Ahel dialed its public endpoint in Oct 2026, with no key and no account of yours. The names are the server’s own.

  • search_docs
  • view_skill

Signals

GitHub stars
2k
Forks
111
Last commit
Sep 2026

What people say

Users report pg-aiguide makes AI coding tools write proper Postgres instead of generic SQL, with one user claiming it fixed a crashing app's schema and cut load time to 1.5s. Praise centers on version-aware, opinionated guidance from official docs and easy MCP setup; no recurring complaints appear in these posts.

Praised for
version-aware guidance from official Postgres docs
easy setup with Claude Code, Cursor, and other MCP tools
improved AI-generated schema/indexing quality
X@_avichawlaX@cevianNYX@eddiejaoudeX@pythontrendingX@michaelfreedmanX@eddiejaoude

Summarized from 15 public posts. Opinions are theirs, not Ahel's.

Advanced
Delivery
pg-aiguide MCP server → your Ahel connector (mcp.ahel.ai) → your AI.
Item type
mcp-server
Key
io-github-timescale-pg-aiguide
Source
github.com/timescale/pg-aiguide
Hosted endpoint
https://mcp.tigerdata.com/docs

github.com/timescale/pg-aiguide

More in Databases & data

Email and Address Check
MCP server
More in Databases & dataAIOProductOS MCP
MCP server · aioproductos
More in Databases & dataQuantRisk
MCP server · 78degrees
More in Databases & dataPostHog MCP Server
MCP server · posthog
More in Databases & dataAppfigures
MCP server · appfigures
More in Databases & dataRun402
MCP server · kychee-com
More in Databases & data

Best MCP servers for postgres · All best lists