How Components Uses CamelAI to Power Data-Driven Storytelling
About Components
Components is a media and analytics company founded by Andrew Thompson that explores the "why" behind market behavior across industries. What began as a solo publishing project has evolved into a full-scale media operation with a growing editorial team.
The Challenge: Scaling Data-Driven Journalism
Andrew Thompson initially handled all data engineering, analysis, and writing himself. As publication frequency scaled from annual to weekly and daily releases, the team needed a way to replicate this end-to-end workflow without requiring everyone to become data engineers.
The core pain point was manually traversing hundreds of interconnected tables across multiple data domains. Every story required complex SQL queries against their Postgres database, and only Andrew had the skills to write them. This created a bottleneck that limited how fast the team could publish data-backed stories.
Why Components Chose CamelAI
Components needed a platform that could make their complex Postgres database accessible to non-technical writers. CamelAI connected directly to their database and enabled natural-language querying across hundreds of interconnected tables.
The team evaluated CamelAI's text-to-SQL capabilities and found that it could reliably generate readable SQL from plain-English questions—eliminating the need for writers to learn SQL or wait for Andrew to run queries manually.
Results: 20x Faster Analysis
With CamelAI integrated into their workflow, Components achieved:
- 20x faster exploratory analysis throughput
- Democratized dataset access for non-technical writers
- Reliable, readable SQL generation from natural language
- Seamless Postgres integration with their existing database
- Enabled analyses like their Substack revenue ecosystem deep-dive
Trust and Verification
Components maintains a disciplined verification approach—generated SQL outputs are reviewed when results appear unexpected. Andrew noted that accuracy is typically strong, and the team spot-checks results to maintain editorial standards.
The Impact on Storytelling
By removing the data access bottleneck, CamelAI enabled Components to scale their unique approach to data journalism. Writers can now independently explore datasets, form hypotheses, and build stories backed by real data—all without waiting for engineering support.