How do I install the required tools for this skill?

You must install the DevSQL CLI tool via Homebrew using the command: brew install douglance/tap/devsql.

What data formats does DevSQL support?

DevSQL can output results in a formatted table by default, or you can export data to CSV and JSON formats using the -f flag.

Can I see which Claude prompts led to specific code commits?

Yes, by joining the 'history' and 'commits' tables, you can correlate your prompts with the resulting Git activity to see which interactions were most productive.

What is the DevSQL Querying skill?

It is a specialized Claude Code skill that allows you to use SQL queries to analyze your local Claude interaction history joined with your Git commit data.

DevSQL Querying & Analytics

Name: DevSQL Querying & Analytics
Author: douglance

bydouglance

•

Analytics & Monitoring

Analyzes Claude Code interaction history and Git data through SQL queries to reveal developer productivity patterns.

About

DevSQL Querying provides a powerful analytical layer for Claude Code users, enabling SQL-based exploration of local session history and Git activity. By joining Claude’s prompt logs with repository commit data, developers can quantify their AI usage, identify which prompts lead to successful code changes, and generate detailed reports on their coding workflows. It is an essential tool for developers who want to move beyond simple chat logs and perform deep-dive analytics on their AI-assisted development sessions.

Key Features

Direct correlation between AI interaction logs and Git repository metadata
SQL-based querying of local Claude Code conversation history and transcripts
Comprehensive schema access to history, todos, commits, branches, and diffs
28 GitHub stars
Productivity tracking through session length and prompt-to-commit analysis
Flexible output formatting including Table, CSV, and JSON representations

Use Cases

Auditing Claude Code transcripts to retrieve past solutions or recurring debugging patterns
Correlating AI prompts with specific Git commits to measure development effectiveness
Generating automated developer productivity reports and session insights for weekly reviews

About

Key Features

Direct correlation between AI interaction logs and Git repository metadata
SQL-based querying of local Claude Code conversation history and transcripts
Comprehensive schema access to history, todos, commits, branches, and diffs
28 GitHub stars
Productivity tracking through session length and prompt-to-commit analysis
Flexible output formatting including Table, CSV, and JSON representations

Use Cases

Auditing Claude Code transcripts to retrieve past solutions or recurring debugging patterns
Correlating AI prompts with specific Git commits to measure development effectiveness
Generating automated developer productivity reports and session insights for weekly reviews