agent_data

Search Shortcut cmd + k | ctrl + k

Documentation

agent_data

Downloads 951this week

GitHub stars 27

Extension descriptor (YAML)

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, asubbarao

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), Cursor (source='cursor'), OpenAI Codex (~/.codex), Gemini CLI (~/.gemini), and xAI Grok (~/.grok, source='grok').

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');
FROM read_conversations(path='~/.grok');

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', 'cursor', 'codex', 'gemini', or 'grok'. 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;]
read_events	table	NULL	NULL	NULL

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.

In this article