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, psy
/plugin marketplace add SpillwaveSolutions/mastering-postgresql-agent-skill
The exact command may vary by repository. Check the README on GitHub.
For the skill author
Shows your skill is listed on Skillteca, generates a backlink and trackable traffic.
[](https://www.skillteca.com.br/skills/mastering-postgresql?utm_source=badge&utm_medium=readme&utm_campaign=badge)
Resources to assist in writing various internal communications, adhering to company-preferred formats. Claude should utilize this skill for status reports, leadership updates, newsletters, FAQs, and other internal documents.
Monitors a pull request or review cycle until it is ready to merge. This skill is used to track PR comments, reviews, and CI status until all actionable issues are resolved.
Execute a phased implementation plan using subagents. Use when asked to execute, run, or carry out a plan — especially one created by make-plan.
Token-optimized structural code search using tree-sitter AST parsing. Use this instead of reading full files when you need to understand code structure, find functions, or explore a codebase efficiently.
Category alert
One short email with only the new DevOps e Infra skills. 4 minutes of reading, no spam, unsubscribe with one click.
You confirm your email on the first send. No spam. Unsubscribe with one click.
Build search, vector similarity, and data-intensive applications with PostgreSQL and Python.
| Task | Go To |
|---|---|
| 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](references/python-d |
[Description truncada. Veja o README completo no GitHub.]
Sign in to comment. Sign in
