# mergestat/mergestat-lite

Query git repositories with SQL. Generate reports, perform status checks, analyze codebases. 🔍 📊

Repository: https://github.com/mergestat/mergestat-lite
Canonical: https://ross.abutalabs.com/products/mergestat-lite
Homepage: https://mergestat.com/
Language: Go
License: MIT
License Family: permissive
Topics: git, sql, sqlite, golang, go, cli, command-line
Last push: 2026-08-26T19:59:56+00:00

## Health v2 (maintenance only)
Score: 67/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 99, release rhythm 8, longevity 100
- inputs: {"age_days": 2252, "days_push": 7, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 3518, forks 111 (observed 2026-08-28T04:08:07.893354+00:00)

## What it is
mergestat-lite is a Go-based command-line tool that lets you run SQL queries against git repositories and related data sources like the GitHub API. It treats commit history and file contents as queryable tables, and includes higher-level commands like `summarize commits` for generating reports without writing SQL.

## Use cases
- query git commit history with sql
- count commits by author across repositories
- analyze codebase dependencies like go.mod versions
- generate commit activity reports for a repo
- audit repository contents and configuration files
- run ad-hoc analytics on source code from the command line
- export git repository data as  or csv

## When to choose
- you want to ask ad-hoc questions about git history or repo contents without writing shell scripts
- you prefer SQL over chaining git commands and grep
- you need to pipe repository data into other tools via /csv output
- you want quick status checks or summaries of a codebase

## When to avoid
- you need a persistent, scheduled sync of many repos into a database (use the full MergeStat platform instead)
- you need a GUI or hosted dashboard for code analytics
- you only need simple git log queries that plain git commands already handle

## Facets
- artifact type: cli-tool
- maturity: stable
- function: database, search-engine, analytics, cli, developer-tools
- domain: developer-tools, version-control, analytics
- platform: cli, cross-platform, go
- tags: git, sql, sqlite, code-analytics, repository-analysis, command-line, docker

## Member repositories
- mergestat/mergestat-lite (main) score 67

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:08:07.893354+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T18:35:33.778633+00:00, confidence not recorded.
  - readme: https://github.com/mergestat/mergestat-lite (fetched 2026-08-28T04:08:07.893354+00:00, sha 47c0c30ab503)
  - homepage: https://mergestat.com/ (fetched 2026-08-29T09:29:23.913682+00:00, sha 70469ee0ae9d)
  - site_page: https://docs.mergestat.com (fetched 2026-08-29T09:29:23.922368+00:00, sha 737c9a4c362b)
  - site_page: https://docs.mergestat.com/ (fetched 2026-08-29T09:29:23.924068+00:00, sha 737c9a4c362b)
- Data as of 2026-08-30T08:39:29.467469+00:00.