“Postgres”

Expert guidance on using PostgreSQL with Swift.

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.

Start and verify the local PostgreSQL database for `aijurisdictionagents`.

Guides and best practices for working with Neon Serverless Postgres.

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.

MANDATORY when touching auth tables, tenant isolation, RLS policies, or multi-tenant database code - enforces Row Level Security best practices and catches…

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

Run read-only SQL queries against PostgreSQL databases.

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.

PostgreSQL performance tuning for the docker instance: memory sizing vs the 1g mem_limit (shared_buffers, effective_cache_size, work_mem math), checkpoint…

Choose and create the right Neon branch type for testing and development.

Postgres performance optimization and best practices from Supabase.

Use this skill when querying the Paperless-ngx PostgreSQL database via the `postgres` MCP server's `postgres_query` tool — discovering document IDs…

Design, review, migrate, measure, or debug PostgreSQL vector retrieval with pgvector.

PostgreSQL database operations via MCP - schema inspection, live queries, EXPLAIN analysis.

PostgreSQL patterns for queries, schema, indexing, security.

Drizzle ORM against PostgreSQL inside a Next.js App Router app.

Inspects PostgreSQL database schema, validates DDL migrations for locking risks, checks query parameterization, and audits indexing.