How does the skill handle security for vector data?

The skill provides templates for Row Level Security (RLS) policies, ensuring that embedding data is filtered by user_id or organization_id to prevent data leakage between users.

Can I implement hybrid search with this setup?

Absolutely. The skill includes a specific phase for setting up hybrid search which combines full-text keyword search with semantic vector search using Reciprocal Rank Fusion (RRF) for balanced results.

What is the difference between HNSW and IVFFlat indexes in this skill?

HNSW is recommended for most applications with fewer than 1 million vectors as it offers higher recall and faster queries. IVFFlat is better for write-heavy workloads or massive datasets where memory usage and insert speed are critical.

Does this skill support OpenAI and Cohere embedding models?

Yes, it includes specific configuration guidance for various dimensions, including OpenAI's 1536 (small) and 3072 (large) dimensions, as well as Cohere's 1024-dimension models.

Supabase pgvector Setup

Name: Supabase pgvector Setup
Author: vanman2024

byvanman2024

0•

Database Management

Configures pgvector on Supabase to enable high-performance semantic search, RAG systems, and hybrid search capabilities.

This skill automates the integration of vector databases within Supabase environments, providing developers with pre-configured templates for embedding storage and optimized indexing strategies like HNSW and IVFFlat. It streamlines the development of AI-powered applications by handling complex SQL functions for semantic matching, implementing hybrid search with Reciprocal Rank Fusion (RRF), and ensuring data security through Row Level Security (RLS) policies. Whether you are building a document retrieval system or a recommendation engine, this skill provides the necessary scripts and architectural patterns to deploy production-ready vector search infrastructure.

Key Features

01Automated pgvector extension enablement and schema configuration

02Support for optimized HNSW and IVFFlat vector indexing strategies

03Pre-built templates for semantic search and hybrid RRF functions

04Dimension presets for OpenAI, Cohere, and custom embedding models

05Integrated validation scripts for performance testing and recall accuracy

060 GitHub stars

Use Cases

01Building Retrieval-Augmented Generation (RAG) systems for AI chatbots

02Implementing semantic product recommendations in e-commerce platforms

03Developing hybrid search systems that combine keyword matching with vector similarity

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add vanman2024/ai-dev-marketplace pgvector-setup

For use in Claude.ai and ChatGPT

Key Features

01Automated pgvector extension enablement and schema configuration

02Support for optimized HNSW and IVFFlat vector indexing strategies

03Pre-built templates for semantic search and hybrid RRF functions

04Dimension presets for OpenAI, Cohere, and custom embedding models

05Integrated validation scripts for performance testing and recall accuracy

060 GitHub stars

Use Cases

01Building Retrieval-Augmented Generation (RAG) systems for AI chatbots

02Implementing semantic product recommendations in e-commerce platforms

03Developing hybrid search systems that combine keyword matching with vector similarity

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add vanman2024/ai-dev-marketplace pgvector-setup

For use in Claude.ai and ChatGPT