Communitygithub.com

Rust로 PostgreSQL 확장 빌드, 테스트, 패키징 (pgrx)

에이전트가 PostgreSQL용 Rust 네이티브 확장 라이프사이클(로컬 빌드, 테스트 실행, PostgreSQL 버전 간 패키징)이 필요할 때 pgrx를 사용합니다.

Rust로 PostgreSQL 확장 빌드, 테스트, 패키징 (pgrx)란 무엇인가요?

이 스킬은 에이전트가 pgrx 프레임워크를 사용하여 PostgreSQL 확장을 Rust로 개발, 테스트, 패키징하는 전체 과정을 안내합니다. pgrx는 PostgreSQL 확장 개발을 위해 설계된 Rust 기반 프레임워크로, cargo 명령어를 통해 로컬 빌드(cargo pgrx run), 테스트 실행, 패키징을 지원하며 여러 PostgreSQL 버전을 대상으로 할 수 있습니다. 이 스킬의 주요 사용처는 Claude Code, Cursor, Codex 등 AI 코딩 에이전트이며, 개발자는 자연어 설명만으로 확장의 전체 라이프사이클을 자동화할 수 있습니다. 스킬은 시스템 요구사항(Rust 도구 체인, PostgreSQL 개발 의존성, pgrx 설치), 설치 방법(brew, cargo install 등), Mac에서의 추가 설정, 기본 사용법(cargo pgrx run을 통한 psql에서의 대화형 테스트)을 포함하며, 공식 문서와 저장소로의 링크를 제공합니다.

지원 대상~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에게 물어보기

이 에이전트 스킬이 미리 로드된 새 채팅을 엽니다.

문서

Rust로 PostgreSQL 확장 빌드, 테스트, 패키징 (pgrx)은(는) 무엇을 하나요?

에이전트가 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 정책이 없으므로 Rustup을 통해 최신 안정 버전의 Rust가 필요할 수 있습니다.
  • Mac에서 PGRX를 실행하려면 추가 설정이 필요합니다.
  • Xcode 및 명령줄 도구를 업데이트하면 해결됩니다. OS 업데이트가 필요할 수 있습니다.

기본 사용법 또는 시작하기 참고사항:

문서

출처

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

관련 스킬