وصف الناشر
Use when you need to optimize PostgreSQL performance, design high-availability replication, or troubleshoot database issues at scale. Invoke this agent for query optimization, configuration tuning, replication setup, backup strategies, and mastering advanced PostgreSQL features for enterprise deployments. Specifically:\n\n\nContext: Production PostgreSQL database is experiencing slow queries. Average query latency increased from 50ms to 500ms, and the team needs to identify and fix the bottlenecks causing the performance degradation.\nuser: "Our PostgreSQL queries have slowed down significantly. Can you analyze what's wrong and optimize them?"\nassistant: "I'll analyze your query performance using EXPLAIN, check index efficiency, review table statistics, identify missing or unused indexes, and optimize slow queries. I'll also tune your PostgreSQL configuration (shared_buffers, work_mem, checkpoint settings) and set up monitoring to prevent future degradation."\n\nUse this agent when you have production performance issues requiring EXPLAIN analysis, index optimization, and configuration tuning. The agent will diagnose bottlenecks and deliver specific optimizations with measurable latency improvements.\n\n\n\n\nContext: Team is planning to scale PostgreSQL to handle 10x current traffic and needs a fault-tolerant replication strategy with automatic failover capability.\nuser: "We need to set up PostgreSQL replication for high availability. We want automatic failover and can accept 1-2 second replication lag. What's the best approach?"\nassistant: "I'll design a streaming replication architecture with synchronous secondaries and automatic failover using Patroni or pg_auto_failover. I'll implement connection pooling with pgBouncer, configure WAL archiving for PITR, set up monitoring dashboards, and create runbooks for common failure scenarios."\n\nInvoke this agent when architecting high-availability Postgr
الأمان
لم يراجع فريقنا هذا المورد. فحصته قواعد آلية فقط، واستُبعدت الموارد التي رصدت فيها إشارات خطر عالية. هذه إشارات وليست ضمانًا بأن التثبيت آمن. جرّبه أولًا في مشروع تجريبي.
- ينفّذ شيفرة أو يغيّر سلوك المساعد
المصادر
- AI Templates (aitmpl) رُصد أول مرة 13 نوفمبر 2026 · آخر رصد 18 نوفمبر 2026 · صفحته في المصدر · أرقام يذكرها المصدر: aitmpl downloads 982
postgres-pro
Use when you need to optimize PostgreSQL performance, design high-availability replication, or troubleshoot database issues at scale. Invoke this agent for query optimization, configuration tuning, replication setup, backup strategies, and mastering advanced PostgreSQL features for enterprise deployments. Specifically:\n\n<example>\nContext: Production PostgreSQL database is experiencing slow queries. Average query latency increased from 50ms to 500ms, and the team needs to identify and fix the bottlenecks causing the performance degradation.\nuser: "Our PostgreSQL queries have slowed down sig
كما ظهر في www.aitmpl.com عند آخر قراءة لنا