Communitygithub.com

pgvector를 활용한 에이전트 및 RAG 워크플로우에 Postgres 네이티브 벡터 검색 추가

애플리케이션 데이터와 함께 Postgres에 임베딩을 저장하고, 벡터 인덱스를 생성하며, 의미 검색, RAG, 추천 또는 에이전트 메모리 검색을 위해 최근접 이웃을 쿼리합니다.

pgvector를 활용한 에이전트 및 RAG 워크플로우에 Postgres 네이티브 벡터 검색 추가란 무엇인가요?

이 스킬은 pgvector 확장을 사용하여 Postgres 데이터베이스에 네이티브 벡터 검색 기능을 추가하는 방법을 설명합니다. 벡터 임베딩을 관계형 데이터와 함께 동일한 데이터베이스에 저장하므로, 별도의 벡터 데이터베이스를 운영할 필요가 없어 아키텍처가 단순해집니다. pgvector를 설치 및 설정하고, 벡터 인덱스를 생성하며, 의미 검색, RAG, 추천 시스템 또는 에이전트 메모리 검색을 위해 SQL로 유사도 쿼리를 실행하는 방법을 다룹니다. Postgres 13+ 및 pgvector 확장이 설치된 환경에서 사용할 수 있으며, Claude Code, Cursor, Codex 등 다양한 AI 에이전트 플랫폼에서 바로 적용할 수 있습니다.

지원 대상~Claude Code~Codex CLI~Cursor
npx skills add https://github.com/agentskillexchange/skills/tree/main/skills/add-postgres-native-vector-retrieval-to-agent-and-rag-workflows-with-pgvector
원본 보기→모든 스킬 둘러보기

즐겨 사용하는 AI에게 물어보기

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

OpenAIChatGPTClaudeClaudeGeminiGeminiGrokGrokPerplexityPerplexityDeepSeekDeepSeek

문서

pgvector를 활용한 에이전트 및 RAG 워크플로우에 Postgres 네이티브 벡터 검색 추가은(는) 무엇을 하나요?

애플리케이션 데이터와 함께 Postgres에 임베딩을 저장하고, 벡터 인덱스를 생성하며, 의미 검색, RAG, 추천 또는 에이전트 메모리 검색을 위해 최근접 이웃을 쿼리합니다.

필수 조건

Postgres 13+, pgvector 확장, 대상 데이터베이스에 대한 SQL 액세스, 에이전트 또는 RAG 파이프라인의 임베딩, Postgres를 쿼리할 수 있는 애플리케이션 코드

설치

환경에 맞는 업스트림 설치 또는 설정 경로를 사용하세요:

  • git clone --branch v0.8.2 https://github.com/pgvector/pgvector.git
  • make
  • make install # sudo가 필요할 수 있음
  • 그런 다음 설치 지침을 다시 실행하세요(필요시 make clean 후 make 실행). make install에 sudo가 필요하면 다음을 사용하세요:

업스트림의 요구 사항 및 주의 사항:

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

문서

출처

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.

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

Adobe Photoshop API Batch Processor

Automates image editing workflows via the Adobe Photoshop API (Firefly Services). Supports smart object replacement, action playback, and PSD layer manipulation at scale.

관련 스킬

steipete/video-frames

Extract frames or short clips from videos using ffmpeg.

community

steipete/summarize

Summarize or transcribe URLs, YouTube/videos, podcasts, articles, transcripts, PDFs, and local files.

community

openclaw/openclaw

Use when testing, fixing, or extending the OpenClaw Control UI GUI with Vitest + Playwright end-to-end checks, mocked Gateway WebSocket flows, mocked dashboard runs, screenshots/videos, or agent-verifiable browser proof.

community

obra/superpowers

Obra superpowers agent skills.

community

affaan-m/ECC

See, Understand, Act on video and audio. See- ingest from local files, URLs, RTSP/live feeds, or live record desktop; return realtime context and playable stream links. Understand- extract frames, build visual/semantic/temporal indexes, and search moments with timestamps and auto-clips. Act- transcode and normalize (codec, fps, resolution, aspect ratio), perform timeline edits (subtitles, text/image overlays, branding, audio overlays, dubbing, translation), generate media assets (image, audio...

community

affaan-m/everything-claude-code

End-to-end marketing campaign planning and execution. Covers audience research, positioning, campaign angle definition, landing page copy, email sequences, social posts, ad copy, short-form video scripts, and content calendars. Use as the orchestration layer for multi-channel product launches. Use when planning or executing a multi-channel product launch, or producing landing page, email, social, or ad copy.

community