quietlight/skraak_mcp - Change Y5RSXHAZFGNPQ26DRXTCHJV4Y4EZLEGFC2FBRBI5MCMOOYCB7CMAC

commented out FK's from schema

Created by quietlight on April 10, 2026

Y5RSXHAZFGNPQ26DRXTCHJV4Y4EZLEGFC2FBRBI5MCMOOYCB7CMAC

Dependencies

In channels

main

Change contents

Insertion in me.txt at line 1 [4.1]

[4.1]

[3.92]

N14,cMla8Vtfl3uj,/media/david/Pomona-4/Pomona/N14/2026-04-06,2025-14-06,16000,2242
change cluster name to 2026-04-06

Replacement in me.txt at line 213 [4.1]

B:BD[5.1592] → [3.1550:1745]

skraak calls clip --folder . --prefix R620 --output "/home/david/go/src/skraak/.claude/skills/call-classification/Kakariki"  --species malpar2 --filter opensoundscape-multi-1.0 --size 224 --color

[5.1592]

skraak calls clip --folder . --prefix R620 --output "/home/david/go/src/skraak/.claude/skills/call-classification/Kakariki"  --species malpar2 --filter opensoundscape-multi-1.0 --size 224 --color
┌──────────────────────────┬─────────┐
│           tbl            │   cnt   │
│         varchar          │  int64  │
├──────────────────────────┼─────────┤
│ call_type                │      23 │
│ cluster                  │    1210 │
│ cyclic_recording_pattern │       3 │
│ dataset                  │      15 │
│ ebird_taxonomy           │   35306 │
│ file                     │ 1639917 │
│ file_dataset             │ 1639917 │
│ file_metadata            │    5423 │
│ filter                   │       8 │
│ label                    │  200052 │
│ label_metadata           │    7303 │
│ label_subtype            │  114547 │
│ location                 │     787 │
│ moth_metadata            │ 1279386 │
│ segment                  │  201055 │
│ species                  │     356 │
├──────────────────────────┴─────────┤
│ 16 rows                  2 columns │
└────────────────────────────────────┘

Replacement in db/schema.sql at line 30 [7.305331]

B:BD[6.147023] → [2.94:147]

    FOREIGN KEY (dataset_id) REFERENCES dataset(id),

[6.147023]

[6.147076]

    -- FOREIGN KEY (dataset_id) REFERENCES dataset(id),

Replacement in db/schema.sql at line 56 [7.305331]

B:BD[6.147345] → [2.148:343]

    FOREIGN KEY (dataset_id) REFERENCES dataset(id),
    FOREIGN KEY (location_id) REFERENCES location(id),
    FOREIGN KEY (cyclic_recording_pattern_id) REFERENCES cyclic_recording_pattern(id),

[6.147345]

[6.147433]

    -- FOREIGN KEY (dataset_id) REFERENCES dataset(id),
    -- FOREIGN KEY (location_id) REFERENCES location(id),
    -- FOREIGN KEY (cyclic_recording_pattern_id) REFERENCES cyclic_recording_pattern(id),

Replacement in db/schema.sql at line 79 [7.305331]

B:BD[7.311079] → [2.344:484]

    active BOOLEAN DEFAULT TRUE,
    FOREIGN KEY (location_id) REFERENCES location(id),
    FOREIGN KEY (cluster_id) REFERENCES cluster(id)

[7.311079]

[7.311219]

    active BOOLEAN DEFAULT TRUE -- ,
    -- FOREIGN KEY (location_id) REFERENCES location(id),
    -- FOREIGN KEY (cluster_id) REFERENCES cluster(id)

Replacement in db/schema.sql at line 93 [7.305331]

B:BD[7.312215] → [2.485:564]

    active BOOLEAN DEFAULT TRUE,
    FOREIGN KEY (file_id) REFERENCES file(id)

[7.312215]

[7.312294]

    active BOOLEAN DEFAULT TRUE -- ,
    -- FOREIGN KEY (file_id) REFERENCES file(id)

Replacement in db/schema.sql at line 102 [7.305331]

B:BD[7.312631] → [2.565:644]

    active BOOLEAN DEFAULT TRUE,
    FOREIGN KEY (file_id) REFERENCES file(id)

[7.312631]

[7.312710]

    active BOOLEAN DEFAULT TRUE -- ,
    -- FOREIGN KEY (file_id) REFERENCES file(id)

Replacement in db/schema.sql at line 112 [7.305331]

B:BD[7.313159] → [2.645:784]

    PRIMARY KEY (file_id, dataset_id) ,
    FOREIGN KEY (file_id) REFERENCES file(id),
    FOREIGN KEY (dataset_id) REFERENCES dataset(id)

[7.313159]

[7.313297]

    PRIMARY KEY (file_id, dataset_id) -- ,
    -- FOREIGN KEY (file_id) REFERENCES file(id),
    -- FOREIGN KEY (dataset_id) REFERENCES dataset(id)

Replacement in db/schema.sql at line 129 [7.305331]

B:BD[7.314135] → [2.785:1003]

    active BOOLEAN DEFAULT TRUE ,
    FOREIGN KEY (file_id) REFERENCES file(id),
    FOREIGN KEY (dataset_id) REFERENCES dataset(id),
    FOREIGN KEY (file_id, dataset_id) REFERENCES file_dataset(file_id, dataset_id)

[7.314135]

[7.314821]

    active BOOLEAN DEFAULT TRUE -- ,
    -- FOREIGN KEY (file_id) REFERENCES file(id),
    -- FOREIGN KEY (dataset_id) REFERENCES dataset(id),
    -- FOREIGN KEY (file_id, dataset_id) REFERENCES file_dataset(file_id, dataset_id)

Replacement in db/schema.sql at line 162 [7.305331]

B:BD[7.316200] → [2.1004:1142]

    active BOOLEAN DEFAULT TRUE,
    FOREIGN KEY (ebird_code, taxonomy_version) REFERENCES ebird_taxonomy(species_code, taxonomy_version)

[7.316200]

[7.316338]

    active BOOLEAN DEFAULT TRUE -- ,
    -- FOREIGN KEY (ebird_code, taxonomy_version) REFERENCES ebird_taxonomy(species_code, taxonomy_version)

Replacement in db/schema.sql at line 172 [7.305331]

B:BD[7.316828] → [2.1143:1228]

    active BOOLEAN DEFAULT TRUE,
    FOREIGN KEY (species_id) REFERENCES species(id)

[7.316828]

[7.316913]

    active BOOLEAN DEFAULT TRUE -- ,
    -- FOREIGN KEY (species_id) REFERENCES species(id)

Replacement in db/schema.sql at line 193 [7.305331]

B:BD[7.317813] → [2.1229:1427]

    active BOOLEAN NOT NULL DEFAULT true,
    FOREIGN KEY (segment_id) REFERENCES segment(id),
    FOREIGN KEY (species_id) REFERENCES species(id),
    FOREIGN KEY (filter_id) REFERENCES filter(id)

[7.317813]

[8.8680]

    active BOOLEAN NOT NULL DEFAULT true -- ,
    -- FOREIGN KEY (segment_id) REFERENCES segment(id),
    -- FOREIGN KEY (species_id) REFERENCES species(id),
    -- FOREIGN KEY (filter_id) REFERENCES filter(id)

Replacement in db/schema.sql at line 204 [7.305331]

B:BD[9.1829] → [2.1428:1509]

    active BOOLEAN DEFAULT TRUE,
    FOREIGN KEY (label_id) REFERENCES label(id)

[9.1829]

[7.318015]

    active BOOLEAN DEFAULT TRUE -- ,
    -- FOREIGN KEY (label_id) REFERENCES label(id)

Replacement in db/schema.sql at line 216 [7.305331]

B:BD[7.318630] → [2.1510:1707]

    active BOOLEAN NOT NULL DEFAULT true,
    FOREIGN KEY (label_id) REFERENCES label(id),
    FOREIGN KEY (calltype_id) REFERENCES call_type(id),
    FOREIGN KEY (filter_id) REFERENCES filter(id)

[7.318630]

[6.148978]

    active BOOLEAN NOT NULL DEFAULT true -- ,
    -- FOREIGN KEY (label_id) REFERENCES label(id),
    -- FOREIGN KEY (calltype_id) REFERENCES call_type(id),
    -- FOREIGN KEY (filter_id) REFERENCES filter(id)

Replacement in db/schema.sql at line 223 [7.305331]

B:BD[6.149417] → [6.149417:149521]

CREATE INDEX idx_file_location ON file(location_id);
CREATE INDEX idx_file_cluster ON file(cluster_id);

[6.149417]

[6.149521]

-- CREATE INDEX idx_file_location ON file(location_id);
-- CREATE INDEX idx_file_cluster ON file(cluster_id);

Replacement in db/schema.sql at line 226 [7.305331]

B:BD[6.149573] → [6.149573:149637]

CREATE INDEX idx_file_timestamp_local ON file(timestamp_local);

[6.149573]

[10.131738]

-- CREATE INDEX idx_file_timestamp_local ON file(timestamp_local);

Replacement in db/schema.sql at line 228 [7.305331]

B:BD[10.131781] → [10.131781:131889]

CREATE INDEX idx_segment_file ON segment(file_id);
CREATE INDEX idx_segment_dataset ON segment(dataset_id);

[10.131781]

[6.149798]

-- CREATE INDEX idx_segment_file ON segment(file_id);
-- CREATE INDEX idx_segment_dataset ON segment(dataset_id);

Replacement in db/schema.sql at line 231 [7.305331]

B:BD[6.149839] → [10.131890:131946]

∅:D[10.131946] → [6.149899:149955]

B:BD[6.149899] → [6.149899:149955]

CREATE INDEX idx_label_segment_id ON label(segment_id);
CREATE INDEX idx_label_species_id ON label(species_id);

[6.149839]

[6.149955]

-- CREATE INDEX idx_label_segment_id ON label(segment_id);
-- CREATE INDEX idx_label_species_id ON label(species_id);

Replacement in db/schema.sql at line 234 [7.305331]

B:BD[6.150004] → [6.150004:150216]

CREATE INDEX idx_label_subtype_label_id ON label_subtype(label_id);
CREATE INDEX idx_label_subtype_calltype_id ON label_subtype(calltype_id);
CREATE INDEX idx_label_subtype_filter_id ON label_subtype(filter_id);

[6.150004]

[6.150216]

-- CREATE INDEX idx_label_subtype_label_id ON label_subtype(label_id);
-- CREATE INDEX idx_label_subtype_calltype_id ON label_subtype(calltype_id);
-- CREATE INDEX idx_label_subtype_filter_id ON label_subtype(filter_id);

Replacement in db/schema.sql at line 238 [7.305331]

B:BD[6.150275] → [6.150275:150371]

CREATE INDEX idx_ebird_taxonomy_species_code ON ebird_taxonomy(species_code, taxonomy_version);

[6.150275]

[6.150371]

-- CREATE INDEX idx_ebird_taxonomy_species_code ON ebird_taxonomy(species_code, taxonomy_version);

Replacement in db/schema.sql at line 240 [7.305331]

B:BD[6.150405] → [6.150405:150472]

CREATE INDEX idx_file_dataset_dataset ON file_dataset(dataset_id);

[6.150405]

[11.189]

-- CREATE INDEX idx_file_dataset_dataset ON file_dataset(dataset_id);