MergeStat enables SQL queries for data in git repositories (and related sources, such as the GitHub API). It allows you to ask questions about the history and contents of your source code.
For example, it can execute queries that look like this:
-- how many commits have been authored by email@example.com?
SELECT count(*) FROM commits WHERE author_email = 'firstname.lastname@example.org'
Querying source code and commit history with SQL can be an effective way to extract insights from your software development work, for both engineering leaders and developers. We've seen a variety of uses so far, including for:
- Engineering metrics
- Code quality and pattern monitoring
- Software supply chain analytics (examining declared dependencies)
- Config and infra-as-code insights
- Audit and compliance
- Developer on-boarding
- Vulnerability monitoring