{"repo":"mergestat/mergestat-lite","free":true,"listed":false,"github":"https://github.com/mergestat/mergestat-lite","clone":"git clone https://github.com/mergestat/mergestat-lite.git","description":"Query git repositories with SQL. Generate reports, perform status checks, analyze codebases. 🔍 📊","language":"Go","stars":3518,"topics":["git","sql","sqlite","golang","go","cli","command-line"],"license":"MIT","category":"databases-storage","readme_excerpt":"mergestat-lite mergestat-lite is a command-line tool for running SQL queries on git repositories and related data sources. It's meant for ad-hoc querying of source-code on disk through a common interface (SQL), as an alternative to patching together various shell commands. It can execute queries that look like: It installs a binary named mergestat . More in-depth examples and documentation can be found on our dedicated documentation site . Join our community on Slack if you have questions, or just to say hi 🎉. Installation See the full instructions in our documentation. Homebrew Docker Examples SQL queries can be executed in the CLI on local or remote git repositories. Remote repos are cloned to a temporary directory at runtime. The --format flag can be used to output json , ndjson , csv and more (see mergestat -h ). This can be useful for piping/using with other tools. Higher level commands such as mergestat summarize commits generate reports without requiring a SQL input. Learn more here about the available flags such as --start to change the date range and --json to output as JSON. Learn more in our docs","default_branch":null,"files":null,"tree":[],"storefront":"/r/mergestat","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/mergestat/mergestat-lite/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}