Find the data you need
When you open an unfamiliar database, where does the data you need actually live?
Start with the schema, narrow the search, and see how the likely tables relate before writing a query.
Explore featureInterface illustration
Explore DataTug
From the first look at an unfamiliar database to the next person who needs the same answer, each feature starts with a real investigation problem.
When you open an unfamiliar database, where does the data you need actually live?
Start with the schema, narrow the search, and see how the likely tables relate before writing a query.
Explore featureInterface illustration
DTQL joinsAvailable
When investigating a customer, order, transaction, or incident, how do you follow it across tables today?
Keep the starting record and its joins in view as you move from one question to the next.
Explore featureInterface illustration
Browser cross-source queriesIn development
What happens when the related data lives in another database or system?
Bring the source map and the question together, even when the answer crosses system boundaries.
Explore featureInterface illustration
Guided investigation traceIn development
How much debugging time goes into finding and assembling the relevant data before investigation can start?
Collect the identifiers, sources, and queries around an issue so the evidence is ready for analysis.
Explore featureInterface illustration
Shared knowledge loopExploring
Once someone understands the data, does the next person still have to rediscover it?
Turn a useful join, query, and explanation into project knowledge that the next investigation can reuse.
Explore featureInterface illustration
Start with a source or a project, and follow the evidence from there.
Open DataTug