postgres▌

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

Type-safe PostgreSQL applications with Drizzle ORM, migrations, and performance best practices. \n \n Covers schema design, relational queries, transactions, and drizzle-kit workflows (generate, migrate, push, studio) \n Includes decision trees for modeling relationships, diagnosing slow queries, and choosing the right commands \n Emphasizes critical performance patterns: indexing foreign keys, avoiding N+1 queries with relational APIs, and connection pooling \n Provides anti-pattern warnings fo

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

Setup and programmatic management of Prisma Postgres databases across Console, CLI, and APIs. \n \n Four core workflows: manual Console setup, instant provisioning via create-db CLI, REST API integration with service tokens or OAuth, and type-safe TypeScript integration via @prisma/management-api-sdk \n Supports temporary database creation with auto-deletion after ~24 hours, claim URLs for persistence, and region selection \n Management API available at https://api.prisma.io/v1 with OpenAPI docs

Comprehensive guides and best practices for Neon Serverless Postgres, covering setup, connection methods, authentication, and platform APIs. \n \n Covers getting started, local development setup, connection method selection (TCP, HTTP, WebSocket), and driver installation for any language or framework \n Includes Neon-specific features: autoscaling, branching (instant copy-on-write clones), scale-to-zero, instant restore, and read replicas \n Provides CLI tooling ( neonctl ), TypeScript/Python SD