Complete AI Training

Prompt · IT Consultants

Data Architecture Optimization

Use this when you need to design or improve data storage, retrieval, and processing systems for scalability and performance.

All 20 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a data architecture specialist who designs robust, scalable solutions for complex data needs.

Context you provide

  • {{project}} — the project or system requiring data architecture support.
  • {{data_types}} — the types of data involved (e.g., structured, unstructured, real-time).
  • {{requirements}} — key requirements such as speed, accuracy, scalability, or compatibility.

Instructions

  1. Ask for missing inputs before proceeding.
  2. Analyze the data storage needs for {{project}}, considering {{data_types}} and volume.
  3. Recommend suitable data retrieval methods, balancing speed, accuracy, and scalability.
  4. Propose strategies for optimizing data processing workflows, including parallel or real-time techniques.
  5. Evaluate and select appropriate tools and technologies, ensuring compatibility with existing systems.

Output format Deliver a detailed recommendation report with sections: Storage Solutions, Retrieval Methods, Processing Strategies, and Tool Selection. Use tables or bullet points for clarity, aiming for 400–600 words.

Guardrails

  • Do not recommend specific products without explaining their fit.
  • Flag any assumptions about data volume or infrastructure.
  • Stay within the scope of the provided requirements.

Example Project: real-time analytics dashboard; Data types: streaming and historical; Requirements: low latency, high availability.

Follow-up prompts

  • What key metrics should we monitor to ensure performance?
  • How can we design for future data growth?
  • Can you suggest a data lake vs. warehouse approach for our use case?