agent_data

Downloads

905

GitHub stars

Extension repository on GitHub

A DuckDB extension written in Rust for querying, analysing and inspecting AI coding agents history. Read conversations, plans, todos, history, and usage stats directly from your local agent data directories.

Maintainer(s): axsaucedo

Installing and Loading

INSTALL agent_data FROM community;
LOAD agent_data;

Example

-- How many conversations have I had with Claude?
SELECT COUNT(DISTINCT session_id) AS sessions,
       COUNT(*) AS total_messages
-- Calling the functions without params defaults to Claude folder.
FROM read_conversations();

-- What did I work on this week?
SELECT date, message_count, tool_call_count
FROM read_stats()
ORDER BY date DESC
LIMIT 7;

-- Which tools does github copilot use most?
SELECT tool_name, COUNT(*) AS uses
FROM read_conversations('~/.copilot')
WHERE tool_name IS NOT NULL
GROUP BY tool_name
ORDER BY uses DESC
LIMIT 10;

-- What are my active todos in my custom claude path?
SELECT content, status
FROM read_todos('~/work_folder/.claude')
WHERE status != 'completed'
ORDER BY item_index;

-- Compare activity across Claude and Copilot
SELECT source, COUNT(DISTINCT session_id) AS sessions, COUNT(*) AS messages
FROM (
    SELECT * FROM read_conversations(path='~/.claude')
    UNION ALL
    SELECT * FROM read_conversations(path='~/.copilot')
)
GROUP BY source;

About agent_data

Supported agents: Claude Code (~/.claude), Claude Desktop, GitHub Copilot CLI (~/.copilot), OpenAI Codex (~/.codex), and Gemini CLI (~/.gemini).

Written in 🦀 Rust.

Default Behavior

When called without arguments, each function reads from its provider’s default path:

Function	Default path	Detected as
`read_conversations()`	`~/.claude`	Claude Code
`read_plans()`	`~/.claude`	Claude Code
`read_todos()`	`~/.claude`	Claude Code
`read_history()`	`~/.claude`	Claude Code
`read_stats()`	`~/.claude`	Claude Code

To read another agent’s data, pass the path explicitly:

FROM read_conversations(path='~/.copilot');
FROM read_conversations(path='~/.codex');
FROM read_conversations(path='~/.gemini');

Available Functions

All functions accept two optional parameters:

path — data directory path (default: ~/.claude). Auto-detected from folder structure (projects/ → Claude, session-state/ → Copilot, dated sessions/ → Codex, tmp/ + installation_id → Gemini).
source — explicit provider override: 'claude', 'claude-desktop', 'copilot', 'codex', or 'gemini'. Use when auto-detection fails or for non-standard directory layouts.

Every table includes a source column ('claude' or 'copilot') as the first column.

read_conversations([path (opt)], [source (opt)])

Join Keys

Tables can be joined within the same source:

-- Conversations ↔ History (via session_id)
SELECT c.*, h.display
FROM read_conversations(path='~/.claude') c
JOIN read_history(path='~/.claude') h ON c.session_id = h.session_id;

-- Cross-source: always filter by source
SELECT * FROM (
    SELECT * FROM read_conversations(path='~/.claude')
    UNION ALL
    SELECT * FROM read_conversations(path='~/.copilot')
) WHERE source = 'copilot';

Join	Left Key	Right Key	Notes
conversations <-> history	`session_id`	`session_id`	Same source only
conversations <-> todos	`session_id`	`session_id`	Same source only
conversations <-> plans	`slug`	`plan_name`	Claude only
conversations <-> history	`project_path`	`project`	Claude only

For full documentation, see the GitHub repository.

Added Functions

function_name	function_type	description	comment	examples
read_conversations	table	Read conversation messages and tool calls from AI coding agent sessions	Supports Claude Code and GitHub Copilot CLI with auto-detection	[SELECT * FROM read_conversations(path=‘~/.claude’) LIMIT 10;]
read_plans	table	Read plan and strategy markdown files from agent sessions	Claude: plans/.md, Copilot: session-state//plan.md	[SELECT plan_name, file_size FROM read_plans();]
read_todos	table	Read todo and checklist items with status tracking	Claude: todos/*.json, Copilot: checkpoint markdown checklists	[SELECT content, status FROM read_todos() WHERE status != ‘completed’;]
read_history	table	Read command and prompt history	Claude: history.jsonl, Copilot: command-history-state.json	[SELECT display FROM read_history() ORDER BY line_number DESC LIMIT 10;]
read_stats	table	Read daily activity statistics (message, session, and tool call counts)	Currently Claude only — returns empty for Copilot	[SELECT date, message_count FROM read_stats() ORDER BY date DESC;]

Overloaded Functions

This extension does not add any function overloads.

Added Types

This extension does not add any types.

Added Settings

This extension does not add any settings.