Know Your Code.
Answer critical questions about your code with SQL
Connect your repos
Connect your Git repositories
Extract and sync data
Extract data from your code using open-source tools and scanners
Know your code 🎉
Ask and answer questions about your code
Example Use Cases & Queries
1-- count the number of repos using each version of Go
2-- by looking at the version declared in go.mod files
3SELECT
4 dependencies_go_version,
5 SUM(count) AS count
6FROM (SELECT
7 1 AS count,
8 SUBSTRING(public.git_files.contents FROM 'go ([0-9]+.[0-9]+)') AS dependencies_go_version
9 FROM public.git_files
10 INNER JOIN public.repos ON public.repos.id = public.git_files.repo_id
11 WHERE public.git_files.path LIKE '%go.mod'
12) AS t
13GROUP BY dependencies_go_versionUse cases
Code querying
Treat your code (and configuration files) like a database to operationalize aspects of the SDLC.
Audit and compliance
Ensure your organization is always following best practices in the software-development-lifecycle.
Engineering transparency
Keep tabs on the areas of interest in your engineering organization, across repositories and teams.
Why SQL?
Data-informed software development
MergeStat enables SQL queries on the tools and processes involved in building and shipping software.
Use data to inform decisions, support arguments, and work more efficiently.
Tailored specifically to you
Leverage the flexibility of SQL to ask the questions that matter to you.
Existing tools tell you what to care about, MergeStat lets you decide what's important.
Run MergeStat on your terms
MergeStat can run on most infrastructure.
Open source
Fully open-source and self-deployable on any infrastructure to ensure security/privacy
