[External Plugin]: postgres-skills

[aditivgupta]

Plugin name

postgres-skills

Short description

Expert PostgreSQL guidance and live database tools for Postgres anywhere, including local, self-hosted, containers, on-premises, AWS, Google Cloud, Azure Database for PostgreSQL, and Azure HorizonDB. Covers indexing, vector search and RAG, JSONB, partitioning, security, replication, and knowledge graphs with connection-aware guidance.

GitHub repository

microsoft/postgres-skills

Plugin path inside the repository

plugin

Ref to review

postgres-skills--v0.1.1

Commit SHA to review

d2b6108666c3ff8093e2cb417fdba0977edc15e5

Version

0.1.1

License identifier

MIT

Author name

Microsoft

Author URL

https://github.com/microsoft

Homepage URL

https://github.com/microsoft/postgres-skills

Keywords

postgresql
database
azure
pgvector
rag
apache-age
graph

Additional notes for reviewers

The plugin bundles two skills and the @microsoft/postgres-mcp stdio server. It has passing Copilot CLI compatibility, Windows/macOS/Linux MCP launch, PostgreSQL integration, manifest validation, security, and structure tests. The MCP configuration disables optional telemetry and the skills require confirmation before state-changing operations.

Submission checklist

• The plugin lives in a public GitHub repository.
• The ref and/or sha I provided is immutable (release tag and/or full 40-character commit SHA), not a branch.
• This submission follows this repository's contribution, security, and responsible AI policies.
• This plugin is not already listed in the Awesome Copilot marketplace.

[github-actions]

🛑 External plugin intake failed (submitter fixes required)

This submission passed metadata validation, but quality gates found issues that must be fixed before it can move to maintainer review. Update the issue details or source plugin and then comment /rerun-intake.

• Plugin: postgres-skills
• Repository: https://github.com/microsoft/postgres-skills
• Ref: postgres-skills--v0.1.1
• SHA: d2b6108666c3ff8093e2cb417fdba0977edc15e5

Reviewer signals

These are non-blocking heuristics for maintainer review; they are not evidence of misconduct or low quality.

Signal	Result
Repository age	126 day(s)
Repository activity	0 stars; 0 watchers
Repository counts	0 stars · 0 watchers · 2 forks · 1 open issues/PRs
Homepage heuristics	⚠️ pricing

Quality gate summary

Legend: ✅ pass · ⚠️ warning · 🛑 fail

Gate	Status
spec compliance (non-blocking)	⚠️ warning
vally lint	🛑 fail
install smoke test	🛑 fail
version match	🛑 fail
ref/sha consistency	✅ pass
canvas structure	⚪ not_run

• spec compliance: warning
• vally lint: fail
• install smoke test: fail
• version match: fail
• ref/sha consistency: pass
• canvas structure: not_run
• overall: fail

spec compliance output (⚠️ warning)

No plugin.json found in a recognized location. Agent Plugins v1.0.0 expects plugin.json at the plugin root.

vally lint output (🛑 fail)

✅ pg-graph (2/2 checks passed)
    ✓ [spec-compliance] All 1 skill(s) are spec-compliant.
        ✓ spec-compliance: All spec checks passed.
    ✓ [valid-refs] All file references across 1 skill(s) are valid.
        ✓ valid-refs: All file references resolve to existing files within the skill directory.
❌ postgresql-best-practices (1/2 checks passed, 1 failed)
    ✓ [spec-compliance] All 1 skill(s) are spec-compliant.
        ✓ spec-compliance: All spec checks passed.
    ✗ [valid-refs] 1 of 1 skill(s) have invalid file references.
        ✗ valid-refs: Found 1 invalid file reference(s): ../pg-graph/SKILL.md (outside-skill-dir) at line 122.

2 skill(s) linted, 1 passed, 1 failed

install smoke test output (🛑 fail)

Plugin installed but no plugin.json was found in any recognized location under /tmp/external-plugin-quality-2LGTJY/copilot-home/.copilot/installed-plugins/external-plugin-intake/postgres-skills

Version match output

- postgres-skills--v0.1.1: No plugin.json found at "postgres-skills--v0.1.1". Expected one of: plugin/.github/plugin/plugin.json, plugin/.plugin/plugin.json, plugin/plugin.json
- d2b6108666c3ff8093e2cb417fdba0977edc15e5: No plugin.json found at "d2b6108666c3ff8093e2cb417fdba0977edc15e5". Expected one of: plugin/.github/plugin/plugin.json, plugin/.plugin/plugin.json, plugin/plugin.json

Ref/SHA consistency output

source.ref "postgres-skills--v0.1.1" resolves to the same commit as source.sha "d2b6108666c3ff8093e2cb417fdba0977edc15e5".

Canvas structure output

Canvas structure gate skipped because plugin is not tagged with "canvas".

Canonical external.json payload

{
  "name": "postgres-skills",
  "description": "Expert PostgreSQL guidance and live database tools for Postgres anywhere, including local, self-hosted, containers, on-premises, AWS, Google Cloud, Azure Database for PostgreSQL, and Azure HorizonDB. Covers indexing, vector search and RAG, JSONB, partitioning, security, replication, and knowledge graphs with connection-aware guidance.",
  "version": "0.1.1",
  "author": {
    "name": "Microsoft",
    "url": "https://github.com/microsoft"
  },
  "repository": "https://github.com/microsoft/postgres-skills",
  "homepage": "https://github.com/microsoft/postgres-skills",
  "license": "MIT",
  "keywords": [
    "postgresql",
    "database",
    "azure",
    "pgvector",
    "rag",
    "apache-age",
    "graph"
  ],
  "source": {
    "source": "github",
    "repo": "microsoft/postgres-skills",
    "path": "plugin",
    "ref": "postgres-skills--v0.1.1",
    "sha": "d2b6108666c3ff8093e2cb417fdba0977edc15e5"
  }
}

View workflow run