mastering-postgresql

Build PostgreSQL apps with full-text search, vector embeddings, and cloud deployment.

6|1|Updated Dec 31, 2025

Search Tags:#postgresql #python #docker #vector search #full-text search #cloud deployment #pgvector

One-click install

npx skills add https://github.com/SpillwaveSolutions/mastering-postgresql-agent-skill --skill mastering-postgresql

Or copy as Structured Prompt for Agent▼

Please help me install this Agent Skill.
Skill: mastering-postgresql
Source: https://github.com/SpillwaveSolutions/mastering-postgresql-agent-skill/tree/main/mastering-postgresql
Command: npx skills add https://github.com/SpillwaveSolutions/mastering-postgresql-agent-skill --skill mastering-postgresql

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires psycopg2, pgvector, numpy, and includes scripts (resource) and references (resource) and assets (resource) components.

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

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