{"slug":"pgplex-pgschema","name":"Pgschema","description":"Terraform-style, declarative Postgres schema migration. Agent friendly.","tagline":"Terraform-style, declarative Postgres schema migration. Agent friendly.","category":"devops","tags":["terraform","infrastructure","devops","cicd","cli","ddl","gitops","multi-tenant","postgres","postgresql"],"author":{"name":"pgplex","verified":false,"url":"https://github.com/pgplex"},"attribution":{"status":"community_indexed","statusLabel":"Community indexed","shortLabel":"COMMUNITY INDEXED","sourceLabel":"GitHub star discovery","sourceDetail":"pgplex/pgschema","creatorName":"pgplex","creatorUrl":"https://github.com/pgplex","sourceUrl":"https://github.com/pgplex/pgschema","indexedBy":"OpenAgentSkill community index","claimUrl":"https://www.openagentskill.com/skills/pgplex-pgschema#claim-this-skill","claimCta":"Claim this skill","trustNote":"This listing was indexed from public sources and is not marked official until a maintainer claim is approved.","publicNote":"Attribution links to the public repository or creator profile. Creators can claim the listing to update ownership signals."},"stats":{"stars":948,"forks":56,"downloads":0,"rating":0,"review_count":0,"quality_score":54.54},"quality":{"score":87,"tier":"excellent","label":"Excellent","summary":"High-confidence pick with strong adoption and healthy maintenance signals.","signals":[{"label":"GitHub stars","value":"948","tone":"positive"},{"label":"Freshness","value":"5d ago","tone":"positive"},{"label":"Install ready","value":"Yes","tone":"positive"},{"label":"License","value":"Apache-2.0","tone":"neutral"}],"warnings":[]},"trust":{"version":"trust-score-v2","score":83,"tier":"strong","label":"Strong shortlist","summary":"Good trust signals with a few areas worth checking before rollout.","recommendedAction":"Test in a sandbox workflow and compare its install path with close alternatives.","dimensions":[{"id":"github_adoption","label":"GitHub adoption","score":76,"weight":0.16,"status":"info","detail":"948 GitHub stars"},{"id":"maintenance","label":"Recent maintenance","score":100,"weight":0.18,"status":"pass","detail":"5d since push"},{"id":"license","label":"License clarity","score":86,"weight":0.1,"status":"pass","detail":"Apache-2.0"},{"id":"documentation","label":"README/SKILL.md completeness","score":74,"weight":0.16,"status":"info","detail":"Public metadata needs stronger README/SKILL.md context"},{"id":"dependency_risk","label":"Dependency risk","score":64,"weight":0.14,"status":"info","detail":"command execution surface, database surface"},{"id":"installability","label":"Install availability","score":92,"weight":0.14,"status":"pass","detail":"npx skills add pgplex/pgschema"},{"id":"repository","label":"Repository evidence","score":86,"weight":0.06,"status":"pass","detail":"https://github.com/pgplex/pgschema"},{"id":"review_status","label":"Review status","score":88,"weight":0.06,"status":"pass","detail":"AI review data available"}],"checks":[{"status":"info","label":"GitHub adoption","detail":"948 GitHub stars"},{"status":"pass","label":"Recent maintenance","detail":"5d since push"},{"status":"pass","label":"License clarity","detail":"Apache-2.0"},{"status":"info","label":"README/SKILL.md completeness","detail":"Public metadata needs stronger README/SKILL.md context"},{"status":"info","label":"Dependency risk","detail":"command execution surface, database surface"},{"status":"pass","label":"Install availability","detail":"npx skills add pgplex/pgschema"},{"status":"pass","label":"Repository evidence","detail":"https://github.com/pgplex/pgschema"},{"status":"pass","label":"Review status","detail":"AI review data available"},{"status":"warn","label":"Ownership","detail":"No approved owner claim yet"},{"status":"info","label":"OpenAgentSkill usage","detail":"No local usage activity yet"}],"strengths":["AI review approved","Install path is available","Repository evidence is available","Recently maintained repository","Meaningful GitHub adoption signal"],"warnings":["Quality score needs review"],"evidence":{"stars":"948 GitHub stars","lastPushed":"5d since push","license":"Apache-2.0","repository":"https://github.com/pgplex/pgschema","install":"npx skills add pgplex/pgschema","documentation":"Usable metadata, review docs"},"installReadiness":{"ready":true,"command":"npx skills add pgplex/pgschema","policy":"human_review_before_install","label":"Human review before install","notes":["Install path is available","Repository evidence is available","License is declared","5d since push"]},"agentCompatibility":["Go","Terraform","Codex","Claude Code","Cursor","OpenAgentSkill CLI"],"riskSummary":{"level":"low","label":"Low metadata risk","notes":["Quality score needs review"]}},"safety":{"score":57,"level":"review_before_install","label":"Review before install","safety_tier":{"tier":"experimental","label":"Experimental","badge":"EXPERIMENTAL","summary":"Sparse or mixed signals. Useful for discovery, but not for autonomous installation.","recommended_action":"Test manually in an isolated workspace and compare against safer alternatives.","auto_install_policy":"review","reasons":["High-risk permission hints: Shell or command execution","57/100 agent safety score"]},"auto_install_allowed":false,"human_review_required":true,"blocked":false,"audit_risk":"safe_to_try","permission_hints":[{"id":"shell","label":"Shell or command execution","reason":"Skill metadata references terminal, CLI, shell, subprocess, or command execution workflows.","severity":"high"},{"id":"network","label":"Network access","reason":"Skill likely fetches remote pages, APIs, repositories, or external services.","severity":"medium"},{"id":"filesystem","label":"Filesystem access","reason":"Skill may read or write project files, documents, generated artifacts, or local workspace state.","severity":"medium"},{"id":"database","label":"Database access","reason":"Skill may inspect schemas, query databases, or work with persistent stores.","severity":"medium"}],"policy_warnings":["High-risk permission hints: Shell or command execution","Quality score needs review"],"constraints_applied":{"max_risk":"medium","needs_install_command":true,"min_stars":0}},"safety_gate":{"tier":"experimental","label":"Experimental","badge":"EXPERIMENTAL","auto_install_policy":"review","auto_install_allowed":false,"human_review_required":true,"blocked":false,"recommended_action":"Test manually in an isolated workspace and compare against safer alternatives.","reasons":["High-risk permission hints: Shell or command execution","57/100 agent safety score"]},"supply_profile":{"track":{"slug":"coding","label":"Coding and developer agents","shortLabel":"Coding","description":"Code review, repo analysis, testing, CI, GitHub, DevOps, and developer workflow skills."},"scenario":{"label":"Database and SQL","description":"I need my agent to inspect database schemas, write SQL, and explain query results.","useCases":[{"slug":"database-sql","title":"Database and SQL"},{"slug":"github-automation","title":"GitHub automation"},{"slug":"coding-agents","title":"Coding agents"}]},"applicableAgents":["Claude Code","CLI","Codex","Cursor","Go"],"install":{"ready":true,"command":"npx skills add pgplex/pgschema","primaryTarget":"CLI","targetCount":4},"githubQuality":{"stars":948,"starsLabel":"948","forks":56,"license":"Apache-2.0","qualityScore":87,"trustScore":83,"auditScore":89},"maintenance":{"status":"fresh","label":"5d since push","daysSincePush":5,"lastPushedAt":"2026-06-10T16:48:11+00:00"},"risk":{"level":"safe_to_try","label":"Safe to try","requiresReview":true,"notes":["Quality score needs review"]},"coverageTags":["Coding","Database and SQL","devops","terraform","infrastructure","cicd","cli","ddl"]},"audit":{"audit_score":89,"risk_level":"safe_to_try","risk_label":"Safe to try","warnings":["Quality score needs review"]},"decision":{"readiness_score":98,"readiness_label":"Production-ready","headline":"Primary pick for Database and SQL","role":"Primary pick","primary_fit":"Database and SQL","best_for":["Database and SQL workflows","Claude Code teams","teams that value GitHub adoption signals"],"risks":["No OpenAgentSkill engagement data yet"],"next_steps":["Install it in a sandbox agent and run one Database and SQL task end to end.","Compare output quality, latency, and failure behavior against at least one alternative.","Promote it into production only after reviewing repository permissions, license, and maintenance signals."]},"platforms":["Go","Terraform","Claude Code"],"use_cases":[{"slug":"database-sql","title":"Database and SQL","url":"https://www.openagentskill.com/use-cases/database-sql"},{"slug":"github-automation","title":"GitHub automation","url":"https://www.openagentskill.com/use-cases/github-automation"},{"slug":"coding-agents","title":"Coding agents","url":"https://www.openagentskill.com/use-cases/coding-agents"},{"slug":"rag-knowledge","title":"RAG and knowledge","url":"https://www.openagentskill.com/use-cases/rag-knowledge"}],"install":"npx skills add pgplex/pgschema","install_targets":[{"id":"openagentskill-cli","label":"CLI","title":"OpenAgentSkill CLI","kind":"command","value":"npx skills add pgplex/pgschema","description":"Use the registry command when your workflow supports the OpenAgentSkill installer.","copyLabel":"Copy command"},{"id":"codex","label":"Codex","title":"Codex install prompt","kind":"agent-prompt","value":"Install the \"Pgschema\" agent skill from https://github.com/pgplex/pgschema. Read its SKILL.md or equivalent instructions first, install only the files needed for this workspace, and summarize any required setup before using it. Skill purpose: Terraform-style, declarative Postgres schema migration. Agent friendly.","description":"Give Codex a repo-aware install prompt when the skill is not available through a local CLI.","copyLabel":"Copy prompt"},{"id":"claude-code","label":"Claude Code","title":"Claude Code skill prompt","kind":"agent-prompt","value":"Add \"Pgschema\" as a Claude Code skill from https://github.com/pgplex/pgschema. Inspect the skill instructions, place the reusable skill files in the appropriate local skills location for this project, and report the activation steps. Skill purpose: Terraform-style, declarative Postgres schema migration. Agent friendly.","description":"Use this prompt to ask Claude Code to add the skill and explain the local activation steps.","copyLabel":"Copy prompt"},{"id":"cursor","label":"Cursor","title":"Cursor rule prompt","kind":"agent-prompt","value":"Turn \"Pgschema\" from https://github.com/pgplex/pgschema into a reusable Cursor project rule or agent instruction. Preserve the core workflow, adapt paths to this repo, and keep the rule scoped to tasks where it is relevant. Skill purpose: Terraform-style, declarative Postgres schema migration. Agent friendly.","description":"Use this when installing as Cursor project rules or reusable agent instructions.","copyLabel":"Copy prompt"}],"repository":"https://github.com/pgplex/pgschema","github_repo":"pgplex/pgschema","version":"1.0.0","license":"Apache-2.0","updated_at":"2026-06-16T08:54:13.354961+00:00","canonical_key":"pgplex/pgschema","recommendation_reasons":["Useful GitHub adoption: 948 stars","Install handoff is available","Repository freshness signal is available"],"urls":{"web":"https://www.openagentskill.com/skills/pgplex-pgschema","api":"https://www.openagentskill.com/api/agent/skills/pgplex-pgschema","install_api":"https://www.openagentskill.com/api/skills/pgplex-pgschema/install","audit":"https://www.openagentskill.com/skills/pgplex-pgschema/audit","repository":"https://github.com/pgplex/pgschema"},"meta":{"endpoint":"/api/registry/manifest/{slug}","canonical_agent_endpoint":"/api/agent/skills/pgplex-pgschema","agent_friendly":true,"api_version":"1.0","generated_at":"2026-06-16T13:17:12.396Z"}}