Skills
.Work. You
Rest

mastering-postgresql

Official

Automate PostgreSQL search and vector work.

Data & Analytics#postgresql#python#docker#vector search#full-text search#cloud deployment#pgvector
AuthorSpillwaveSolutions
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill enables developers to build data-intensive PostgreSQL apps with full-text search, vector embeddings, and cloud deployment, simplifying complex setups and saving time.

Core Features & Use Cases

  • Full-text search with tsvector and tsquery, BM25 via pg_search, and trigram fuzzy search.
  • Vector similarity using pgvector (HNSW and IVFFlat) for embedding-based search.
  • JSONB and array indexing for flexible data structures.
  • Python integrations: psycopg2, psycopg3, asyncpg, SQLAlchemy for productive data apps.
  • Docker-based development and cloud deployment (AWS, GCP, Azure).

Quick Start

  1. Install skilz and install this skill
  2. Start the local dev environment using the provided docker-compose-pgvector.yml
  3. Run scripts/setup_extensions.py and scripts/create_search_tables.py to initialize
  4. Run a sample Python script to perform vector search with asyncpg

Dependency Matrix

Required Modules

psycopg2pgvectornumpy

Components

scriptsreferencesassets

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: mastering-postgresql
Download link: https://github.com/SpillwaveSolutions/mastering-postgresql-agent-skill/archive/main.zip#mastering-postgresql

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.