{"slug":"public-transport-gtfs-via-postgres","name":"Gtfs Via Postgres","description":"Analyse GTFS Schedule data by importing it into a PostgreSQL database.","tagline":"Analyse GTFS Schedule data by importing it into a PostgreSQL database.","category":"data-analysis","tags":["sql","data-analysis","data","gtfs","gtfs-schedule","gtfs-static","postgres","postgresql","public-transport","public-transportation"],"author":{"name":"public-transport","verified":false,"url":"https://github.com/public-transport"},"attribution":{"status":"community_indexed","statusLabel":"Community indexed","shortLabel":"COMMUNITY INDEXED","sourceLabel":"GitHub star discovery","sourceDetail":"public-transport/gtfs-via-postgres","creatorName":"public-transport","creatorUrl":"https://github.com/public-transport","sourceUrl":"https://github.com/public-transport/gtfs-via-postgres","indexedBy":"OpenAgentSkill community index","claimUrl":"https://www.openagentskill.com/skills/public-transport-gtfs-via-postgres#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":141,"forks":21,"downloads":0,"rating":0,"review_count":0,"quality_score":41.77},"quality":{"score":64,"tier":"promising","label":"Promising","summary":"Useful candidate, but compare it with alternatives before adopting.","signals":[{"label":"GitHub stars","value":"141","tone":"neutral"},{"label":"Freshness","value":"4mo ago","tone":"positive"},{"label":"Install ready","value":"Yes","tone":"positive"},{"label":"License","value":"Unknown","tone":"neutral"}],"warnings":[]},"trust":{"version":"trust-score-v4","score":72,"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":62,"weight":0.13,"status":"info","detail":"141 GitHub stars"},{"id":"repo_activity","label":"Stars/forks activity","score":57,"weight":0.08,"status":"warn","detail":"141 stars, 21 forks; issue activity unavailable in current metadata"},{"id":"maintenance","label":"Recent maintenance","score":76,"weight":0.14,"status":"info","detail":"4mo since push"},{"id":"license","label":"License clarity","score":42,"weight":0.09,"status":"warn","detail":"Unknown"},{"id":"documentation","label":"README/SKILL.md completeness","score":74,"weight":0.14,"status":"info","detail":"Public metadata needs stronger README/SKILL.md context"},{"id":"dependency_risk","label":"Dependency/runtime risk","score":82,"weight":0.12,"status":"pass","detail":"database surface"},{"id":"installability","label":"Install availability","score":92,"weight":0.1,"status":"pass","detail":"npx skills add public-transport/gtfs-via-postgres"},{"id":"install_safety","label":"Install command safety","score":92,"weight":0.1,"status":"pass","detail":"standard package or runtime install path"},{"id":"permission_surface","label":"Permission surface","score":74,"weight":0.07,"status":"info","detail":"filesystem or document access, database access"},{"id":"repository","label":"Repository evidence","score":86,"weight":0.04,"status":"pass","detail":"https://github.com/public-transport/gtfs-via-postgres"},{"id":"review_status","label":"Review status","score":88,"weight":0.05,"status":"pass","detail":"AI review data available"},{"id":"agent_outcomes","label":"Agent Proven outcomes","score":54,"weight":0.13,"status":"info","detail":"No agent outcome data yet"}],"checks":[{"status":"info","label":"GitHub adoption","detail":"141 GitHub stars"},{"status":"warn","label":"Stars/forks activity","detail":"141 stars, 21 forks; issue activity unavailable in current metadata"},{"status":"info","label":"Recent maintenance","detail":"4mo since push"},{"status":"warn","label":"License clarity","detail":"Unknown"},{"status":"info","label":"README/SKILL.md completeness","detail":"Public metadata needs stronger README/SKILL.md context"},{"status":"pass","label":"Dependency/runtime risk","detail":"database surface"},{"status":"pass","label":"Install availability","detail":"npx skills add public-transport/gtfs-via-postgres"},{"status":"pass","label":"Install command safety","detail":"standard package or runtime install path"},{"status":"info","label":"Permission surface","detail":"filesystem or document access, database access"},{"status":"pass","label":"Repository evidence","detail":"https://github.com/public-transport/gtfs-via-postgres"},{"status":"pass","label":"Review status","detail":"AI review data available"},{"status":"info","label":"Agent Proven outcomes","detail":"No agent outcome data yet"},{"status":"warn","label":"Ownership","detail":"No approved owner claim yet"},{"status":"info","label":"OpenAgentSkill usage","detail":"No local usage activity yet"},{"status":"info","label":"Agent outcomes","detail":"No agent outcome data yet"}],"strengths":["AI review approved","Install path is available","Repository evidence is available","Install command has no obvious high-risk pattern"],"warnings":["License is unclear","Quality score needs review","Stars/forks activity: 141 stars, 21 forks; issue activity unavailable in current metadata","License clarity: Unknown"],"evidence":{"stars":"141 GitHub stars","repoActivity":"141 stars, 21 forks","lastPushed":"4mo since push","license":"Unknown","repository":"https://github.com/public-transport/gtfs-via-postgres","install":"npx skills add public-transport/gtfs-via-postgres","installSafety":"standard package or runtime install path","permissionSurface":"filesystem or document access, database access","documentation":"Usable metadata, review docs","agentOutcomes":"No agent outcome data yet"},"installReadiness":{"ready":true,"command":"npx skills add public-transport/gtfs-via-postgres","policy":"human_review_before_install","label":"Human review before install","notes":["Install path is available","Repository evidence is available","License is unclear","No Agent Proven outcome evidence yet","4mo since push"]},"agentCompatibility":["JavaScript","SQL","Codex","Claude Code","Cursor","OpenAgentSkill CLI"],"riskSummary":{"level":"medium","label":"Review before production","notes":["License is unclear","Quality score needs review","Stars/forks activity: 141 stars, 21 forks; issue activity unavailable in current metadata","License clarity: Unknown"]},"outcomeEvidence":{"total":0,"successes":0,"failures":0,"notRelevant":0,"successRate":null,"installAttempts":0,"riskBlocked":0,"setupRequired":0,"installSuccessRate":null,"avgOutputQuality":null,"avgTimeToUsefulMs":null,"productionOutcomes":0,"humanReviewRequired":0,"recentSuccessRate":null,"recentFailureRate":null,"uniqueAgents":0,"agentProvenScore":0,"agentProvenLabel":"Needs first agent run","lastOutcomeAt":null,"label":"No agent outcome data yet"},"autoInstall":{"allowed":false,"sandboxRequired":true,"policy":"human_review_before_install","reason":"Human review or sandbox validation is required before automatic installation."},"bestFor":["data-analysis","sql","data","gtfs","gtfs-schedule","gtfs-static"],"doNotUseFor":["Production credentials, payments, or irreversible account changes without explicit human review","Sensitive private data before reviewing repository code, license, and permission surface","Automatic installation in a production workspace","Commercial reuse before clarifying license terms"],"knownRisks":["License is unclear","Quality score needs review","Stars/forks activity: 141 stars, 21 forks; issue activity unavailable in current metadata","License clarity: Unknown"]},"safety":{"score":54,"level":"avoid_auto_install","label":"Avoid automatic 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":["License is unclear","54/100 agent safety score"]},"auto_install_allowed":false,"human_review_required":true,"blocked":false,"audit_risk":"needs_review","permission_hints":[{"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":["License is unclear"],"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":["License is unclear","54/100 agent safety score"]},"supply_profile":{"track":{"slug":"data","label":"Data, BI, and analytics","shortLabel":"Data","description":"CSV, SQL, notebooks, dashboards, data pipelines, BI, ETL, and spreadsheet analysis."},"scenario":{"label":"Database and SQL","description":"I need my agent to inspect database schemas, write SQL, and explain query results.","useCases":[{"slug":"workflow-automation","title":"Workflow automation"},{"slug":"database-sql","title":"Database and SQL"},{"slug":"coding-agents","title":"Coding agents"}]},"applicableAgents":["Claude Code","CLI","Codex","Cursor","JavaScript"],"install":{"ready":true,"command":"npx skills add public-transport/gtfs-via-postgres","primaryTarget":"CLI","targetCount":4},"githubQuality":{"stars":141,"starsLabel":"141","forks":21,"license":"Unknown","qualityScore":64,"trustScore":72,"auditScore":74},"maintenance":{"status":"active","label":"4mo since push","daysSincePush":132,"lastPushedAt":"2026-02-21T17:12:39+00:00"},"risk":{"level":"needs_review","label":"Needs review","requiresReview":true,"notes":["License is unclear","Quality score needs review","Stars/forks activity: 141 stars, 21 forks; issue activity unavailable in current metadata","License clarity: Unknown","Needs review"]},"coverageTags":["Data","Database and SQL","data-analysis","sql","gtfs","gtfs-schedule","gtfs-static","postgres"]},"audit":{"audit_score":74,"risk_level":"needs_review","risk_label":"Needs review","warnings":["License is unclear","Quality score needs review","Stars/forks activity: 141 stars, 21 forks; issue activity unavailable in current metadata","License clarity: Unknown"]},"decision":{"readiness_score":63,"readiness_label":"Prototype first","headline":"Fallback candidate for Workflow automation","role":"Fallback candidate","primary_fit":"Workflow automation","best_for":["Workflow automation workflows","Claude Code teams","builders willing to evaluate younger projects"],"risks":["No OpenAgentSkill engagement data yet"],"next_steps":["Install it in a sandbox agent and run one Workflow automation 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."]},"agent_readable_metadata":{"version":"openagentskill-agent-metadata-v2","skill":{"slug":"public-transport-gtfs-via-postgres","name":"Gtfs Via Postgres","description":"Analyse GTFS Schedule data by importing it into a PostgreSQL database.","category":"data-analysis","url":"https://www.openagentskill.com/skills/public-transport-gtfs-via-postgres","repository":"https://github.com/public-transport/gtfs-via-postgres","github_repo":"public-transport/gtfs-via-postgres"},"suited_tasks":["Workflow automation workflows","Claude Code teams","builders willing to evaluate younger projects","Move data between tools","Transform files","Trigger repeatable actions","Understand table relationships","Write safer queries"],"suited_agents":["JavaScript","SQL","Codex","Claude Code","Cursor","OpenAgentSkill CLI","CLI"],"install":{"command":"npx skills add public-transport/gtfs-via-postgres","ready":true,"targets":[{"id":"openagentskill-cli","label":"CLI","kind":"command","value":"npx skills add public-transport/gtfs-via-postgres"},{"id":"codex","label":"Codex","kind":"agent-prompt","value":"Install the \"Gtfs Via Postgres\" agent skill from https://github.com/public-transport/gtfs-via-postgres. 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: Analyse GTFS Schedule data by importing it into a PostgreSQL database."},{"id":"claude-code","label":"Claude Code","kind":"agent-prompt","value":"Add \"Gtfs Via Postgres\" as a Claude Code skill from https://github.com/public-transport/gtfs-via-postgres. 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: Analyse GTFS Schedule data by importing it into a PostgreSQL database."},{"id":"cursor","label":"Cursor","kind":"agent-prompt","value":"Turn \"Gtfs Via Postgres\" from https://github.com/public-transport/gtfs-via-postgres 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: Analyse GTFS Schedule data by importing it into a PostgreSQL database."}],"handoff_url":"https://www.openagentskill.com/api/skills/public-transport-gtfs-via-postgres/install","manifest_url":"https://www.openagentskill.com/api/registry/manifest/public-transport-gtfs-via-postgres"},"trust":{"score":72,"label":"Strong shortlist","version":"trust-score-v4","install_policy":"human_review_before_install","evidence":{"stars":"141 GitHub stars","repoActivity":"141 stars, 21 forks","lastPushed":"4mo since push","license":"Unknown","repository":"https://github.com/public-transport/gtfs-via-postgres","install":"npx skills add public-transport/gtfs-via-postgres","installSafety":"standard package or runtime install path","permissionSurface":"filesystem or document access, database access","documentation":"Usable metadata, review docs","agentOutcomes":"No agent outcome data yet"},"outcome_evidence":{"total":0,"successes":0,"failures":0,"not_relevant":0,"success_rate":null,"recent_success_rate":null,"recent_failure_rate":null,"install_attempts":0,"install_success_rate":null,"risk_blocked":0,"setup_required":0,"avg_output_quality":null,"production_outcomes":0,"last_outcome_at":null,"label":"No agent outcome data yet"},"auto_install":{"allowed":false,"sandbox_required":true,"reason":"Human review or sandbox validation is required before automatic installation."},"best_for":["data-analysis","sql","data","gtfs","gtfs-schedule","gtfs-static"],"known_risks":["License is unclear","Quality score needs review","Stars/forks activity: 141 stars, 21 forks; issue activity unavailable in current metadata","License clarity: Unknown"]},"agent_proven":{"version":"agent-proven-v1","score":0,"tier":"unproven","label":"Needs first agent run","summary":"No agent outcome reports yet. Use Resolve, run one narrow sandbox task, then report the result.","metrics":{"totalOutcomes":0,"successfulOutcomes":0,"failedOutcomes":0,"installAttempts":0,"installSuccessRate":null,"successRate":null,"recentSuccessRate":null,"recentFailureRate":null,"riskBlocked":0,"setupRequired":0,"notRelevant":0,"avgOutputQuality":null,"avgTimeToUsefulMs":null,"productionOutcomes":0,"humanReviewRequired":0,"uniqueAgents":0,"lastOutcomeAt":null},"signals":[],"penalties":["No real agent outcome evidence yet"]},"audit":{"score":74,"risk_level":"needs_review","risk_label":"Needs review","warnings":["License is unclear","Quality score needs review","Stars/forks activity: 141 stars, 21 forks; issue activity unavailable in current metadata","License clarity: Unknown"]},"safety_gate":{"tier":"experimental","label":"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."},"quality":{"score":64,"label":"Promising"},"supply":{"track":"Data, BI, and analytics","scenario":"Database and SQL","maintenance":"4mo since push","risk":"Needs review"},"alternative_skills":[],"do_not_use_when":["teams that need a vendor-supported SLA","high-compliance environments without internal security review","No OpenAgentSkill engagement data yet","License is unclear","Quality score needs review","Stars/forks activity: 141 stars, 21 forks; issue activity unavailable in current metadata","License clarity: Unknown","Production credentials, payments, or irreversible account changes without explicit human review"],"agent_contract":{"task_input":"Use Gtfs Via Postgres in an agent workflow","recommended_action":"Test manually in an isolated workspace and compare against safer alternatives.","install_policy":"review","minimum_review_before_use":["Trust: 72/100 Strong shortlist","Audit: 74/100 Needs review","Safety: 54/100 Avoid automatic install","Review repository, license, install command, and permission surface before production use."],"expected_agent_output":{"selected_skill":"public-transport-gtfs-via-postgres (Gtfs Via Postgres)","install_command":"npx skills add public-transport/gtfs-via-postgres","risk_summary":"Needs review; Experimental; Review before production","verification_result":"Report the smallest successful task, files touched, warnings, and any missing setup."}},"outcome_feedback":{"endpoint":"https://www.openagentskill.com/api/agent/outcome","method":"POST","requires_resolve_event_id":true,"event_id_source":"Use install_receipt.outcome_feedback.event_id or feedback.event_id returned by /api/agent/resolve for the current task.","expected_outcomes":["success","failed","not_relevant","blocked_by_risk","setup_required"],"payload_template":{"event_id":"<install_receipt.outcome_feedback.event_id or feedback.event_id from /api/agent/resolve>","skill_slug":"public-transport-gtfs-via-postgres","task":"Use Gtfs Via Postgres in an agent workflow","agent":"codex","outcome":"success","install_used":true,"risk_blocked":false,"setup_required":false,"task_success":true,"output_quality":4,"error_type":null,"human_review_required":false,"workspace":"sandbox","time_to_useful_ms":120000,"notes":"Report the smallest successful task, setup friction, files touched, and risk notes."}},"endpoints":{"web":"https://www.openagentskill.com/skills/public-transport-gtfs-via-postgres","api":"https://www.openagentskill.com/api/agent/skills/public-transport-gtfs-via-postgres","audit":"https://www.openagentskill.com/skills/public-transport-gtfs-via-postgres/audit","eval":"https://www.openagentskill.com/api/agent/evals?slug=public-transport-gtfs-via-postgres&task=Use%20Gtfs%20Via%20Postgres%20in%20an%20agent%20workflow&max_risk=medium","resolve":"https://www.openagentskill.com/api/agent/resolve?task=Use%20Gtfs%20Via%20Postgres%20in%20an%20agent%20workflow&agent=codex&max_risk=medium","receipt":"https://www.openagentskill.com/api/agent/receipt?task=Use%20Gtfs%20Via%20Postgres%20in%20an%20agent%20workflow&agent=codex&max_risk=medium&format=text","install":"https://www.openagentskill.com/api/skills/public-transport-gtfs-via-postgres/install","manifest":"https://www.openagentskill.com/api/registry/manifest/public-transport-gtfs-via-postgres"}},"machine_metadata":{"version":"openagentskill-agent-metadata-v2","skill":{"slug":"public-transport-gtfs-via-postgres","name":"Gtfs Via Postgres","description":"Analyse GTFS Schedule data by importing it into a PostgreSQL database.","category":"data-analysis","url":"https://www.openagentskill.com/skills/public-transport-gtfs-via-postgres","repository":"https://github.com/public-transport/gtfs-via-postgres","github_repo":"public-transport/gtfs-via-postgres"},"suited_tasks":["Workflow automation workflows","Claude Code teams","builders willing to evaluate younger projects","Move data between tools","Transform files","Trigger repeatable actions","Understand table relationships","Write safer queries"],"suited_agents":["JavaScript","SQL","Codex","Claude Code","Cursor","OpenAgentSkill CLI","CLI"],"install":{"command":"npx skills add public-transport/gtfs-via-postgres","ready":true,"targets":[{"id":"openagentskill-cli","label":"CLI","kind":"command","value":"npx skills add public-transport/gtfs-via-postgres"},{"id":"codex","label":"Codex","kind":"agent-prompt","value":"Install the \"Gtfs Via Postgres\" agent skill from https://github.com/public-transport/gtfs-via-postgres. 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: Analyse GTFS Schedule data by importing it into a PostgreSQL database."},{"id":"claude-code","label":"Claude Code","kind":"agent-prompt","value":"Add \"Gtfs Via Postgres\" as a Claude Code skill from https://github.com/public-transport/gtfs-via-postgres. 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: Analyse GTFS Schedule data by importing it into a PostgreSQL database."},{"id":"cursor","label":"Cursor","kind":"agent-prompt","value":"Turn \"Gtfs Via Postgres\" from https://github.com/public-transport/gtfs-via-postgres 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: Analyse GTFS Schedule data by importing it into a PostgreSQL database."}],"handoff_url":"https://www.openagentskill.com/api/skills/public-transport-gtfs-via-postgres/install","manifest_url":"https://www.openagentskill.com/api/registry/manifest/public-transport-gtfs-via-postgres"},"trust":{"score":72,"label":"Strong shortlist","version":"trust-score-v4","install_policy":"human_review_before_install","evidence":{"stars":"141 GitHub stars","repoActivity":"141 stars, 21 forks","lastPushed":"4mo since push","license":"Unknown","repository":"https://github.com/public-transport/gtfs-via-postgres","install":"npx skills add public-transport/gtfs-via-postgres","installSafety":"standard package or runtime install path","permissionSurface":"filesystem or document access, database access","documentation":"Usable metadata, review docs","agentOutcomes":"No agent outcome data yet"},"outcome_evidence":{"total":0,"successes":0,"failures":0,"not_relevant":0,"success_rate":null,"recent_success_rate":null,"recent_failure_rate":null,"install_attempts":0,"install_success_rate":null,"risk_blocked":0,"setup_required":0,"avg_output_quality":null,"production_outcomes":0,"last_outcome_at":null,"label":"No agent outcome data yet"},"auto_install":{"allowed":false,"sandbox_required":true,"reason":"Human review or sandbox validation is required before automatic installation."},"best_for":["data-analysis","sql","data","gtfs","gtfs-schedule","gtfs-static"],"known_risks":["License is unclear","Quality score needs review","Stars/forks activity: 141 stars, 21 forks; issue activity unavailable in current metadata","License clarity: Unknown"]},"agent_proven":{"version":"agent-proven-v1","score":0,"tier":"unproven","label":"Needs first agent run","summary":"No agent outcome reports yet. Use Resolve, run one narrow sandbox task, then report the result.","metrics":{"totalOutcomes":0,"successfulOutcomes":0,"failedOutcomes":0,"installAttempts":0,"installSuccessRate":null,"successRate":null,"recentSuccessRate":null,"recentFailureRate":null,"riskBlocked":0,"setupRequired":0,"notRelevant":0,"avgOutputQuality":null,"avgTimeToUsefulMs":null,"productionOutcomes":0,"humanReviewRequired":0,"uniqueAgents":0,"lastOutcomeAt":null},"signals":[],"penalties":["No real agent outcome evidence yet"]},"audit":{"score":74,"risk_level":"needs_review","risk_label":"Needs review","warnings":["License is unclear","Quality score needs review","Stars/forks activity: 141 stars, 21 forks; issue activity unavailable in current metadata","License clarity: Unknown"]},"safety_gate":{"tier":"experimental","label":"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."},"quality":{"score":64,"label":"Promising"},"supply":{"track":"Data, BI, and analytics","scenario":"Database and SQL","maintenance":"4mo since push","risk":"Needs review"},"alternative_skills":[],"do_not_use_when":["teams that need a vendor-supported SLA","high-compliance environments without internal security review","No OpenAgentSkill engagement data yet","License is unclear","Quality score needs review","Stars/forks activity: 141 stars, 21 forks; issue activity unavailable in current metadata","License clarity: Unknown","Production credentials, payments, or irreversible account changes without explicit human review"],"agent_contract":{"task_input":"Use Gtfs Via Postgres in an agent workflow","recommended_action":"Test manually in an isolated workspace and compare against safer alternatives.","install_policy":"review","minimum_review_before_use":["Trust: 72/100 Strong shortlist","Audit: 74/100 Needs review","Safety: 54/100 Avoid automatic install","Review repository, license, install command, and permission surface before production use."],"expected_agent_output":{"selected_skill":"public-transport-gtfs-via-postgres (Gtfs Via Postgres)","install_command":"npx skills add public-transport/gtfs-via-postgres","risk_summary":"Needs review; Experimental; Review before production","verification_result":"Report the smallest successful task, files touched, warnings, and any missing setup."}},"outcome_feedback":{"endpoint":"https://www.openagentskill.com/api/agent/outcome","method":"POST","requires_resolve_event_id":true,"event_id_source":"Use install_receipt.outcome_feedback.event_id or feedback.event_id returned by /api/agent/resolve for the current task.","expected_outcomes":["success","failed","not_relevant","blocked_by_risk","setup_required"],"payload_template":{"event_id":"<install_receipt.outcome_feedback.event_id or feedback.event_id from /api/agent/resolve>","skill_slug":"public-transport-gtfs-via-postgres","task":"Use Gtfs Via Postgres in an agent workflow","agent":"codex","outcome":"success","install_used":true,"risk_blocked":false,"setup_required":false,"task_success":true,"output_quality":4,"error_type":null,"human_review_required":false,"workspace":"sandbox","time_to_useful_ms":120000,"notes":"Report the smallest successful task, setup friction, files touched, and risk notes."}},"endpoints":{"web":"https://www.openagentskill.com/skills/public-transport-gtfs-via-postgres","api":"https://www.openagentskill.com/api/agent/skills/public-transport-gtfs-via-postgres","audit":"https://www.openagentskill.com/skills/public-transport-gtfs-via-postgres/audit","eval":"https://www.openagentskill.com/api/agent/evals?slug=public-transport-gtfs-via-postgres&task=Use%20Gtfs%20Via%20Postgres%20in%20an%20agent%20workflow&max_risk=medium","resolve":"https://www.openagentskill.com/api/agent/resolve?task=Use%20Gtfs%20Via%20Postgres%20in%20an%20agent%20workflow&agent=codex&max_risk=medium","receipt":"https://www.openagentskill.com/api/agent/receipt?task=Use%20Gtfs%20Via%20Postgres%20in%20an%20agent%20workflow&agent=codex&max_risk=medium&format=text","install":"https://www.openagentskill.com/api/skills/public-transport-gtfs-via-postgres/install","manifest":"https://www.openagentskill.com/api/registry/manifest/public-transport-gtfs-via-postgres"}},"platforms":["JavaScript","SQL","Claude Code"],"use_cases":[{"slug":"workflow-automation","title":"Workflow automation","url":"https://www.openagentskill.com/use-cases/workflow-automation"},{"slug":"database-sql","title":"Database and SQL","url":"https://www.openagentskill.com/use-cases/database-sql"},{"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 public-transport/gtfs-via-postgres","install_targets":[{"id":"openagentskill-cli","label":"CLI","title":"OpenAgentSkill CLI","kind":"command","value":"npx skills add public-transport/gtfs-via-postgres","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 \"Gtfs Via Postgres\" agent skill from https://github.com/public-transport/gtfs-via-postgres. 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: Analyse GTFS Schedule data by importing it into a PostgreSQL database.","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 \"Gtfs Via Postgres\" as a Claude Code skill from https://github.com/public-transport/gtfs-via-postgres. 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: Analyse GTFS Schedule data by importing it into a PostgreSQL database.","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 \"Gtfs Via Postgres\" from https://github.com/public-transport/gtfs-via-postgres 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: Analyse GTFS Schedule data by importing it into a PostgreSQL database.","description":"Use this when installing as Cursor project rules or reusable agent instructions.","copyLabel":"Copy prompt"}],"repository":"https://github.com/public-transport/gtfs-via-postgres","github_repo":"public-transport/gtfs-via-postgres","version":"1.0.0","license":"Unknown","updated_at":"2026-06-21T01:12:11.533783+00:00","canonical_key":"public-transport/gtfs-via-postgres","recommendation_reasons":["Install handoff is available","Repository freshness signal is available"],"urls":{"web":"https://www.openagentskill.com/skills/public-transport-gtfs-via-postgres","api":"https://www.openagentskill.com/api/agent/skills/public-transport-gtfs-via-postgres","install_api":"https://www.openagentskill.com/api/skills/public-transport-gtfs-via-postgres/install","audit":"https://www.openagentskill.com/skills/public-transport-gtfs-via-postgres/audit","repository":"https://github.com/public-transport/gtfs-via-postgres"},"meta":{"endpoint":"/api/registry/manifest/{slug}","canonical_agent_endpoint":"/api/agent/skills/public-transport-gtfs-via-postgres","agent_friendly":true,"api_version":"1.0","generated_at":"2026-07-04T03:32:10.866Z"}}