Best Claude prompts for Web Developers

Analyze the given database schema and SQL query, identify potential bottlenecks and areas for improvement, and provide a rewritten query that minimizes latency and maximizes throughput. Consider indexing, caching, and query optimization techniques. Assume the database is a relational database management system and the query is executed frequently. Provide a step-by-step explanation of the thought process and the changes made to the original query.

Design a microservices architecture for an e-commerce platform with the following components: user authentication, product catalog, order management, and payment processing. Consider scalability, fault tolerance, and communication between services. Provide a detailed diagram showing the relationships between services, data storage, and communication protocols. Assume a cloud-based infrastructure and containerization using Docker.

Analyze the given web application's architecture and network topology, identify potential causes of high latency, and provide a step-by-step plan to investigate and resolve the issue. Consider factors such as server response time, database queries, network bandwidth, and browser rendering. Assume the application is built using a modern web framework and deployed on a cloud platform. Provide a detailed report including recommendations for optimization and performance improvement.

Create a deployment script for a containerized web application using Docker and Kubernetes. The script should automate the build, push, and deployment process, including rolling updates and rollback strategies. Consider environment variables, secrets management, and resource allocation. Assume a cloud-based infrastructure and a CI/CD pipeline using Jenkins. Provide a detailed explanation of the script's functionality and a step-by-step guide for implementation.