Choosing a Postgres connection pool mode that matches your workload — pgBouncer session/transaction/statement modes, the prepared-statement story (pgBouncer 1.21+), Supabase…
Use when starting a new PostgreSQL database, picking naming conventions, deciding multi-schema layout, or hardening search_path against SECURITY DEFINER injection.
Administers and hardens PostgreSQL at the engine level — configuration, replication, vacuum behavior, and locking under real workloads.
PostgreSQL expert for query optimization, indexing, extensions, and database administration
Use when a Postgres query is slow, p99 latency regressed after deploy, EXPLAIN ANALYZE output needs interpretation, the planner is choosing the wrong index, dead tuples are…
Use when designing game database schemas, player data models, inventory systems, or working with Drizzle ORM and PostgreSQL for games.
Recommend the right Postgres index for a query or workload — choosing B-Tree vs. GIN vs. BRIN vs. partial/covering/expression, checking for redundant or unused indexes, and…
Use when reviewing or remediating PostgreSQL query and index performance against a stated performance budget.
PostgreSQL-based job queue with priority scheduling, batch claiming, and progress tracking. Use when building job queues without external dependencies.
Use Crystal DBA Postgres MCP Pro for PostgreSQL schema inspection, safe read-only SQL, explain plans, health checks, and index-tuning analysis from Codex.
Query, analyze, and tune PostgreSQL databases through your AI agent with safe access controls. Beyond basic SQL execution, it provides index tuning recommendations, query plan…
Postgres MCP Pro is an open-source MCP server that provides AI agents with PostgreSQL database health analysis, index tuning recommendations, query plan optimization, schema…
PostgreSQL 数据库管理和优化助手。提供完整的数据库操作能力：健康检查、索引优化、查询计划分析、模式查询、SQL 执行。Use when 需要数据库操作、SQL查询、数据存储管理时使用。不适用于数据库架构设计决策。适用于独立开发者、企业团队和自动化工作流场景。Use when…
Apply schema changes to a live PostgreSQL database without taking downtime or locking out writers.
Expert guidance on using PostgreSQL with Swift. Use when developers mention: (1) PostgreSQL or Postgres in Swift, (2) postgres-nio library, (3) SQL queries in Swift, (4)…
Diagnose PostgreSQL incidents involving plans, locks, pooling, replication, vacuum, or recovery.
PostgreSQL operations, optimization, and administration. Use for: schema design, index selection, query tuning with EXPLAIN ANALYZE, postgresql.conf configuration, backup and…
PostgreSQL optimization including indexes, query plans, partitioning, JSONB operations, and connection pooling
PostgreSQL patterns for reviewing migrations and writing efficient queries. Use when reviewing Alembic migrations, optimizing queries, or debugging database issues.
PostgreSQL performance optimization and best practices. Use when writing SQL queries, designing schemas, implementing indexes, or debugging database performance.
High-performance PostgreSQL patterns. Use when optimizing queries, designing for scale, or debugging performance issues.
PostgreSQL performance engineering beyond basic indexing: query plan instability, statistics staleness, EXPLAIN ANALYZE interpretation, GIN index pending list management, extended…
Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features.
Use when user needs PostgreSQL database administration, performance optimization, high availability setup, backup/recovery, or advanced PostgreSQL feature implementation.
PostgreSQL optimization — query tuning, schema design, indexing strategies, and performance analysis
Execute safe read-only SQL queries against PostgreSQL databases with multi-connection support and defense-in-depth write protection.
Use when designing, reviewing, or hardening PostgreSQL replication and high-availability posture against stated reliability targets.
Review PostgreSQL schemas, migrations, queries, indexes, RLS, pooling, and backups.
Guides agents implementing or auditing PostgreSQL Row Level Security in a multi-tenant SaaS codebase.
Use when writing or reviewing Postgres queries in a multi-tenant SaaS where every table row must be scoped to a single organization.
Review PlanetScale Postgres for Traffic Control, query tags, roles, pg_strict, backups/PITR, private connectivity, webhooks, branches, and safe agent operation.
Use when designing, reviewing, or evolving a PostgreSQL schema for a production system. Produces normalized schema design, integrity constraints, indexing strategy, Flyway or…
Set up PostgreSQL database with standardized schema.sql pattern. Use when starting a new project that needs PostgreSQL, setting up database schema, or creating setup scripts for…
PostgreSQL strictness, schema design, indexing, migration safety, and operational rules. Use when designing schemas, writing queries, reviewing migrations, tuning performance, or…
PostgreSQL internals specialist for query optimization, indexing, partitioning, and advanced featuresUse when "postgresql, postgres, slow query, index, explain analyze, vacuum,…
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features — from 2025Emma/vibe-coding-cn
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features — from bg-szy/TOP-SKILLS
Reviews PostgreSQL 18 concurrency behavior, transaction boundaries, race conditions, uniqueness, idempotency, replay defense, locking, isolation levels, outbox/inbox patterns, and…
PostgreSQL development best practices for schema design, query optimization, and database administration
PostgreSQL-specific code review assistant focusing on PostgreSQL best practices, anti-patterns, and unique quality standards.
Connect to a source PostgreSQL database for migration to Snowflake using scai CLI. Triggers: postgresql, postgres, source connection, source database, connect to postgresql, add…
PostgreSQL administration and setup including installation, configuration, backup/recovery, replication, and high-availability. Learn production PostgreSQL operations.
Use when building, debugging, or evaluating CloudBase PostgreSQL / CloudBase PG / PG mode apps, including Postgres schema setup, queryPgDatabase/managePgDatabase, JS SDK — from…
Use when building, debugging, or evaluating CloudBase PostgreSQL / CloudBase PG / PG mode apps, including Postgres schema setup, queryPgDatabase/managePgDatabase, JS SDK — from…
Runs diagnostic queries against PostgreSQL using pg_stat_statements, pg_stat_activity, and pg_locks system views.
Diagnoses PostgreSQL performance issues using pg_stat_statements, pg_stat_activity, and the pgbadger log analyzer.
Queries PostgreSQL system catalogs pg_stat_activity, pg_stat_user_tables, and pg_locks to diagnose performance issues.
PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management.
Diagnoses PostgreSQL performance issues using pg_stat_statements, pg_stat_activity, and EXPLAIN ANALYZE.
Analyzes PostgreSQL query performance using pg_stat_statements, pg_stat_user_tables, and EXPLAIN ANALYZE output.
Executes diagnostic queries against PostgreSQL using pg_stat_statements, pg_stat_activity, and pg_locks system views.
Analyzes PostgreSQL slow queries using EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON) output and pg_stat_statements views.
Diagnoses slow PostgreSQL queries using pg_stat_statements, pg_stat_activity, and EXPLAIN ANALYZE output parsing.
Optimizes PostgreSQL queries using EXPLAIN ANALYZE output parsing with pg_stat_statements extension data.
Executes EXPLAIN ANALYZE BUFFERS on slow PostgreSQL queries and parses the plan tree for sequential scans, nested loop joins, and sort spills.
Analyzes PostgreSQL query execution plans using EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON) and the pg_stat_statements extension.
Interprets PostgreSQL EXPLAIN ANALYZE output using pg_stat_statements and auto_explain module data. Identifies sequential scan bottlenecks, index recommendations via HypoPG, and…
Queries pg_stat_statements and pg_stat_activity to surface the top slow queries by total execution time, mean latency, and call frequency.
Diagnoses PostgreSQL slow queries using pg_stat_statements extension, EXPLAIN ANALYZE output parsing, and pg_stat_user_indexes for index usage analysis.
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features — from whatamelon/AGENT-HARNESS-BASELINE