fmql 0.2.2

A fast and feature-rich file manager written in Rust
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128

# 🔍 FMQL - File Management for People Who Talk to Databases

*Because talking to your files like they're a database is totally normal.*

[![Totally Real Build Status](https://img.shields.io/badge/build-passes%20when%20no%20one%20is%20looking-success)](https://github.com/chriswmann/fmql)
[![Sanity Status](https://img.shields.io/badge/sanity-questionable-yellow)](https://github.com/chriswmann/fmql)

## What is this madness?

FMQL (File Manager Query Language) lets you use SQL (sort of) to manage your files.

Yes it was mostly vibe-coded, I've been meaning to write this for months and this way I finally got round to it.

```sql
SELECT * FROM ~/Documents WHERE size > 1000000 AND modified > '2025-01-01'
-- Translation: "Show me all those chonky files I created this year"
```

## ✨ Features That Will Make Your Files Feel Special

- **SQL-like Querying**: `SELECT * FROM ~/memes WHERE extension = 'jpg' AND name LIKE '%cat%'` because who needs GUI file search when you can type a novel?
- **Slightly Fast**: Traverses your filesystem faster than you can say "where did I put that file again?" ten times.
- **Detailed File Info**: Size, permissions, timestamps, and more. Like `ls -la` but dysfunctional and with a bad attitude.
- **Sophisticated Sorting**: By name, size, modified date, or type.
- **Grouping Options**: Group by extension, permissions, or name patterns.
- **Recursive Listing**: Who needs `fd` when you can use fmql? (Everybody, actually.)
- **Multiple Output Formats**: Text, table, or JSON. Text and table are basically the same so "two output formats" is more accurate.

## 🔧 Installation (No Magic Required)

```bash
# The easy way
cargo install fmql

# The less way
git clone https://github.com/chriswmann/fmql.git
cd fmql
cargo build --release
```

## 📚 Usage: How to Pretend Your File System is a SQL Server DB from 1989?

### Basic File Listing (which will probably be deleted because `ls`, `exa` and `eza` are infinitely better)

```bash
# List files in current directory (boring, but effective)
fmql ls

# Show hidden files (where the real secrets hide)
fmql ls -a

# Detailed listing (for people who need to know EVERYTHING)
fmql ls -l

# Sort by size (big files first, because size matters)
fmql ls -s size

# Recursively list directories (for brave souls)
fmql ls -r
```

### SQL Mode (Because Why Not?)

```bash
# Find all text files in your Documents
fmql sql "SELECT * FROM ~/Documents WHERE extension = 'txt'"

# Find large images modified recently
fmql sql "SELECT * FROM ~/Pictures WHERE (extension = 'jpg' OR extension = 'png') AND size > 1000000 AND modified > '2023-06-01'"

# Find executable scripts (your personal army of automation)
fmql sql "SELECT * FROM ~/scripts WHERE permissions LIKE '%x%'"

# Update file permissions (because chmod is so 1970s)
fmql sql "UPDATE ~/scripts SET permissions = '755' WHERE extension = 'sh'"
```

## 🎮 Command Options

### LS Mode Options

- `-a, --all`: Show hidden files (the ones wearing invisibility cloaks)
- `-l, --long`: Use detailed view (for file stalkers)
- `-s, --sort <OPTION>`: Sort by: `name`, `size`, `modified`, `type` (the Sorting Hat for files)
- `-r, --recursive`: Recursively list directories (it's directories all the way down!)
- `-t, --total`: Show total size (how much disk space you're wasting)
- `-g, --group-by <OPTION>`: Group by: `folder`, `extension`, `permissions`, etc. (file segregation, but the ethical kind)
- `-f, --format <FORMAT>`: Output as: `text`, `table`, `json` (dress your output fancy)

### SQL Query Stuff

FMQL understands these SQL-ish commands:

- `SELECT`: Find files matching specific conditions
- `UPDATE`: Modify file attributes (permissions, etc.)
- `WHERE`: Filter with conditions (`=`, `>`, `<`, `LIKE`, `REGEXP`)
- `WITH RECURSIVE`: Recursively search directories (prepare for deep dives)

## Examples

```bash
# Find all your unfinished projects
fmql sql "SELECT * FROM ~/projects WHERE modified < '2023-01-01' AND NOT name LIKE '%completed%'"

# List all memes sorted by size
fmql sql "SELECT * FROM ~/Downloads WHERE name LIKE '%meme%' ORDER BY size DESC"

# Find screenshots from 3am
fmql sql "SELECT * FROM ~/Pictures WHERE name LIKE '%screenshot%' AND modified LIKE '%03:%'"

# Look for suspicious executables
fmql sql "SELECT * FROM ~/Downloads WHERE is_executable = true AND NOT permission = '755'"
```

## 🤝 Contributing

1. Question your life choices
2. Fork the repo
3. Create your feature branch (`git checkout -b feature/amazing-idea`)
4. Write code that doesn't make kittens cry
5. Commit your changes (`git commit -m 'Added that thing everyone wanted'`)
6. Push to the branch (`git push origin feature/amazing-idea`)
7. Open a Pull Request
8. Wait anxiously for feedback while refreshing GitHub every 30 seconds

## 📜 License

MIT License - Feel free to use this for whatever you like