Best Grok prompts for Database Architects

Given a PostgreSQL database with 500 tables, 1000 relationships, and an average query latency of 100ms, analyze the EXPLAIN ANALYZE output of the top 10 most frequently executed queries and identify the primary performance bottlenecks, considering factors such as indexing, caching, and locking mechanisms, and provide a step-by-step plan to optimize the queries and reduce latency by 30%.

Design a real-time monitoring system for a data pipeline that ingests 100k events per second from a Kafka topic, processes them using a Spark Streaming job, and writes the output to a Cassandra database, and identify potential issues such as data loss, duplication, or corruption, and provide a set of alerts and notifications to trigger when these issues occur, using metrics such as throughput, latency, and error rate.

Compare two database schemas, one from a production environment and one from a development environment, and identify the differences in terms of table structure, indexing, and constraints, and generate a SQL script to migrate the development schema to match the production schema, considering factors such as data type compatibility, default values, and nullable columns, and provide a step-by-step plan to execute the migration with minimal downtime.

Analyze a series of query performance metrics collected over a period of 30 days, including execution time, CPU usage, and memory allocation, and identify the root cause of a 50% degradation in query performance over the past week, considering factors such as changes in data distribution, indexing, and system resources, and provide a detailed report of the analysis, including recommendations for optimization and potential fixes, using techniques such as regression analysis and statistical modeling.