restheart vs pg-aiguide

Side-by-side comparison to help you pick between these two MCP servers.

	restheart by SoftInstigate	pg-aiguide by timescale
Stars	★ 875	★ 1,729
30d uses	—	—
Score	54	55
Official	—	—
Categories	DatabaseAI / LLM ToolsDeveloper Tools	DatabaseDeveloper ToolsAI / LLM Tools
Language	Java	Python
Last commit	this month	this month

restheart · Summary

RESTHeart is a MongoDB backend that provides a native MCP server for AI agents to access data via REST and GraphQL APIs.

pg-aiguide · Summary

MCP server providing PostgreSQL expertise, semantic search, and best practices for AI coding tools.

restheart · Use cases

AI agent backends for accessing MongoDB data via MCP
API development without boilerplate code
Real-time applications with WebSocket and SSE
Legacy modernization by adding modern APIs to existing MongoDB databases

pg-aiguide · Use cases

Improving PostgreSQL code generation in AI coding assistants
Providing semantic search for PostgreSQL documentation
Implementing best practices for database schema design

restheart · Install

Quick Start Options

**Option 1 — RESTHeart Cloud (no install)** Sign up for the fully managed service at [cloud.restheart.com](https://cloud.restheart.com/signup)

**Option 2 — Docker Compose (local)**

curl https://raw.githubusercontent.com/SoftInstigate/restheart/master/docker-compose.yml --output docker-compose.yml && docker compose up --attach restheart

Default credentials: admin / secret

**Option 3 — Native Executables** Download prebuilt binaries for macOS, Linux, and Windows from [docs/native-executables.md](https://github.com/SoftInstigate/restheart/blob/master/docs/native-executables.md)

**Claude Desktop Setup** In Claude Desktop settings, add a custom connector with context URL: https://sophia-api.restheart.com/mcp/restheart/

**Claude Code Setup**

claude mcp add --transport http sophia-restheart https://sophia-api.restheart.com/mcp/restheart

pg-aiguide · Install

Installation Options

**As an MCP Server:** Add the public MCP server to your client configuration:

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

**As Claude Plugin:**

claude plugin marketplace add timescale/pg-aiguide
claude plugin install pg@aiguide

**Using npx skills:**

npx skills add timescale/pg-aiguide --skill postgres

Comparison generated from public README + GitHub signals. Last updated automatically.