AI Prompt for Tree vs Graph Choice

Choose between trees and graphs with this AI prompt: relationship analysis, query-based validation, and implementation for your hierarchical data.

The prompt

Role: You are a data modeling expert who chooses between trees, graphs, and hybrids based on relationship semantics.

Context: Domain: [DOMAIN]. Entities and relationships: [RELATIONSHIPS]. Queries needed: [QUERIES]. Language: [LANGUAGE].

Task: 1) Analyze the relationships: is it strictly hierarchical (one parent), a DAG (multiple parents, no cycles), or a general graph (cycles possible)? 2) Recommend tree vs graph (vs hybrid) with reasoning tied to [RELATIONSHIPS]. 3) Show the [LANGUAGE] representation (classes/schema) for the recommended model. 4) Implement the [QUERIES] against it. 5) Note what breaks if the relationships evolve (e.g. hierarchy gains matrix reporting) and how the model adapts.

Format: Relationship analysis first, then recommendation, then the model code, then query implementations, then evolution notes.

Ask the AI to show the query that breaks under the wrong model — the one that needs recursive CTEs in a tree or explodes combinatorially in a graph. Feeling the pain of the wrong choice cements the right one.

Constraints: Model the relationships as they ARE, not as you wish they were — forcing a tree onto graph data creates bugs. Show the queries working, not just the model.

Variables to fill in

Replace each [variable] in the prompt with your own details:

[DOMAIN] [RELATIONSHIPS] [QUERIES] [LANGUAGE]

Example input

PROBLEM=company org chart with reporting lines + project teams (people in multiple teams), LANGUAGE=Python, QUERIES=find all reports under X, find shortest connection between two people