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.

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

01Direct correlation between AI interaction logs and Git repository metadata

02SQL-based querying of local Claude Code conversation history and transcripts

03Comprehensive schema access to history, todos, commits, branches, and diffs

0428 GitHub stars

05Productivity tracking through session length and prompt-to-commit analysis

06Flexible output formatting including Table, CSV, and JSON representations

Use Cases

01Auditing Claude Code transcripts to retrieve past solutions or recurring debugging patterns

02Correlating AI prompts with specific Git commits to measure development effectiveness

03Generating automated developer productivity reports and session insights for weekly reviews

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add douglance/devsql devsql-querying

For use in Claude.ai and ChatGPT

Download Skill