Best Perplexity prompts for Database Architects

Given a PostgreSQL database with 1000 tables, 5000 queries per second, and an average query latency of 50ms, analyze the query execution plans, identify the top 5 bottlenecks, and provide a step-by-step plan to optimize the database configuration, indexing strategy, and query rewriting to reduce latency by 30%. Assume the database is running on a 16-core, 64GB RAM machine with SSD storage.

Design a data warehouse schema for a retail company with 1000 stores, 10000 products, and 100000 daily transactions, using a star schema with fact tables for sales, inventory, and customer behavior. Define the dimension tables, measures, and ETL processes to load data from various sources, including POS systems, CRM software, and social media platforms. Assume the data warehouse will be built using Amazon Redshift and should support querying by store, product, date, and customer segment.

Evaluate the feasibility of migrating a 10TB Oracle database from an on-premises data center to Google Cloud SQL, considering factors such as data transfer costs, storage pricing, instance types, and network latency. Provide a detailed breakdown of the estimated costs, migration timeline, and potential risks, as well as recommendations for optimizing database performance, security, and high availability in the cloud. Assume the database has 5000 concurrent connections and requires 99.99% uptime.

Conduct a comprehensive security audit of a MySQL database with 500 users, 1000 tables, and 500 stored procedures, identifying potential vulnerabilities such as SQL injection, privilege escalation, and data breaches. Analyze the database configuration, user permissions, and access controls, and provide a prioritized list of recommendations to remediate the identified risks, including password policy updates, firewall rule changes, and encryption enhancements. Assume the database is used by a web application with 10000 daily active users.