“Postgres”

PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement.

Postgres and Supabase.

Execute read-only SQL queries against multiple PostgreSQL databases.

Use when querying, managing, or debugging PostgreSQL databases — schema design, query optimization, migrations, indexing, and connection pooling.

Sets up and manages Postgres using the clickhousectl CLI — runs a local Docker-backed Postgres for development, and creates and operates managed ClickHouse…

Provision instant temporary Postgres databases via Claimable Postgres by Neon (neon.new) with no login, signup, or credit card.

Guides and best practices for working with Lakebase Postgres on Neon: connections, pooled vs direct, schema migrations, branching, autoscaling, scale-to-zero…

Deprecated compatibility name for prisma-postgres-setup.

Guides and best practices for working with Neon Serverless Postgres.

Expert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integrationUse when "neon database, serverless postgres…

Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features.

Obtain or reuse a Prisma Postgres database and connect an application.

Postgres best practices maintained by Supabase, for Postgres running anywhere.

Prisma Postgres setup and operations guidance across Console, create-db CLI, Management API, and Management API SDK.

Postgres schema, RLS, indexing and SQL review rules.

Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package.

Set up a new Prisma Postgres database and connect it to a local project using the Management API.

Read-only PostgreSQL instance health battery: connectivity/uptime, cache hit ratio, dead tuples & autovacuum hotspots, XID wraparound distance, long-running &…

Diagnose and fix excessive Postgres egress (network data transfer) in a codebase.

PostgreSQL container operations for the docker instance: volume persistence audit (PGDATA layout and the PG18 version-specific data-directory change)…

Postgres schema and query rules, independent of the calling language.

PostgreSQL database patterns for query optimization, schema design, indexing, and security.

PostgreSQL backup & restore playbook for the docker instance: pg_dump/pg_dumpall recipes, WAL archiving + PITR setup (archive_mode, archive_command…

MUST USE when investigating performance issues on a ClickHouse-managed Postgres instance.