postgres▌

This skill covers using PostgreSQL with the pgvector extension as the storage backend for GrepAI.

Status: Production Ready Last Updated: 2026-01-24 Dependencies: None Latest Versions: Django@5.1, psycopg2-binary@2.9.9, gunicorn@23.0.0, google-cloud-sql-connector@1.12.0

Instant Postgres databases for local development, demos, prototyping, and test environments. No account required. Databases expire after 72 hours unless claimed to a Neon account.

Serverless Postgres setup for edge functions with connection pooling, branching, and ORM integration. \n \n Supports Neon Direct (multi-cloud, Cloudflare Workers) and Vercel Postgres (zero-config on Vercel); both use HTTP/WebSocket protocols instead of TCP for edge compatibility \n Requires pooled connection strings ( -pooler. in hostname) for serverless; non-pooled connections exhaust quickly in high-concurrency environments \n Template tag syntax ( sql`...` ) prevents SQL injection; string con

Use the template in references/BUG-REPORT-TEMPLATE.md. Each report must include:

Translate Oracle PL/SQL stored procedures and functions to PostgreSQL PL/pgSQL equivalents.

Generates integration test cases for data access artifacts in a single target project. Tests validate behavior consistency when running against Oracle or PostgreSQL.

Configure Prisma for Neon with connection pooling.

PostgreSQL best practices for indexing, schema design, query optimization, and security. \n \n Covers six index types with specific use cases: B-tree for equality/range queries, composite for multi-column filters, GIN for JSONB and full-text search, and BRIN for time-series data \n Includes data type guidance (bigint for IDs, text over varchar, timestamptz for timestamps, numeric for money) and anti-pattern detection queries for unindexed foreign keys and slow queries \n Provides ready-to-use SQ

Expert PostgreSQL optimization, replication setup, and advanced feature implementation. \n \n Covers query analysis with EXPLAIN, index design across B-tree/GIN/GiST/BRIN types, and JSONB storage strategies with containment queries \n Includes streaming and logical replication setup with lag monitoring via pg_stat_replication \n Provides VACUUM tuning, autovacuum configuration, bloat detection, and statistics refresh workflows \n Supports PostgreSQL extensions including PostGIS, pgvector, pg_trg