clickhouse-best-practices vs io.github.timescale/pg-aiguide
clickhouse-best-practices is a plugin bundle for AI coding tools published by ClickHouse. Marketplaces we read that list it: 3 (Claude Code: claude-plugins-official, Community GitHub marketplaces, Claude Code: claude-plugins-community). io.github.timescale/pg-aiguide is an MCP server published by timescale. Marketplaces we read that list it: 1 (Official MCP Registry). As of our marketplace pass on 2026-10-17. This pair was picked by a reader, not by our comparison rule, so search engines are asked not to index the page.
Where each is published
| Marketplace |  clickhouse-best-practices |  io.github.timescale/pg-aiguide |
|---|---|---|
| Claude Code: claude-plugins-official | Listed Version: 0.3.0 Forks (GitHub): 38 Stars (GitHub): 550 Not marked · First seen |
Not listed |
| Claude Code: claude-plugins-community | Listed Version: 0.3.0 Forks (GitHub): 38 Stars (GitHub): 550 Not marked · First seen |
Not listed |
| Official MCP Registry | Not listed | Listed Version: 0.6.1 Downloads/month (npm): 445 Downloads/week (npm): 53 Forks (GitHub): 121 Stars (GitHub): 1 870 Not marked · First seen |
Each figure is the marketplace's own and is never added up across marketplaces. A marketplace that publishes no figure shows none: no number is not zero.
The facts side by side
| Fact | clickhouse-best-practices | io.github.timescale/pg-aiguide |
|---|---|---|
| Marketplaces that list it (differs) | 3 (better) | 1 (worse) |
| Stars (GitHub) (differs) | 550 (worse) | 1 870 (better) |
| Forks (GitHub) (differs) | 38 (worse) | 121 (better) |
| Last release (differs) | 2026-10-16 | Not published |
| Where it runs (differs) | Installs as a plugin bundle | Remote server (mcp.tigerdata.com/docs) |
| Transport (differs) | Not stated | Streamable HTTP |
| Tools it declares | Not published | Not published |
| Environment variables it asks for (differs) | Not published | 7, secrets among them: 7 |
| Parts of the bundle (differs) | 8 | Not a bundle |
| Licence (differs) | Apache-2.0 | Not stated |
| Repository (differs) | github.com/clickhouse/agent-skills | github.com/timescale/pg-aiguide |
| Changes in the last 7 days (differs) | 1 | 0 |
| First seen | 2026-10-11 | 2026-10-11 |
| Endpoint at the last check (differs) | no remote endpoint we check | Responded 2 days ago |
Lines where the two differ have a tinted background and bold values. Where the data itself says which value is better (more marketplaces, a larger figure of the same marketplace, a fresher release, a verified mark on a marketplace that lists both), the better one is also marked green with ▲ and the worse one red with ▼. Where it runs, the transport, the tools, the settings, hooks, the bundle's parts, the licence and the week's changes are marked only as different: more or fewer is not better in itself.
What each says it does
clickhouse-best-practices
28 best practice rules for ClickHouse schema design, query optimization, and data ingestion — prioritized by impact
io.github.timescale/pg-aiguide
Comprehensive PostgreSQL documentation and best practices, including ecosystem tools
How to run each
clickhouse-best-practices As a Claude Code plugin
/plugin install clickhouse-best-practices@claude-plugins-officialio.github.timescale/pg-aiguide As a remote MCP server
claude mcp add --transport http pg-aiguide https://mcp.tigerdata.com/docsRequires: DB_SCHEMA (secret), OPENAI_API_KEY (secret), PGDATABASE (secret), PGHOST (secret), PGPASSWORD (secret), PGPORT (secret), PGUSER (secret)
Commands built only from what the marketplaces declare; the full set for every client is on each card.
Only io.github.timescale/pg-aiguide has a remote endpoint we check. How we check endpoints
Tools each declares
Neither one's marketplaces publish a list of tools, so there is nothing to compare.
Settings each asks for
The marketplaces of clickhouse-best-practices publish no settings it asks for, so we do not compare settings.
What it can do: clickhouse-best-practices · What it can do: io.github.timescale/pg-aiguide · Compare two other plugins
Data comes from the public marketplace file https://github.com/anthropics/claude-plugins-official/blob/HEAD/.claude-plugin/marketplace.json. Data comes from public marketplace files in GitHub repositories of their authors. Data comes from the public marketplace file https://github.com/anthropics/claude-plugins-community/blob/HEAD/.claude-plugin/marketplace.json. Data comes from the Official MCP Registry (registry.modelcontextprotocol.io), CC0 1.0. Figures come from our own regular passes over the marketplaces, last read on . We publish no contact details for plugin publishers.