ChatLab: a private desktop analyzer for social chat histories using AI agents and SQL

What it solves

ChatLab allows users to analyze and understand their social conversation histories from various platforms. It solves the problem of chat data being locked in proprietary formats or scattered across different apps, enabling users to extract insights, identify patterns, and query their own data privately on their own machine.

How it works

The application follows a five-stage data pipeline: format detection, stream parsing, local persistence, SQL and AI querying, and visualization. It normalizes exports from platforms like WhatsApp, Telegram, and Discord into a unified model. To analyze the data, it uses a combination of a SQL engine and AI agents equipped with over 24 tools via function calling to search and summarize records.

Who it’s for

It is designed for individuals who want to perform deep analysis of their personal chat histories while maintaining strict data privacy.

Highlights

• Broad Platform Support: Works with WhatsApp, LINE, QQ, Discord, Instagram, Telegram, iMessage, and Google Chat.
• Privacy-Centric: Data and settings stay local by default with no mandatory cloud uploads.
• Scalable Processing: Uses stream parsing and multi-worker processing to handle million-message histories.
• AI-Powered Analysis: Employs an Agent + Function Calling workflow for context-aware data exploration.