Best Claude prompts for Database Architects

Analyze the provided database schema and instance metrics, and recommend a set of indexing, caching, and query optimization strategies to improve average query response time by at least 30%. Consider the impact of concurrent user connections, data distribution, and storage subsystem performance on overall system throughput. Provide a detailed, step-by-step implementation plan, including SQL code snippets and expected performance gains.

Design a data warehouse architecture to support business intelligence and analytics workloads, including data ingestion from multiple sources, data transformation and processing, and data visualization and reporting. Consider the trade-offs between different data warehouse design patterns, such as star and snowflake schemas, and recommend a set of ETL tools and data processing frameworks to support the chosen design. Provide a detailed, entity-relationship diagram and a written justification of the design choices.

Conduct a comprehensive security risk assessment of the provided database system, including analysis of network exposure, authentication and authorization mechanisms, data encryption, and access controls. Identify potential vulnerabilities and recommend a set of mitigation strategies, including configuration changes, patching, and monitoring. Provide a detailed, prioritized list of recommended actions, including estimated risk reduction and implementation effort.

Develop a cloud migration plan for a legacy database system, including assessment of current database dependencies, identification of suitable cloud-based alternatives, and recommendation of a migration strategy and timeline. Consider the impact of cloud migration on database performance, security, and cost, and provide a detailed, step-by-step migration plan, including estimated costs and resource requirements.