Best Gemini prompts for Software Developers

Given a JSON file containing the current usage metrics of an AWS EC2 instance, including CPU utilization, memory usage, and network throughput, and a desired monthly budget of $10,000, generate a Python script using the AWS SDK to analyze the usage patterns, identify opportunities for cost optimization, and recommend a revised instance type and scaling strategy to minimize costs while maintaining performance, assuming a 20% buffer for unexpected usage spikes.

Develop a Bash script to automate the code review and testing process for a Git repository, using Git hooks to trigger a series of checks, including syntax validation using pylint, code formatting using black, and unit testing using pytest, and generate a summary report of any errors or warnings, including line numbers and error messages, to facilitate quick identification and fixing of issues, assuming a Python 3.9 environment and the presence of a requirements.txt file.

Given a distributed system consisting of multiple microservices communicating over HTTP, and a log file containing a record of all requests and responses, including timestamps, request IDs, and error messages, generate a ROOT cause analysis report to identify the source of a recent outage, including a visual representation of the system's communication flow using Graphviz, and recommendations for additional logging or monitoring to prevent similar outages in the future, assuming a 5-node cluster and a maximum request latency of 500ms.

Analyze a MySQL database schema and a set of SQL queries to identify performance bottlenecks, including slow-running queries, indexing opportunities, and locking contention, and generate a set of optimized queries using EXPLAIN ANALYZE, including rewritten queries, new index suggestions, and locking strategy recommendations, to improve the overall query performance by at least 30%, assuming a dataset of 1 million rows and a maximum acceptable query latency of 200ms.