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