quietlight/skraak_mcp - Change NAZQZRYQTXWVE2VFY65ONSD6O3EUMNRHARCDVH2D2HKM3YH4RGUAC

formatting and comments

Created by quietlight on February 11, 2026

NAZQZRYQTXWVE2VFY65ONSD6O3EUMNRHARCDVH2D2HKM3YH4RGUAC

Dependencies

In channels

main

Change contents

Insertion in utils/xxh64.go at line 12 [4.20]

[4.225]

// ComputeXXH64 calculates XXH64 hash of file contents for duplicate detection

Insertion in utils/wav_metadata.go at line 25 [4.697]

[4.1332]

// ParseWAVHeader extracts metadata from WAV file including duration, sample rate, and INFO chunks

Replacement in utils/selection_parser_test.go at line 9 [5.1]

B:BD[5.109] → [5.109:291]

		name             string
		filename         string
		expectedBase     string
		expectedStart    float64
		expectedEnd      float64
		expectError      bool
		errorContains    string

[5.109]

[5.291]

		name          string
		filename      string
		expectedBase  string
		expectedStart float64
		expectedEnd   float64
		expectError   bool
		errorContains string

Replacement in utils/selection_parser_test.go at line 226 [5.1]

B:BD[5.6167] → [5.6167:6281]

		name              string
		wavFiles          []string
		pngFiles          []string
		expectedPaired    []string

[5.6167]

[5.6281]

		name               string
		wavFiles           []string
		pngFiles           []string
		expectedPaired     []string

Replacement in utils/selection_parser_test.go at line 233 [5.1]

B:BD[5.6319] → [5.6319:6551]

			name:           "All files paired",
			wavFiles:       []string{"file1-10-20.wav", "file2-30-40.wav"},
			pngFiles:       []string{"file1-10-20.png", "file2-30-40.png"},
			expectedPaired: []string{"file1-10-20", "file2-30-40"},

[5.6319]

[5.6551]

			name:               "All files paired",
			wavFiles:           []string{"file1-10-20.wav", "file2-30-40.wav"},
			pngFiles:           []string{"file1-10-20.png", "file2-30-40.png"},
			expectedPaired:     []string{"file1-10-20", "file2-30-40"},

Replacement in utils/selection_parser_test.go at line 240 [5.1]

B:BD[5.6595] → [5.6595:6865]

			name:              "Missing PNG for one WAV",
			wavFiles:          []string{"file1-10-20.wav", "file2-30-40.wav", "file3-50-60.wav"},
			pngFiles:          []string{"file1-10-20.png", "file2-30-40.png"},
			expectedPaired:    []string{"file1-10-20", "file2-30-40"},

[5.6595]

[5.6865]

			name:               "Missing PNG for one WAV",
			wavFiles:           []string{"file1-10-20.wav", "file2-30-40.wav", "file3-50-60.wav"},
			pngFiles:           []string{"file1-10-20.png", "file2-30-40.png"},
			expectedPaired:     []string{"file1-10-20", "file2-30-40"},

Replacement in utils/selection_parser_test.go at line 247 [5.1]

B:BD[5.6926] → [5.6926:7106]

			name:              "Missing all PNGs",
			wavFiles:          []string{"file1-10-20.wav", "file2-30-40.wav"},
			pngFiles:          []string{},
			expectedPaired:    []string{},

[5.6926]

[5.7106]

			name:               "Missing all PNGs",
			wavFiles:           []string{"file1-10-20.wav", "file2-30-40.wav"},
			pngFiles:           []string{},
			expectedPaired:     []string{},

Replacement in utils/selection_parser_test.go at line 254 [5.1]

B:BD[5.7186] → [5.7186:7411]

			name:           "Extra PNG files (no WAV)",
			wavFiles:       []string{"file1-10-20.wav"},
			pngFiles:       []string{"file1-10-20.png", "file2-30-40.png", "file3-50-60.png"},
			expectedPaired: []string{"file1-10-20"},

[5.7186]

[5.7411]

			name:               "Extra PNG files (no WAV)",
			wavFiles:           []string{"file1-10-20.wav"},
			pngFiles:           []string{"file1-10-20.png", "file2-30-40.png", "file3-50-60.png"},
			expectedPaired:     []string{"file1-10-20"},

Replacement in utils/selection_parser_test.go at line 261 [5.1]

B:BD[5.7455] → [5.7455:7579]

			name:           "No files",
			wavFiles:       []string{},
			pngFiles:       []string{},
			expectedPaired: []string{},

[5.7455]

[5.7579]

			name:               "No files",
			wavFiles:           []string{},
			pngFiles:           []string{},
			expectedPaired:     []string{},

Insertion in utils/selection_parser.go at line 14 [5.10571]

[5.10909]

// ParseSelectionFilename extracts base filename and time bounds from ML selection filename

Insertion in utils/selection_parser.go at line 56 [5.10571]

[5.12353]

// ParseMLFolderName extracts filter name and date from ML folder structure

Insertion in utils/selection_parser.go at line 75 [5.10571]

[5.13057]

// ValidateWAVPNGPairs checks that WAV and PNG files are properly paired for ML selections

Insertion in utils/selection_parser.go at line 101 [5.10571]

[5.13923]

// ExtractDateTimePattern extracts 6-digit or 8-digit date patterns from filenames

Insertion in utils/filename_parser.go at line 14 [4.5741]
[4.5902]
[4.5902]
```
// Date format constants for filename timestamp parsing
```

Replacement in utils/filename_parser.go at line 16 [4.5741]

B:BD[4.5910] → [4.5910:6164]

	Format8Digit DateFormat = iota // YYYYMMDD_HHMMSS (e.g., 20230609_103000.wav)
	Format6YYMMDD                  // YYMMDD_HHMMSS (e.g., 201012_123456.wav) - year first
	Format6DDMMYY                  // DDMMYY_HHMMSS (e.g., 121020_123456.wav) - year last

[4.5910]

[4.6164]

	Format8Digit  DateFormat = iota // YYYYMMDD_HHMMSS (e.g., 20230609_103000.wav)
	Format6YYMMDD                   // YYMMDD_HHMMSS (e.g., 201012_123456.wav) - year first
	Format6DDMMYY                   // DDMMYY_HHMMSS (e.g., 121020_123456.wav) - year last

Insertion in utils/filename_parser.go at line 47 [4.5741]

[4.6911]

// ParseFilenameTimestamps extracts timestamps from filenames using variance-based format detection

Insertion in utils/filename_parser.go at line 79 [4.5741]

[4.7865]

// ApplyTimezoneOffset converts local timestamps to location timezone with DST handling

Insertion in utils/filename_parser.go at line 261 [4.5741]
[4.12885]
[4.12885]
```
// HasTimestampFilename checks if filename contains a timestamp pattern
```

Insertion in utils/cluster_import.go at line 87 [6.1]

[6.2416]

// ImportCluster imports all WAV files from a folder into a database cluster with transaction safety

Insertion in utils/cluster_import.go at line 180 [6.1]

[6.4841]

// EnsureClusterPath updates cluster with the folder path for file imports

Insertion in utils/audiomoth_parser.go at line 37 [4.13066]
[4.14124]
[4.14124]
```
// IsAudioMoth detects if WAV file is from AudioMoth recorder
```

Insertion in utils/audiomoth_parser.go at line 44 [4.13066]

[4.14377]

// ParseAudioMothComment extracts timestamp, gain, battery, and temperature from AudioMoth comment

Replacement in utils/audiomoth_parser.go at line 63 [4.13066]

B:BD[4.15001] → [4.15001:15296]

	timeStr := matches[1]       // HH:MM:SS
	dateStr := matches[2]       // DD/MM/YYYY
	timezoneStr := matches[3]   // ±HH
	recorderID := matches[4]    // Hex ID
	gainStr := matches[5]       // gain level
	batteryStr := matches[6]    // battery voltage
	tempStr := matches[7]       // temperature

[4.15001]

[4.15296]

	timeStr := matches[1]     // HH:MM:SS
	dateStr := matches[2]     // DD/MM/YYYY
	timezoneStr := matches[3] // ±HH
	recorderID := matches[4]  // Hex ID
	gainStr := matches[5]     // gain level
	batteryStr := matches[6]  // battery voltage
	tempStr := matches[7]     // temperature

Replacement in utils/astronomical_test.go at line 43 [7.53775]

B:BD[7.54980] → [7.54980:55048]

		duration := 60.0                                      // 1 minute

[7.54980]

[7.55048]

		duration := 60.0                                     // 1 minute

Replacement in utils/astronomical_test.go at line 58 [7.53775]

B:BD[7.55529] → [7.55529:55605]

		shortDuration := 30.0   // 30 seconds
		longDuration := 3600.0  // 1 hour

[7.55529]

[7.55605]

		shortDuration := 30.0  // 30 seconds
		longDuration := 3600.0 // 1 hour

Insertion in tools/time.go at line 21 [4.42703]

[3.12381]

// GetCurrentTime returns current system time with timezone and Unix timestamp

Insertion in tools/sql.go at line 20 [4.43910]
[4.44256]
[4.44256]
```
// SetDBPath sets the database path for all tool operations
```

Insertion in tools/sql.go at line 65 [4.43910]

[3.12579]

[4.46213]

// ExecuteSQL executes arbitrary SQL SELECT queries with safety validation and row limiting

Insertion in tools/pattern.go at line 26 [8.4745]

[3.13829]

[8.5834]

// CreateOrUpdatePattern creates a new recording pattern or updates an existing one

Insertion in tools/location.go at line 30 [8.12317]

[3.15754]

[8.13822]

// CreateOrUpdateLocation creates a new location or updates an existing one with GPS coordinates

Replacement in tools/integration_test.go at line 84 [5.18353]

B:BD[5.21184] → [5.21184:21372]

			Query: "SELECT c.name, c.cyclic_recording_pattern_id, p.record_s, p.sleep_s FROM cluster c LEFT JOIN cyclic_recording_pattern p ON c.cyclic_recording_pattern_id = p.id WHERE c.id = ?",

[5.21184]

[5.21372]

			Query:      "SELECT c.name, c.cyclic_recording_pattern_id, p.record_s, p.sleep_s FROM cluster c LEFT JOIN cyclic_recording_pattern p ON c.cyclic_recording_pattern_id = p.id WHERE c.id = ?",

Insertion in tools/import_ml_selections.go at line 63 [5.22689]

[3.18009]

[5.24862]

// ImportMLSelections imports ML-detected kiwi call selections from folder structure

Replacement in tools/import_files.go at line 25 [4.50297]

B:BD[4.51265] → [6.14952:15158]

	Summary ImportSummary          `json:"summary" jsonschema:"Import summary with counts and statistics"`
	FileIDs []string               `json:"file_ids" jsonschema:"List of successfully imported file IDs"`

[4.51265]

[6.15158]

	Summary ImportSummary           `json:"summary" jsonschema:"Import summary with counts and statistics"`
	FileIDs []string                `json:"file_ids" jsonschema:"List of successfully imported file IDs"`

Insertion in tools/import_files.go at line 42 [4.50297]

[3.18381]

[4.52670]

// ImportAudioFiles batch imports WAV files from a folder with hash-based duplicate detection

Insertion in tools/import_file.go at line 57 [9.1]

[3.18790]

[9.1745]

// ImportFile imports a single WAV file into the database with duplicate detection

Insertion in tools/dataset.go at line 26 [8.22019]

[3.19319]

[8.23110]

// CreateOrUpdateDataset creates a new dataset or updates an existing one based on presence of ID

Insertion in tools/cluster.go at line 30 [8.29033]

[3.21138]

[8.30763]

// CreateOrUpdateCluster creates a new cluster or updates an existing one within a location

Insertion in tools/bulk_file_import.go at line 77 [10.1]

[3.23777]

[10.2325]

// BulkFileImport imports WAV files across multiple locations using CSV specification

Insertion in resources/schema.go at line 37 [4.114683]
[4.115239]
[4.115239]
```
// SetSchemaPath sets the file path to the database schema SQL file
```

Insertion in resources/schema.go at line 43 [4.114683]

[4.115367]

// GetSchemaResources returns full schema resource and per-table template resources

Insertion in prompts/examples.go at line 11 [4.120572]

[4.120752]

// GetQueryDatasetsPrompt returns prompt for querying active datasets with SQL examples

Insertion in prompts/examples.go at line 45 [4.120572]

[4.122748]

// GetExploreSchemaPrompt returns prompt for interactive database schema exploration

Insertion in prompts/examples.go at line 151 [4.120572]

[4.129516]

// GetExploreLocationHierarchyPrompt returns prompt for exploring location relationships with JOINs

Replacement in prompts/examples.go at line 182 [4.120572]
B:BD[4.130607] → [4.130607:130624]
```
` + "```sql" + `
```
[4.130607]
[4.131105]
```
`+"```sql"+`
```
Replacement in prompts/examples.go at line 194 [4.120572]
∅:D[5.64912] → [4.131924:131938]
B:BD[4.131924] → [4.131924:131938]
```
` + "```" + `
```
[5.64912]
[4.132285]
```
`+"```"+`
```
Replacement in prompts/examples.go at line 298 [4.120572]
B:BD[4.139818] → [4.139818:139835]
```
` + "```sql" + `
```
[4.139818]
[4.139835]
```
`+"```sql"+`
```
Replacement in prompts/examples.go at line 309 [4.120572]
B:BD[4.140739] → [4.140739:140753]
```
` + "```" + `
```
[4.140074]
[4.140753]
```
`+"```"+`
```

Insertion in main.go at line 30 [4.149392]

[11.1778]

// printUsage displays command-line usage information for all available commands

Replacement in db/types.go at line 69 [4.161605]

B:BD[4.163740] → [4.163740:164164]

		ID           string   `json:"id"`
		DatasetID    string   `json:"dataset_id"`
		Name         string   `json:"name"`
		Latitude     float64  `json:"latitude"`
		Longitude    float64  `json:"longitude"`
		Description  *string  `json:"description"`
		CreatedAt    string   `json:"created_at"`
		LastModified string   `json:"last_modified"`
		Active       bool     `json:"active"`
		TimezoneID   string   `json:"timezone_id"`

[4.163740]

[4.164164]

		ID           string  `json:"id"`
		DatasetID    string  `json:"dataset_id"`
		Name         string  `json:"name"`
		Latitude     float64 `json:"latitude"`
		Longitude    float64 `json:"longitude"`
		Description  *string `json:"description"`
		CreatedAt    string  `json:"created_at"`
		LastModified string  `json:"last_modified"`
		Active       bool    `json:"active"`
		TimezoneID   string  `json:"timezone_id"`

Replacement in db/types.go at line 137 [4.161605]

B:BD[4.166425] → [4.166425:167269]

	ID              string     `json:"id"`
	FileName        string     `json:"file_name"`
	Path            *string    `json:"path"` // nullable
	XXH64Hash       string     `json:"xxh64_hash"`
	LocationID      string     `json:"location_id"`
	TimestampLocal  time.Time  `json:"timestamp_local"`
	ClusterID       *string    `json:"cluster_id"` // nullable
	Duration        float64    `json:"duration"`
	SampleRate      int        `json:"sample_rate"`
	Description     *string    `json:"description"` // nullable
	MaybeSolarNight *bool      `json:"maybe_solar_night"` // nullable
	MaybeCivilNight *bool      `json:"maybe_civil_night"` // nullable
	MoonPhase       *float64   `json:"moon_phase"` // nullable
	CreatedAt       time.Time  `json:"created_at"`
	LastModified    time.Time  `json:"last_modified"`
	Active          bool       `json:"active"`

[4.166425]

[4.167269]

	ID              string    `json:"id"`
	FileName        string    `json:"file_name"`
	Path            *string   `json:"path"` // nullable
	XXH64Hash       string    `json:"xxh64_hash"`
	LocationID      string    `json:"location_id"`
	TimestampLocal  time.Time `json:"timestamp_local"`
	ClusterID       *string   `json:"cluster_id"` // nullable
	Duration        float64   `json:"duration"`
	SampleRate      int       `json:"sample_rate"`
	Description     *string   `json:"description"`       // nullable
	MaybeSolarNight *bool     `json:"maybe_solar_night"` // nullable
	MaybeCivilNight *bool     `json:"maybe_civil_night"` // nullable
	MoonPhase       *float64  `json:"moon_phase"`        // nullable
	CreatedAt       time.Time `json:"created_at"`
	LastModified    time.Time `json:"last_modified"`
	Active          bool      `json:"active"`

Replacement in db/types.go at line 241 [4.161605]

B:BD[4.170325] → [4.170325:170565]

	RecorderID   *string    `json:"recorder_id"`   // nullable
	Gain         *GainLevel `json:"gain"`          // nullable
	BatteryV     *float64   `json:"battery_v"`     // nullable
	TempC        *float64   `json:"temp_c"`        // nullable

[4.170325]

[4.170565]

	RecorderID   *string    `json:"recorder_id"` // nullable
	Gain         *GainLevel `json:"gain"`        // nullable
	BatteryV     *float64   `json:"battery_v"`   // nullable
	TempC        *float64   `json:"temp_c"`      // nullable

Insertion in cmd/sql.go at line 15 [3.18]

[3.160]

// RunSQL handles CLI SQL query execution with direct database access

Insertion in cmd/mcp.go at line 18 [3.1647]

[3.1874]

// RunMCP starts the MCP server on stdio transport with all registered tools and resources

Insertion in cmd/import.go at line 14 [3.9244]

[3.9381]

// RunImport handles CLI import commands (currently only 'bulk' subcommand)

Replacement in .ignore at line 9 [2.1]
B:BD[2.64] → [2.64:75]
```
skraak_mcp
```
[2.64]
```
skraak
```