postgres▌

Comprehensive performance optimization guide for Postgres, maintained by Supabase. Contains rules across 8 categories, prioritized by impact to guide automated query optimization and schema design.

Expert patterns for Neon serverless Postgres, branching, connection pooling, and ORM integration. \n \n Covers Prisma and Drizzle ORM setup with Neon, including dual connection string configuration (pooled vs. direct) for migrations and application queries \n Explains PgBouncer connection pooling limits (10K concurrent connections) and reserved superuser connections \n Provides guidance on choosing between Neon's neon-http driver (single queries) and neon-serverless driver (transactions and WebS

Analyze a single target project to identify data access artifacts that require integration testing, then produce a structured, actionable testing plan.

Postgres performance optimization rules across 8 priority categories, from query tuning to advanced features. \n \n Organized into 8 rule categories prioritized by impact: query performance and connection management (critical), security and RLS, schema design, concurrency, data access patterns, monitoring, and advanced features \n Each rule includes detailed explanations, incorrect vs. correct SQL examples, EXPLAIN output analysis, and performance metrics to guide optimization decisions \n Cover

<essential_principles>

Execute safe, read-only queries against configured PostgreSQL databases.

postgres-schema-design

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.