updated 2026-10-16 16:07 UTC

Pg Aiguide

Repository

MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.

Agent Skills Python Listed Apache-2.0

Is Pg Aiguide safe? Strong public trust posture, backed by multiple independent signals.

OSSF Scorecard 5.4 / 10
Provenance Attested
Signed commits 90%
Last push 2d ago
Advisories None known
Compare Pg Aiguide

How does it stack up against its Agent Skills neighbours?

Pick any agent to compare →
Suggest a correction

In detail: Pg Aiguide scores 81.0/100 (Grade A), ranked #17 of 385 tracked open-source AI agent projects, on evidence coverage B (3 of 5 independent signal types). The public evidence: its packages ship with cryptographic provenance; OSSF Scorecard rates its supply-chain practices 5.4/10; 90% of recent commits are signed; no published advisory affects its latest release (@tigerdata/pg-aiguide); last pushed 2026-10-14. Every point is earned from checkable signals — never paid placement. How scoring works →

How Pg Aiguide could raise its score

Each line changes one public signal and recomputes with the live scoring function. The gains don't add up exactly, because the score is capped near the top.

Already done? Suggest a correctionAdd the trust badge

Chain of custody

Scanners check what the code says. This traces who ships Pg Aiguide and whether that has changed: from the source repository, through how changes are reviewed and released, to the package you install. These are the checks for OWASP ASI04 Agentic Supply Chain Vulnerabilities and, for skills, AST02 Supply Chain Compromise.

  1. Source Signed

    github.com/timescale/pg-aiguide, Apache-2.0, last pushed 2026-10-14. 90% of the last 100 commits carry a verified signature, so changes trace to a verified account.

  2. Review and release Mixed

    OpenSSF Scorecard rates the repository's practices 5.4/10 (scanned Oct 15, 2026). The checks that decide who can get a change released:

    • Code Review5
    • Branch Protection5
    • Signed Releasesn/a
    • Dangerous Workflow10
    • Token Permissions0
    • Pinned Dependencies0
    All 18 Scorecard checks
    Binary-Artifacts 10
    Branch-Protection 5
    CI-Tests 10
    CII-Best-Practices 0
    Code-Review 5
    Contributors 10
    Dangerous-Workflow 10
    Dependency-Update-Tool 10
    Fuzzing 0
    License 10
    Maintained 10
    Packaging 10
    Pinned-Dependencies 0
    SAST 0
    Security-Policy 0
    Signed-Releases -1
    Token-Permissions 0
    Vulnerabilities 0

  3. Published packages Linked and attested

  4. What you install today No known advisories

    Latest release checked: @tigerdata/pg-aiguide 0.6.1. No published advisory affects it (OSV, checked 2026-10-16).

Changes to this chain

  • 2026-09-23 Package provenance attestation detected
  • 2026-08-29 OSSF Scorecard: 4.8/10

Evidence behind this score

Coverage B: 3 of 5 independent evidence types found.

  • GitHub repository data
  • Package downloads
  • Supply-chain checks
  • Public actions (missing)
  • Community mentions (missing)

Verify this score yourself

Every build re-issues Pg Aiguide’s score as an Ed25519-signed credential, valid for 7 days. You can check it offline against HVTracker’s published key; if anyone changes a number after signing, verification fails.

Signed credential (JSON) How to verify

What this score doesn’t check

It covers who ships the code, not what the code does. It doesn’t read the skill’s instructions for injected instructions, watch runtime behaviour, or find bugs nobody has disclosed yet. For that, run a content scanner before you install it, such as Cisco Skill Scanner.

How Pg Aiguide compares in Agent Skills

  1. #15 Antigravity Sdk Python 82.8 +1.8
  2. #16 DSH Better Sidebar 81.3 +0.3
  3. #17 Pg Aiguide 81.0 this agent
  4. #18 Modlens 80.8 −0.2
  5. #19 Dsh Agent Teams 78.1 −2.9

Bars show each HVTrust score; the tick marks Pg Aiguide’s 81.0.

Where the 81.0 comes from

HVTrust dimensions vs the Agent Skills average

81.0 / 100 · 100.0% confidence

Pg Aiguide Agent Skills average (385 agents)

Safety / Integrity50% OSSF Scorecard · 30% provenance · 20% signed commits
18.8 / 25
11.0 above avg 7.8
Identity / Provenance60% listing status · 40% build provenance
18.0 / 18
6.6 above avg 11.4
Transparency50% declared license · 50% OSSF Scorecard
13.1 / 17
1.1 above avg 12.0
Maintenance60% last-push freshness · 40% commit activity
16.0 / 20
1.9 above avg 14.1
AdoptionLog-scaled stars · package downloads
10.2 / 20
1.2 above avg 9.0

Quick Trust Read

What Would Improve It
Improve adoption to lift the weakest part of the trust profile.
Recent Changes
2026-09-24
Tool Surface Changed
Detected tool/plugin surface changed: none → declared
2026-09-24
Provider Added
Runtime surface grew — new detected provider dependencies: OpenAI, Postgres
2026-09-23
Mcp Status Changed
Detected MCP server support changed: none → implemented
Maintainer Checklist
Raise Scorecard signals Current OSSF Scorecard is 5.4/10. Tighten the weakest checks to improve public safety evidence.
Compare with another agent Get email alerts for Pg Aiguide View Agent Skills Report missing data
67.2
Activity sub-score · out of 100
#17
In Agent Skills

How to read this: HVTrust (0–100) weighs supply-chain signals (provenance, OSSF Scorecard, signed commits, open license) alongside real-world adoption. Grade A reflects the trust score band: A ≥ 80, B ≥ 65, C ≥ 50, D < 50. Evidence coverage B is separate — it grades how many independent signal types back the score (3 of 5), so a high score on thin evidence stays visible. Full methodology →

Signals refreshed 2026-10-16 16:07 UTC · Repo last pushed 2 days ago

Rank Trend

2026-09-29 2026-10-16

Activity & Reach

Stars
1.9k
Forks
119
Last Push
2026-10-14
2 days ago
Commits (4 wk)
10
Downloads (7d)
52
npm
HN mentions (30d)
—
Open Issues
4
Rank Change
=
was #17

Analysis

Activity Inputs

67.2 / 100
StarsRepository reach
19.6 / 30
FreshnessLast push recency
24.7 / 25
ActivityRecent commits
13.0 / 25
CommunityFork signal
9.7 / 20

Common questions about Pg Aiguide

Public supply-chain signals for Pg Aiguide are strong: it has multiple independent trust indicators in place. This does not replace your own security review, but Pg Aiguide carries less obvious unverified-evidence risk than projects with thin signals.
Does Pg Aiguide publish package provenance?
Yes. Pg Aiguide's package releases carry build provenance attestations, which cryptographically link the published package back to its source repository and CI workflow.
Does Pg Aiguide have an OpenSSF Scorecard?
Pg Aiguide has an OpenSSF Scorecard score of 5.4/10. The Scorecard checks for branch protection, signed releases, dependency updates, fuzzing, code review, and other supply-chain hygiene items. See the full check breakdown on this page.
Is Pg Aiguide actively maintained?
Actively maintained. The repository was pushed to within the last 2 day(s).
What license does Pg Aiguide use?
Pg Aiguide ships under Apache-2.0. A declared, OSI-approved license is one of the transparency signals HVTrust scores.
Are Pg Aiguide's commits signed?
90% of the last 100 commits to Pg Aiguide are verified-signed (GPG, SSH, S/MIME, or GitHub's signing flow). Signed commits help confirm that code was authored by who the commit claims.

Not a safety endorsement. HVTracker describes what public signals show, not whether a project is safe for your use case. Run your own security review before adopting in production.

AI agent surface

MCP, providers, tool surface
Scored in HVTrust

These runtime-trust fields — detected from public repo docs and manifests — contribute a bounded adjustment to this project's HVTrust score alongside supply-chain evidence. The exact values each field can add or subtract are documented in the methodology → Compare this surface across every listed agent in the capability matrix →

MCP Server Support
high confidence
Implemented
Pg Aiguide appears to expose MCP server capabilities.
Detailed evidence is not shown in the public view.
External Service Dependencies
high confidence
2 detected
Public provider/service dependencies detected.
Credential signal: No explicit API-key/config marker detected.
Tool / Plugin Surface
high confidence
Declared
Declared plugin/integration surface detected.
  • database
Detailed evidence is not shown in the public view.
Package Provenance Drift
high confidence
Match
Published package metadata matches the tracked repo
Detailed evidence is not shown in the public view.
  • MCP signal live
  • External deps live
  • Tool / plugin surface live
  • Package provenance drift live
How this surface has changed

Detected changes to Pg Aiguide's runtime surface and supply-chain posture, from daily public-signal snapshots. A change here means our detectors see something different — a genuinely changed capability, or better evidence of an existing one.

2026-09-24
Tool Surface Changed
Detected tool/plugin surface changed: none → declared
2026-09-24
Provider Added
Runtime surface grew — new detected provider dependencies: OpenAI, Postgres
2026-09-23
Mcp Status Changed
Detected MCP server support changed: none → implemented
2026-09-23
Provenance Added
Package provenance attestation detected

Maintain Pg Aiguide?

For maintainers

HVTrust scores Pg Aiguide from public signals only — we never contact maintainers first. If a signal is wrong, stale, or missing (provenance you publish, a Scorecard you run, signed releases), tell us and we'll review it. Corrections are public and tracked on GitHub.

Submit a correction → Add the trust badge

Reputation Timeline

Signal history
HVTrust 4Rank 3Grade 3Listed 2Score 2Scorecard 1Delisted 1Provenance 1MCP 1Surface 1Surface 1
2026-09-24
Tool Surface Changed
Detected tool/plugin surface changed: none → declared
2026-09-24
Provider Added
Runtime surface grew — new detected provider dependencies: OpenAI, Postgres
2026-09-23
Mcp Status Changed
Detected MCP server support changed: none → implemented
2026-09-23
Provenance Added
Package provenance attestation detected
2026-09-23
Grade Changed
Trust grade D → A
2026-09-23
Rank Moved
Rank rose 245 spots (#254 → #9)
2026-09-23
HVTrust Changed
HVTrust up 53.3pts (31.7 → 85.0)
2026-09-22
Newly Listed
First tracked at rank #254
2026-09-21
Removed From Active Tracking
Removed from active tracking
2026-09-07
HVTrust Changed
HVTrust up 3.1pts (80.6 → 83.7)
2026-09-02
Grade Changed
Trust grade B → A
2026-09-01
Activity Score Changed
Activity score up 6pts (58 → 64)
2026-08-29
Scorecard Added
OSSF Scorecard: 4.8/10
2026-08-29
Rank Moved
Rank rose 13 spots (#21 → #8)
2026-08-29
HVTrust Changed
HVTrust up 10.1pts (65.4 → 75.5)
2026-08-27
Grade Changed
Trust grade C → B
2026-08-27
HVTrust Changed
HVTrust up 4.1pts (61.4 → 65.5)
2026-08-27
Activity Score Changed
Activity score up 8pts (46 → 54)
2026-08-26
Rank Moved
Rank dropped 17 spots (#9 → #26)
2026-08-11
Newly Listed
First tracked at rank #6
GitHub → npm: @tigerdata/pg-aiguide

Embed Badge Badge guide for maintainers →

For maintainers
HVTrust 81.0 Grade A
Markdown:
[![HVTrust](https://hvtracker.net/badge/pg-aiguide.svg)](https://hvtracker.net/agents/pg-aiguide)
HTML:
<a href="https://hvtracker.net/agents/pg-aiguide"><img src="https://hvtracker.net/badge/pg-aiguide.svg" alt="HVTrust"></a>

Other agents in Agent Skills

Data sources
GitHub REST API (repo, commits, stars, forks, license) · npm Registry (downloads, provenance) · OpenSSF Scorecard CLI
Each agent's signals refresh once daily across 6 staggered batches. Methodology v4.4 · Raw JSON