🚀 Quick Start

# Install CLI# Follow instructions in [CLI repository](https://github.com/Puchaczov/Musoq.CLI)# Generate some GUIDsMusoq run query"select NewId() from #system.range(1, 5)"# Find your largest filesMusoq run query"select Name, Length from #os.files('/home/user', true) where Length > 1000000 order by Length desc take 10"# Check git commits this monthMusoq run query"select Count(1) from #git.repository('.') r cross apply r.Commits c where c.CommittedWhen > '2024-11-01'"

💡 Why SQL for Scripting?

find. -name"*.js" -exec wc -l {}\;| awk'{sum+=$1} END {print sum}'

selectSum(Length(f.GetFileContent()))as TotalLinesfrom#os.files('.', true) fwheref.Extension='.js'

importos,subprocess,re# 15 lines of file handling, regex, and loops

selectf.Name,f.Directoryfrom#os.files('/project', true) fwheref.GetFileContent() rlike'TODO.*urgent'

🎯 Perfect For Daily Developer Tasks

🛠 What You Can Query

Everyday Stuff

-- Generate test dataselect'User'+ ToString(Value)as Username, NewId()as UserIdfrom#system.range(1, 100)-- Find duplicate files by nameselect  Name,Count(1)as Duplicatesfrom#os.files('/downloads', true)group by NamehavingCount(Name)>1-- Disk space by file typeselect  Extension,Sum(Length)/1024/1024as SizeMB,Count(1)as FileCountfrom#os.files('/project', true)group by Extensionorder bySum(Length)/1024/1024desc

Development Tasks

-- Git contributors last monthselectc.Author,Count(1)as Commitsfrom#git.repository('.') rcross applyr.Commits cwherec.CommittedWhen> SubtractDateTimeOffsets(GetDate(), FromString('30.00:00:00'))group byc.Authororder byc.Commitsdesc-- Find TODOs in codebaseselectfiles.Name,f.LineNumber,f.Linefrom#os.files('./src', true) filescross apply#flat.file(files.FullName) fwherefiles.Extensionin ('.cs','.js','.py')andf.Linelike'%TODO%'-- Complex C# classes (requires solution analysis)selectc.Name,c.MethodsCount,c.LinesOfCodefrom#csharp.solution('./MyProject.sln') scross applys.Projects pcross applyp.Documents dcross applyd.Classes cwherec.MethodsCount>20order byc.LinesOfCodedesc

Data Processing

-- Transform CSV dataselect  Category,Sum(ToDecimal(Amount))as Totalfrom#separatedvalues.csv('./sales.csv', true, 0)group by Category-- Extract structured data from text using AIselectt.ProductName,t.Price,t.Descriptionfrom#stdin.text('OpenAI', 'gpt-4o') twhere ToDecimal(t.Price)>100

🌟 Why You Might Love It

📈 Scales From Simple to Sophisticated

select NewId()from#system.dual()

-- Analyze codebase evolution over timewith MonthlyStatsas (select         ToString(c.CommittedWhen,'yyyy-MM')as Month,Count(d.Path)as FilesChanged,Sum(p.LinesAdded)as LinesAdded,Sum(p.LinesDeleted)as LinesDeletedfrom#git.repository('./large-project') r    cross applyr.Commits c    cross applyr.DifferenceBetween(c,r.CommitFrom(c.Sha+'^')) d      cross applyr.PatchBetween(c,r.CommitFrom(c.Sha+'^')) pgroup by ToString(c.CommittedWhen,'yyyy-MM'))select  Month,  FilesChanged,  LinesAdded- LinesDeletedas NetLinesfrom MonthlyStatsorder by Monthdesctake12

🎬 Real-World Examples

-- Find files not accessed in 6 monthsselect  FullName,  LastAccessTimefrom#os.files('/old-project', true)where LastAccessTime< SubtractDateTimeOffsets(GetDate(), FromString('180.00:00:00'))-- Compare two directoriesselect  FullName,  Statusfrom#os.dirscompare('/backup', '/current')where Status!='The Same'

-- Which files change together most often?selectf1.Path,f2.Path,Count(1)as CoChangesfrom#git.repository('.') r cross apply r.Commits ccross applyr.DifferenceBetween(c,r.CommitFrom(c.Sha+'^')) f1cross applyr.DifferenceBetween(c,r.CommitFrom(c.Sha+'^')) f2wheref1.Path<f2.Pathgroup byf1.Path,f2.PathhavingCount(1)>5order by CoChangesdesc

-- Extract and count imports from protobuf fileswith Importsas (select Replace(Replace(Line,'import "',''),'";','')as ImportPathfrom#flat.file('./proto/service.proto') fwhereLinelike'import "%'  )select  ImportPath,Count(1)as Usagefrom Importsgroup by ImportPath

🚀 Data Sources

⚡ Getting Started

📚 Resources

🎨 Advanced Features

🤔 When to Use Musoq

🐛 Philosophy

📄 License