·mastering-postgresql
</>

mastering-postgresql

✓
spillwavesolutions/mastering-postgresql-agent-skillGitHub: spillwavesolutions/mastering-postgresql-agent-skillSource: spillwavesolutions/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. Use when creating search features, storing AI embeddings, querying vector similarity, optimizing PostgreSQL indexes, or deploying to AWS RDS/Aurora, GCP Cloud SQL/AlloyDB, or Azure. Covers psycopg2, psycopg3, asyncpg, SQLAlchemy integration, Docker development setup, and index selection strategies. Triggers are Use "PostgreSQL search", "pgvector", "BM25 postgres", "JSONB index", "psycopg", "asyncpg", "PostgreSQL Docker", "AlloyDB vector". Does NOT cover - DBA administration (backup, replication, users), MySQL/MongoDB/Redis, schema design theory, stored procedures.

spillwavesolutions·mastering·postgresql
13Installs·6Trend·@spillwavesolutions

Installation

GitHub: spillwavesolutions/mastering-postgresql-agent-skill
$npx skills add https://github.com/spillwavesolutions/mastering-postgresql-agent-skill --skill mastering-postgresql

How to Install mastering-postgresql

Quickly install mastering-postgresql AI skill to your development environment via command line

  1. Open Terminal: Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.)
  2. Run Installation Command: Copy and run this command: npx skills add https://github.com/spillwavesolutions/mastering-postgresql-agent-skill --skill mastering-postgresql
  3. Verify Installation: Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw

Source: spillwavesolutions/mastering-postgresql-agent-skill.

SKILL.md

View raw

Build search, vector similarity, and data-intensive applications with PostgreSQL and Python.

| Docker/local setup | setup-and-docker.md | | Full-text search & BM25 | search-fulltext.md | | pgvector & JSONB indexing | search-vectors-json.md | | Python drivers & pools | python-drivers.md | | Python query patterns | python-queries.md | | AWS RDS/Aurora | cloud-aws.md | | GCP Cloud SQL/AlloyDB | cloud-gcp.md | | Azure Flexible Server | cloud-azure.md |

| Neon & Supabase | cloud-serverless.md | | Cloud common (pooling, config) | cloud-common.md |

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. Use when creating search features, storing AI embeddings, querying vector similarity, optimizing PostgreSQL indexes, or deploying to AWS RDS/Aurora, GCP Cloud SQL/AlloyDB, or Azure. Covers psycopg2, psycopg3, asyncpg, SQLAlchemy integration, Docker development setup, and index selection strategies. Triggers are Use "PostgreSQL search", "pgvector", "BM25 postgres", "JSONB index", "psycopg", "asyncpg", "PostgreSQL Docker", "AlloyDB vector". Does NOT cover - DBA administration (backup, replication, users), MySQL/MongoDB/Redis, schema design theory, stored procedures. Source: spillwavesolutions/mastering-postgresql-agent-skill.

Facts (cite-ready)

Stable fields and commands for AI/search citations.

Install command
npx skills add https://github.com/spillwavesolutions/mastering-postgresql-agent-skill --skill mastering-postgresql
Source
spillwavesolutions/mastering-postgresql-agent-skill
Category
</>Dev Tools
Verified
✓
First Seen
2026-02-22
Updated
2026-03-10
URL
https://www.learn-skills.dev/en/skills/spillwavesolutions/mastering-postgresql-agent-skill/mastering-postgresql

Browse more skills from spillwavesolutions/mastering-postgresql-agent-skill

Quick answers

What is mastering-postgresql?

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. Use when creating search features, storing AI embeddings, querying vector similarity, optimizing PostgreSQL indexes, or deploying to AWS RDS/Aurora, GCP Cloud SQL/AlloyDB, or Azure. Covers psycopg2, psycopg3, asyncpg, SQLAlchemy integration, Docker development setup, and index selection strategies. Triggers are Use "PostgreSQL search", "pgvector", "BM25 postgres", "JSONB index", "psycopg", "asyncpg", "PostgreSQL Docker", "AlloyDB vector". Does NOT cover - DBA administration (backup, replication, users), MySQL/MongoDB/Redis, schema design theory, stored procedures. Source: spillwavesolutions/mastering-postgresql-agent-skill.

How do I install mastering-postgresql?

Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/spillwavesolutions/mastering-postgresql-agent-skill --skill mastering-postgresql Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw

Where is the source repository?

https://github.com/spillwavesolutions/mastering-postgresql-agent-skill

Details

Category
</>Dev Tools
Source
skills.sh
First Seen
2026-02-22

Related Skills

None