Mastering Postgresql Agent Skill

Mastering PostgreSQL Agent Skill

PostgreSQL development for Python with full-text search (tsvector, tsquery, BM25 via pg_search), vector similarity (pgvector with HNSW/IVFFlat), JSONB and array indexing, and production deployment.

Features

• Full-text Search: tsvector, tsquery, GIN indexes, ts_rank
• BM25 Search: pg_search/ParadeDB integration
• Vector Similarity: pgvector with HNSW and IVFFlat indexes
• JSONB Indexing: GIN indexes, containment queries
• Python Drivers: psycopg2, psycopg3, asyncpg, SQLAlchemy
• Cloud Deployment: AWS RDS/Aurora, GCP Cloud SQL/AlloyDB, Azure

When to Use This Skill

Use this skill when:

• Creating search features with PostgreSQL
• Storing and querying AI embeddings
• Optimizing PostgreSQL indexes
• Setting up Docker development environments
• Deploying to cloud providers (AWS, GCP, Azure)

Installing with Skilz (Universal Installer)

The recommended way to install this skill across different AI coding agents is using the **skilz** universal installer.

Install Skilz

pip install skilz

This skill supports [Agent Skill Standard](https://agentskills.io/) which means it supports 14 plus coding agents including Claude Code, OpenAI Codex, Cursor and Gemini.

Git URL Options

You can use either `-g` or `--git` with HTTPS or SSH URLs:

# HTTPS URL
skilz install -g https://github.com/SpillwaveSolutions/mastering-postgresql-agent-skill

# SSH URL
skilz install --git git@github.com:SpillwaveSolutions/mastering-postgresql-agent-skill.git

Claude Code

Install to user home (available in all projects):

skilz install -g https://github.com/SpillwaveSolutions/mastering-postgresql-agent-skill

Install to current project only:

skilz install -g https://github.com/SpillwaveSolutions/mastering-postgresql-agent-skill --project

OpenCode

Install for [OpenCode](https://opencode.ai):

skilz install -g https://github.com/SpillwaveSolutions/mastering-po