Blog

What I Wanted To Understand Before Looking At RawTree

A product engineering perspective on RawTree, flexible data ingestion, SQL and the operational questions to investigate before selecting a database.

By FRSHR ·

I was not looking for another tool just because it was new. I was trying to understand what happens when a team has useful data before it has a perfect model for that data.

RawTree caught my attention because it seems to focus on that exact stage: keeping changing information available while the team figures out how it should be organised and used.

I Kept Running Into The Same Data Problem

I kept seeing the same awkward stage in data projects: the product is already producing useful information, but nobody is completely sure what the final data model should look like yet.

That stage can get expensive. Teams may spend time designing tables before they have seen enough real data, then redesign them when new fields, events, or usage patterns appear. I was looking for a way to explore that middle ground without treating an early schema as a permanent decision.

That is what made me look at RawTree. I have not run a large production workload on it, so this is not a claim about results from my own deployment. It is my reading of the product, its documentation, and the problem it is built to address.

What I Needed To Clarify First

Before thinking about whether RawTree would fit a project, I wanted clear answers to a few basic questions:

Does It Support Data That Changes Over Time?

RawTree is designed around flexible, evolving data. Its documentation describes tables that can be created as data is inserted, rather than requiring every field and table to be final before the first useful record arrives.

That does not mean structure disappears. It means the structure can develop from actual data instead of being based entirely on assumptions made at the beginning.

Can The Data Still Be Queried Normally?

This was important to me because flexible storage is not very helpful if the result is hard to analyse. RawTree provides SQL access, so the data can still be explored with familiar queries while the model is taking shape.

The combination is the interesting part: the input can remain adaptable, while the analysis layer stays understandable to a technical team.

Is It Only For AI Workloads?

No. RawTree presents AI and agent workloads as an important use case, but its documented integrations also include OpenTelemetry and Prometheus. That makes the product relevant to a wider set of data that is generated continuously and may not be perfectly predictable at the start.

How I Understand The RawTree Approach

The easiest way for me to think about RawTree is as a place to keep raw, changing data available while a team learns what deserves a more permanent shape.

That matters for application events, telemetry, logs, and other operational data. The first version of a model is often a working hypothesis. RawTree's approach leaves room to test that hypothesis before investing heavily in a fixed design.

The useful part is not simply avoiding a schema. It is being able to move from exploration to analysis without throwing away the original information or rebuilding the whole pipeline every time the data changes.

The Pieces That Make The Idea Practical

Raw flexibility by itself would not be enough for me. These are the parts that make the overall idea feel more usable.

Flexible Ingestion

RawTree documents ingestion through APIs, a command-line interface, SDKs, and an MCP server. That gives a team more than one way to get data into the platform, depending on whether the workflow is application-driven, operational, or AI-assisted.

The platform is also described as supporting customer-controlled infrastructure and storage, as well as a hosted cloud option. That is a meaningful distinction for teams that need to think carefully about where data lives.

SQL As The Common Language

I also like that the analytical side is not hidden behind a completely new way of working. SQL is still the bridge between raw data and the questions a team wants to ask about it.

For a project that is still changing, I would rather have flexible ingestion with familiar querying than a rigid model that looks tidy but needs constant maintenance.

Controls For A Real Team

RawTree's documentation also describes authentication, authorisation, resource policies, and administration features. Those details are less exciting than the flexible model, but they are the difference between an interesting technical idea and something a team can evaluate seriously.

Where AI Fits Into The Picture

The AI angle makes sense because AI applications often generate data that changes quickly: prompts, responses, tool calls, evaluations, traces, and metadata can all evolve while a product is being built.

RawTree's documentation describes AI and agent workflows as a core use case, including connections through its MCP server. I would see that as a way to let an assistant work with current data without forcing the entire data model to be settled before experimentation begins.

Still, I would not reduce RawTree to an AI-only product. The same need for flexible, queryable data appears in observability and application telemetry, which is why the broader integrations matter.

Why Observability Is Part Of The Story

When a system is changing quickly, observability data changes with it. New services, new events, new attributes, and new versions can all make yesterday's model incomplete.

RawTree's documented support for OpenTelemetry and Prometheus fits that reality. It suggests a workflow where teams can collect useful operational data first, then improve the way they organise and query it as they learn more about the system.

That is a practical benefit, even before talking about performance. Better visibility starts with keeping the information available and usable.

What I Would Check Before Using It

I would still evaluate RawTree against the actual workload rather than assuming flexibility automatically makes it the right choice. My checklist would be:

  1. Define The Data Sources First. Confirm which APIs, telemetry systems, or application events need to be connected.
  2. Decide What The First Questions Need To Be. Test whether the SQL layer can answer the operational and product questions the team actually has.
  3. Review Ownership And Controls. Check authentication, authorisation, resource policies, and the preferred hosting or storage model.
  4. Measure With Realistic Data. Use representative volume and query patterns before making a decision about long-term performance or cost.
  5. Plan The Transition To More Structure. Identify which parts of the data may eventually deserve stronger conventions, models, or downstream tables.

What I Think Of It So Far

RawTree makes the most sense to me as a tool for the stage before a data system becomes fully settled. It gives teams a way to keep changing information available, query it with SQL, and gradually learn which parts need more structure.

That is a useful position in the market. Many projects are not failing because they lack data; they are struggling because the data is arriving faster than the model can mature.

I would still want to validate the product with the exact sources, permissions, volume, and queries involved in a real project. But based on the official product information, RawTree offers a thoughtful answer to a problem that is easy to underestimate: how to stay flexible without giving up analysis.