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.
/plugin marketplace add SpillwaveSolutions/mastering-postgresql-agent-skill/plugin install mastering-postgresql@mastering-postgresql-agentic-skillWarn about potential security issues when editing files - targets command injection, XSS vulnerabilities, and dangerous coding patterns
Interactive learning mode that requests meaningful code contributions at decision points (mimics the unshipped Learning output style)
Comprehensive PR review agents specializing in comments, tests, error handling, type design, code quality, and code simplification
Automated code review for pull requests using multiple specialized agents with confidence-based scoring