Communitygithub.com

使用 pgrx 在 Rust 中建置、測試與打包 PostgreSQL 擴充功能

當代理需要 PostgreSQL 的 Rust 原生擴充功能生命週期(包括跨 PostgreSQL 版本的本地建置、測試執行與打包)時,請使用 pgrx。

使用 pgrx 在 Rust 中建置、測試與打包 PostgreSQL 擴充功能 是什麼?

此技能讓 AI 代理能夠使用 pgrx 框架在 Rust 中開發 PostgreSQL 擴充功能。pgrx 提供完整的擴充功能生命週期管理,包括本機建構、測試執行以及針對多個 PostgreSQL 版本打包。它對需要工具鏈設定的開發人員非常有用,例如安裝特定依賴、處理 Mac 上的系統要求,以及透過包管理器或從原始碼安裝 pgrx。該技能支援快速建立與測試擴充功能的指令,例如 `cargo pgrx run`,並連結官方文檔與社群資源。它整合了延伸閱讀資源與標準開發工作流程,讓代理能有效地自動化 pgrx 專案的建置、測試與打包步驟。

相容平台~Claude Code~Codex CLI~Cursor
npx skills add https://github.com/agentskillexchange/skills/tree/main/skills/build-test-and-package-postgresql-extensions-in-rust-with-pgrx

在你喜歡的 AI 中提問

開啟一個已預先載入此 Agent Skill 的新對話。

說明文件

使用 pgrx 在 Rust 中建置、測試與打包 PostgreSQL 擴充功能 是做什麼的?

當代理需要 PostgreSQL 的 Rust 原生擴充功能生命週期(包括跨 PostgreSQL 版本的本地建置、測試執行與打包)時,請使用 pgrx。

先決條件

Rust 工具鏈、PostgreSQL 開發相依套件,以及 pgrx

安裝方式

使用符合您環境的上游安裝或設定路徑:

  • brew install git icu4c pkg-config
  • 在執行 cargo pgrx init 之前,於命令列執行此指令
  • 專案與舊目錄已消失。解決方案是重新執行 cargo pgrx init
  • cargo install --locked cargo-pgrx

上游的需求與注意事項:

  • † pgrx 沒有 MSRV 政策,因此可能需要最新穩定版的 Rust,可透過 Rustup 取得
  • 在 Mac 上執行 pgrx 需要額外設定。
  • 這可以透過更新 Xcode 與命令列工具來解決。您可能需要進行作業系統更新

基本使用或入門筆記:

文件

來源

Individual skills in this repo

This repo contains 20 individual skills — each has its own dedicated page.

Academic Paper Citation Network Mapper

Builds citation networks from Semantic Scholar API and CrossRef DOI metadata. Visualizes paper influence graphs using NetworkX, identifies seminal works, and tracks research lineage across fields.

ACF Custom Fields REST Exposer

Exposes Advanced Custom Fields data through the WordPress REST API using register_rest_field and acf_format_value. Handles repeater fields, flexible content layouts, and gallery fields with proper serialization.

ACF Extended for Advanced Custom Fields Workflows

An ASE skill built around ACF Extended, the WordPress enhancement suite for Advanced Custom Fields that adds field types, admin improvements, front-end forms, options pages, and developer tooling. It is a practical fit for agents working inside complex WordPress content models and custom field workflows.

ACF to Gutenberg Block Migrator

Converts Advanced Custom Fields field groups into native Gutenberg blocks using the ACF Block API v2 and @wordpress/scripts build pipeline. Maps ACF repeaters, groups, and flexible content to InnerBlocks and block attributes with server-side rendering via acf_register_block_type().

Activepieces Open Source Workflow Automation

Activepieces is an open-source, self-hostable workflow automation platform with 200+ integrations. It provides a visual builder for creating automated workflows and exposes all its connectors as MCP servers for AI agent use.

ActivityWatch Cross-Platform Automated Time Tracker and Producti

ActivityWatch is a privacy-first, open-source automated time tracker that records application usage, browser activity, and AFK status across Windows, macOS, and Linux. With 16k+ GitHub stars, it provides detailed productivity analytics without sending data to external servers.

act Local GitHub Actions Runner

act is an open-source CLI tool that runs GitHub Actions workflows locally using Docker, enabling fast feedback on workflow changes without pushing to GitHub. It is a standard tool for local Actions development and testing.

Add a browser review checkpoint before risky agent actions with

Use AgentClick when an agent should pause before risky commands, plans, drafts, or code changes so a human can inspect, edit, approve, or reject them in a purpose-built browser UI.

Add Claude design-system and accessibility workflows with UX/UI

Use UX/UI Agent Skills when Claude should generate tokens, component specs, accessibility audits, and framework-specific UI code from a repeatable design workflow.

Add executable smoke tests for shell scripts and CLIs before ref

Use Bats-core when an agent needs to turn fragile shell scripts or command-line workflows into something it can verify repeatedly after edits. The agent writes focused Bash tests for success paths, failure paths, and output contracts, then runs them locally or in CI before a refactor, release, or incident fix goes out.

Add graph-backed memory and context retrieval to agent workflows

Use Cognee to ingest project knowledge into graph and vector memory so agents can retrieve durable context across sessions and workflows.

Add IDE-style semantic code navigation and symbol-safe refactors

Give a coding agent symbol-aware lookup, cross-file rename, and structural edit tools before it starts making brittle text-only changes.

Add managed long-term memory to LangGraph agents with LangMem

Give LangGraph agents memory management and search tools so they can store, retrieve, and update durable facts across sessions.

Add multimodal lifelong memory to MCP and Python agents with Sim

Use SimpleMem to store, compress, index, and retrieve text or multimodal memories for agents through MCP or Python integrations.

Add persistent project memory and hook-driven synthesis with Cla

Keep Claude Code sessions grounded in prior decisions, project context, and daily handoff notes instead of starting from zero every time.

Add Postgres-native vector retrieval to agent and RAG workflows

Store embeddings beside application data in Postgres, create vector indexes, and query nearest neighbors for semantic search, RAG, recommendations, or agent memory retrieval.

Address GitHub PR review comments from the current branch with g

Find the open PR for the current branch, gather unresolved review comments, and drive a focused comment-resolution workflow with gh-authenticated context.

Add runtime guardrails to TypeScript agents with VoltAgent

Use VoltAgent to intercept, validate, and enforce input/output policies in TypeScript agent workflows.

Add temporal context memory to agent workflows with Zep

Use Zep as an external context layer for agents that need to store events, assemble temporal graph context, and retrieve relevant memory before model calls.

Adobe Firefly API Batch Image Generator

Calls Adobe Firefly

相關技能