quietlight/skraak_mcp - Change MFURT7K56GUJH64Z6XRKWKUI4VZZQYR72U2QEQNWR4B3TSUEXPQAC

edits to me.txt and readme

Created by quietlight on March 8, 2026

MFURT7K56GUJH64Z6XRKWKUI4VZZQYR72U2QEQNWR4B3TSUEXPQAC

Dependencies

In channels

main

Change contents

Deletion in me.txt at line 10 [4.1]
B:BD[4.579] → [4.579:580]
Deletion in me.txt at line 14 [4.1]
B:BD[4.875] → [4.875:916]
```
operator and reviewer in file metadata
```
Deletion in me.txt at line 15 [4.1]
B:BD[4.917] → [4.917:968]
```
make a psuedo schema for file and label metadata
```

Deletion in me.txt at line 18 [4.1]

B:BD[4.1071] → [4.1071:1408]

Just the simplest clip viewer and sort in a tui, from db data not avianz data
Make segments from pred and save as json??? / insert into db
Make clip dynamicly in Julia and sort using model, get data from db, modify db weth changes
Img Viewer renders from db and files
User confirms
Update db, inc certainty 
Make export clips tool

Deletion in me.txt at line 22 [4.1]
B:BD[4.1532] → [4.1532:1577]
```
Make import freebird tool
Make import raven
```

Insertion in me.txt at line 23 [4.1]

[4.1578]

Make freebird to .data tool
Make raven to .data tool
Make birda to .data tool

Deletion in me.txt at line 78 [4.1]

B:BD[4.6112] → [4.6112:6685]

time ./skraak calls from-preds --csv /media/david/SSD4/Twenty_Four_Seven/R620/2025-02-25/preds9_opensoundscape-multi-1.0_2025-07-22.csv > /media/david/SSD4/Twenty_Four_Seven/R620/2025-02-25/preds9_opensoundscape-multi-1.0_2025-07-22.json
./skraak calls classify \
        --folder /media/david/SSD4/Pomona/C05/2025-11-08/ \
        --reviewer David \
        --bind k=Kiwi \
        --bind d="Kiwi+Duet" \
        --bind f="Kiwi+Female" \
        --bind m="Kiwi+Male" \
        --bind n="Don't Know" \
        --bind p=Morepork \
        --color \
        --img-dims 224

Deletion in me.txt at line 79 [4.1]

B:BD[4.6686] → [4.6686:7006]

./skraak calls classify \
        --folder /media/david/SSD4/Twenty_Four_Seven/R620/2024-05-06/ \
        --reviewer David \
        --bind k=Kiwi \
        --bind d="Kiwi+Duet" \
        --bind f="Kiwi+Female" \
        --bind m="Kiwi+Male" \
        --bind n="Don't Know" \
        --bind p=Morepork \
        --color

Deletion in README.md at line 4 [7.334405]
∅:D[5.151440] → [6.64385:64386]
B:BD[6.64385] → [6.64385:64386]
B:BD[7.335173] → [7.335173:335198]
B:BD[7.335198] → [5.151441:151460]
∅:D[5.151460] → [7.335360:335374]
B:BD[7.335360] → [7.335360:335374]
```
## Installation
```bash
go build -o skraak
```
## Usage
```
Replacement in README.md at line 5 [7.334405]
B:BD[7.335375] → [5.151461:151476]
```
### MCP Server
```
[7.335375]
[7.335398]
```
## MCP Server
```

Replacement in README.md at line 32 [7.334405]

B:BD[8.4396] → [5.151792:151809]

### CLI Commands

[8.4396]

[8.4625]

### Available MCP Tools (9 total)
**Query:**
- `execute_sql` - Run SQL SELECT queries (JOINs, aggregates, CTEs supported)
- `get_current_time` - Current time with timezone
**Write:**
- `create_or_update_dataset` - Create or update a dataset
- `create_or_update_location` - Create or update a location with GPS/timezone
- `create_or_update_cluster` - Create or update a cluster within a location
- `create_or_update_pattern` - Create or update a cyclic recording pattern
**Import:**
- `import_audio_files` - Batch import WAV files from a folder
- `import_ml_selections` - Import ML-detected selections from folder structure
### Resources & Prompts
MCP server provides:
- `schema://full` - Complete database schema
- `schema://table/{name}` - Individual table definitions
- 6 SQL workflow prompts teaching query patterns
## CLI Commands

Replacement in README.md at line 95 [7.334405]

B:BD[3.232] → [3.232:780]

skraak calls classify --folder 2025-02-25 --reviewer David --color --img-dims 600 --bind a=eurbla, --bind b=nezbel1, --bind c=comcha, --bind d=saddle3, --bind e=pipipi1, --bind f=nezfan1, --bind g=gryger1, --bind i=tui1, --bind k=kea1, --bind l=lotkoe1, --bind m=morepo2, --bind n=nezrob3, --bind o=soioys1, --bind p=malpar2, --bind r=riflem1, --bind s=silver3, --bind t=tomtit1, --bind u=nezpig2, --bind w=nezkak1,  --bind x=Noise, --bind z="Don't Know", --bind 1=Kiwi+Duet, --bind 2=Kiwi+Female, --bind 3=Kiwi+Male, --bind 4=Kiwi, --bind 5=Gecko

[3.232]

[9.3471]

./skraak calls classify \
  --folder /media/david/SSD4/Pomona/C05/2025-11-08/ \
  --reviewer David \
  --bind k=Kiwi \
  --bind d="Kiwi+Duet" \
  --bind f="Kiwi+Female" \
  --bind m="Kiwi+Male" \
  --bind n="Don't Know" \
  --bind p=Morepork \
  --color \
  --img-dims 224
./skraak calls classify --folder 2025-02-25 --reviewer David --color --img-dims 600 \
  --bind a=eurbla, \
  --bind b=nezbel1, \
  --bind c=comcha, \
  --bind d=saddle3, \
  --bind e=pipipi1, \
  --bind f=nezfan1, \
  --bind g=gryger1, \
  --bind i=tui1, \
  --bind k=kea1, \
  --bind l=lotkoe1, \
  --bind m=morepo2, \
  --bind n=nezrob3, \
  --bind o=soioys1, \
  --bind p=malpar2, \
  --bind r=riflem1, \
  --bind s=silver3, \
  --bind t=tomtit1, \
  --bind u=nezpig2, \
  --bind w=nezkak1,  \
  --bind x=Noise, \
  --bind z="Don't Know", \
  --bind 1=Kiwi+Duet, \
  --bind 2=Kiwi+Female, \
  --bind 3=Kiwi+Male, \
  --bind 4=Kiwi, \
  --bind 5=Gecko

Deletion in README.md at line 140 [7.334405]
B:BD[8.4904] → [8.4904:4905]
B:BD[8.4905] → [5.152046:152065]
∅:D[5.152065] → [8.5314:5315]
B:BD[8.5314] → [8.5314:5315]
B:BD[8.5315] → [10.29574:29598]
∅:D[10.29598] → [8.5334:5335]
∅:D[5.152091] → [8.5334:5335]
B:BD[8.5334] → [8.5334:5335]
B:BD[8.5335] → [5.152092:152230]
∅:D[5.152230] → [8.5375:5376]
B:BD[8.5375] → [8.5375:5376]
B:BD[8.5376] → [5.152231:152529]
∅:D[5.152529] → [8.5605:5606]
B:BD[8.5605] → [8.5605:5606]
B:BD[8.5606] → [5.152530:152604]
∅:D[11.1357] → [5.152647:152726]
B:BD[5.152647] → [5.152647:152726]
∅:D[5.152796] → [8.6016:6017]
B:BD[8.6016] → [8.6016:6017]
B:BD[8.6017] → [5.152797:152814]
```
## Available Tools
### MCP Tools (9 total)
**Query:**
- `execute_sql` - Run SQL SELECT queries (JOINs, aggregates, CTEs supported)
- `get_current_time` - Current time with timezone
**Write:**
- `create_or_update_dataset` - Create or update a dataset
- `create_or_update_location` - Create or update a location with GPS/timezone
- `create_or_update_cluster` - Create or update a cluster within a location
- `create_or_update_pattern` - Create or update a cyclic recording pattern
**Import:**
- `import_audio_files` - Batch import WAV files from a folder
- `import_ml_selections` - Import ML-detected selections from folder structure
### CLI Commands
```

Deletion in README.md at line 141 [7.334405]

B:BD[8.6054] → [2.7316:7498]

**New Command Structure (2026-02-21):** Verb-first commands for natural language flow
- `create dataset` instead of `dataset create`
- `update location` instead of `location update`

Deletion in README.md at line 142 [7.334405]

∅:D[2.7499] → [10.29599:29610]

B:BD[8.6054] → [10.29599:29610]

∅:D[10.29610] → [5.152815:152854]

B:BD[8.6054] → [5.152815:152854]

B:BD[5.152854] → [10.29611:29669]

B:BD[10.29669] → [2.7500:7649]

∅:D[2.7649] → [10.29865:29878]

B:BD[10.29865] → [10.29865:29878]

B:BD[10.29878] → [12.18160:18453]

B:BD[12.18453] → [13.42832:42921]

∅:D[12.18453] → [10.30044:30045]

∅:D[13.42921] → [10.30044:30045]

B:BD[10.30044] → [10.30044:30045]

B:BD[10.30045] → [14.352:443]

B:BD[14.443] → [15.558:840]

∅:D[15.840] → [14.443:444]

B:BD[14.443] → [14.443:444]

∅:D[14.444] → [10.30045:30060]

B:BD[10.30045] → [10.30045:30060]

∅:D[10.30060] → [9.3628:3739]

B:BD[5.152898] → [9.3628:3739]

∅:D[9.3739] → [8.6115:6116]

∅:D[5.152898] → [8.6115:6116]

B:BD[8.6115] → [8.6115:6116]

B:BD[8.6116] → [5.152899:152922]

∅:D[5.152922] → [8.6190:6191]

B:BD[8.6190] → [8.6190:6191]

B:BD[8.6191] → [5.152923:153095]

B:BD[5.153095] → [14.445:446]

**Query:**
- `sql` - Execute SQL queries directly
- `time` - Get current time as JSON
**Data Management:**
- `create` - Create new resources (dataset, location, cluster, pattern)
- `update` - Update existing resources (dataset, location, cluster, pattern)
**Import:**
- `import bulk` - Bulk import from CSV file (structured dataset)
- `import file` - Import a single WAV file (structured dataset)
- `import folder` - Import all WAV files from a folder (structured dataset)
- `import selections` - Import ML selections from folder structure (structured dataset)
**Export:**
- `export dataset` - Export a dataset with all related data to new database
**Event Log:**
- `replay events` - Replay event log on backup database for synchronization
**Call Analysis:**
- `calls from-preds` - Extract clustered calls from ML predictions CSV, write .data files
- `calls show-images` - Display spectrogram images from .data file (Kitty/Sixel graphics)
- `calls classify` - Interactive TUI for reviewing and classifying audio segments
**Utilities:**
- `xxhash` - Compute XXH64 hash of a file (JSON output)
- `metadata` - Extract WAV file metadata (JSON output)
## Resources & Prompts
MCP server provides:
- `schema://full` - Complete database schema
- `schema://table/{name}` - Individual table definitions
- 6 SQL workflow prompts teaching query patterns

Replacement in README.md at line 211 [7.334405]

B:BD[15.860] → [15.860:939]

Extract and review bird calls from ML predictions using a three-step workflow.

[15.860]

[13.44030]

Extract and review bird calls from ML predictions.

Replacement in README.md at line 215 [7.334405]

B:BD[15.955] → [15.955:994]

1. **Extract calls from predictions:**

[15.955]

[15.994]

1. **Extract calls from opensoundscape predictions.csv:**

Replacement in README.md at line 218 [7.334405]

B:BD[15.1048] → [15.1048:1697]

./skraak calls from-preds --csv predictions.csv
# JSON output only (no .data files)
./skraak calls from-preds --csv preds.csv --dot-data=false > calls.json
# Override filter name (parsed from CSV filename by default)
./skraak calls from-preds --csv preds.csv --filter my-filter
```
2. **Preview spectrograms:**
```bash
# Display spectrograms from .data file (Kitty graphics protocol)
./skraak calls show-images --file recording.wav.data
# With L4 colormap (Black-Red-Yellow)
./skraak calls show-images --file recording.wav.data --color
# Use Sixel protocol (for non-Kitty terminals)
./skraak calls show-images --file recording.wav.data --sixel

[15.1048]

[15.1697]

# filter parsed from preds.csv filename but can be overriden with --filter birdnet-24
./skraak calls from-preds --csv predictions.csv > calls.json

Replacement in README.md at line 222 [7.334405]
B:BD[15.1702] → [15.1702:1737]
```
3. **Interactive classification:**
```
[15.1702]
[15.1737]
```
2. **Interactive classification:**
```

Replacement in README.md at line 224 [7.334405]

B:BD[15.1745] → [15.1745:1893]

# Launch TUI for reviewing and classifying segments
./skraak calls classify --folder ./data --reviewer David --bind k=Kiwi
# Multiple key bindings

[15.1745]

[15.1893]

# Launch TUI for reviewing and classifying segments (folder, reviewer and 1 key bind required)

Replacement in README.md at line 229 [7.334405]

B:BD[15.2034] → [15.2034:2115]

./skraak calls classify --file recording.wav.data --reviewer David --bind k=Kiwi

[15.2034]

[15.2115]

./skraak calls classify --file recording.wav.data --reviewer David --bind k=Kiwi --bind n='Don''t Know'

Replacement in README.md at line 231 [7.334405]
B:BD[15.2116] → [15.2116:2151]
```
# With color and custom image size
```
[15.2116]
[15.2151]
```
# With color and custom image size (clamps to 224px to 896px)
```
Deletion in README.md at line 238 [7.334405]
B:BD[15.2401] → [15.2401:2402]
∅:D[14.1391] → [5.153096:153108]
∅:D[15.2402] → [5.153096:153108]
∅:D[13.44031] → [5.153096:153108]
B:BD[8.6381] → [5.153096:153108]
```
## Database
```
Deletion in README.md at line 239 [7.334405]
B:BD[8.6580] → [5.153109:153196]
∅:D[8.6726] → [7.336497:336498]
∅:D[5.153196] → [7.336497:336498]
B:BD[7.336497] → [7.336497:336498]
```
- Production: `./db/skraak.duckdb`
- Testing: `./db/test.duckdb` (use for development)
```
Insertion in README.md at line 242 [7.334405]
[7.337718]
[5.153197]
```
# Build
go build -o skraak
```

edits to me.txt and readme

Dependencies

In channels

Change contents

Deletion in me.txt at line 10 [4.1]

Deletion in me.txt at line 14 [4.1]

Deletion in me.txt at line 15 [4.1]

Deletion in me.txt at line 18 [4.1]

Deletion in me.txt at line 22 [4.1]

Insertion in me.txt at line 23 [4.1]

Deletion in me.txt at line 78 [4.1]

Deletion in me.txt at line 79 [4.1]

Deletion in README.md at line 4 [7.334405]

Replacement in README.md at line 5 [7.334405]

Replacement in README.md at line 32 [7.334405]

Replacement in README.md at line 95 [7.334405]

Deletion in README.md at line 140 [7.334405]

Deletion in README.md at line 141 [7.334405]

Deletion in README.md at line 142 [7.334405]

Replacement in README.md at line 211 [7.334405]

Replacement in README.md at line 215 [7.334405]

Replacement in README.md at line 218 [7.334405]

Replacement in README.md at line 222 [7.334405]

Replacement in README.md at line 224 [7.334405]

Replacement in README.md at line 229 [7.334405]

Replacement in README.md at line 231 [7.334405]

Deletion in README.md at line 238 [7.334405]

Deletion in README.md at line 239 [7.334405]

Insertion in README.md at line 242 [7.334405]