Best Claude prompts for Architects, Except Landscape and Naval

Analyze the provided entity-relationship diagram and identify potential bottlenecks in the database schema. Consider the impact of denormalization, indexing, and query optimization on overall system performance. Generate a revised schema that minimizes latency and maximizes throughput, taking into account the expected workload and data distribution. Assume a relational database management system and provide a detailed explanation of the design decisions and trade-offs made during the optimization process.

Evaluate the provided microservices architecture and identify areas for improvement in terms of service granularity, communication protocols, and data consistency. Consider the trade-offs between monolithic and microservices architectures, and provide a detailed analysis of the scalability, fault tolerance, and maintainability of the current design. Generate a revised architecture that addresses the identified issues and provides a clear roadmap for implementation, including a discussion of the potential challenges and risks associated with the proposed changes.

Perform a comprehensive security audit of the provided API, identifying potential vulnerabilities and weaknesses in authentication, authorization, and data encryption. Consider the OWASP Top 10 and provide a detailed analysis of the API's compliance with industry standards and core standards. Generate a report outlining the identified risks and providing recommendations for remediation, including a discussion of the potential impact on system performance and usability.

Develop a comprehensive cloud migration strategy for the provided application, including a detailed analysis of the current infrastructure, a cost-benefit analysis of different cloud providers, and a discussion of the potential risks and challenges associated with the migration process. Consider the trade-offs between lift-and-shift, re-architecture, and hybrid approaches, and provide a clear roadmap for implementation, including a discussion of the potential impact on system performance, scalability, and maintainability. Generate a report outlining the recommended migration strategy and providing a detailed explanation of the design decisions and trade-offs made during the planning process.