Read the full case study here: tbrd.co/phantom

Despite the proliferation of AI chat apps, Explorations wasn't a simple build. Read the engineering post with our experience on LLM orchestration, prompt chaining, tools definition, system prompts, and handling unexpected LLM outputs -> tbrd.co/explorations_tech

You can read more about Explorations in our announcement post -> tbrd.co/explorations

Here's what you can do with Explorations:

- Query data in your natural language
- Build notebook-style analysis
- Customize output with rules
- Visualize results as timeseries charts
- Fix errors automatically

Before you write your first pipe, you must understand your data.

This takes time. It starts with SELECT * … LIMIT 1 and ends with many open SQL docs tabs.

Explorations reduces time-to-first-API by turning natural language queries into optimized & contextualized SQL.

In post 3, we compared Reddit's original architecture to the optimized Tinybird approach in terms of cost, performance, and complexity -> tbrd.co/100bpt3

In post 2, we considered how to effectively scale the counter -> tbrd.co/100bpt2

In post 1, we offered a very simple approach to count 100B rows in Tinybird -> tbrd.co/100bpt1

Curious how this works? We walk through it step-by-step in our latest blog post. ↓

tbrd.co/askai

The basic process:

1. Create an API to pass input to an LLM
2. Pass user input + sys prompt to the LLM
3. Have the LLM return structured filters
4. Fetch your data API using the LLM filters

The key is a good (dynamic!) system prompt & a fast analytics backend (👋 Tinybird).

You can reclaim some UI space by distilling filter UIs into a clean free-text prompt and use an LLM to parse the result.

@dubdotco has a good example. With 20 high-cardinality filter dimensions, Dub simplifies the filter UI by prioritizing free-text AI input ↓

Filters are important for any dashboard. But when the number of filter dimensions grows, UI components for filtering can get clunky and eat up a lot of space.

👇 See how much real estate this sidebar takes?