-- Curated cleared workforce skills seed. Idempotent: ON CONFLICT (name) DO NOTHING.
-- Categories: intel, space, cyber, compliance, cloud, platform, data, tool, engineering.
-- Clearances are NOT skills (clearance is a scored component scored separately by the engine).
-- Source label 'curated' marks hand authored entries by the missionMATCH editorial team.

INSERT INTO skills (name, category, source) VALUES
  -- Intel and mission disciplines
  ('SIGINT',                        'intel',       'curated'),
  ('GEOINT',                        'intel',       'curated'),
  ('HUMINT',                        'intel',       'curated'),
  ('MASINT',                        'intel',       'curated'),
  ('OSINT',                         'intel',       'curated'),
  ('Intelligence Analysis',         'intel',       'curated'),
  ('All Source Analysis',           'intel',       'curated'),
  ('Targeting',                     'intel',       'curated'),
  ('Counterintelligence',           'intel',       'curated'),
  ('Collection Management',         'intel',       'curated'),
  ('Imagery Analysis',              'intel',       'curated'),
  ('Signals Collection',            'intel',       'curated'),
  ('Pattern of Life Analysis',      'intel',       'curated'),
  ('Finished Intelligence',         'intel',       'curated'),
  -- Space domain
  ('Satellite C2',                  'space',       'curated'),
  ('TT and C',                      'space',       'curated'),
  ('Space Domain Awareness',        'space',       'curated'),
  ('Orbital Mechanics',             'space',       'curated'),
  ('Space Situational Awareness',   'space',       'curated'),
  ('Ground Station Operations',     'space',       'curated'),
  -- Cleared infrastructure and information security
  ('Cross Domain Solutions',        'cyber',       'curated'),
  ('COMSEC',                        'cyber',       'curated'),
  ('TEMPEST',                       'cyber',       'curated'),
  ('Electronic Warfare',            'cyber',       'curated'),
  ('Vulnerability Management',      'cyber',       'curated'),
  ('Incident Response',             'cyber',       'curated'),
  ('Threat Hunting',                'cyber',       'curated'),
  ('Penetration Testing',           'cyber',       'curated'),
  ('Reverse Engineering',           'cyber',       'curated'),
  ('Malware Analysis',              'cyber',       'curated'),
  ('Digital Forensics',             'cyber',       'curated'),
  ('Security Operations',           'cyber',       'curated'),
  ('Zero Trust Architecture',       'cyber',       'curated'),
  ('Network Security',              'cyber',       'curated'),
  ('Endpoint Detection and Response','cyber',      'curated'),
  -- Compliance and governance frameworks
  ('RMF',                           'compliance',  'curated'),
  ('Authority to Operate',          'compliance',  'curated'),
  ('NIST 800-53',                   'compliance',  'curated'),
  ('NIST 800-171',                  'compliance',  'curated'),
  ('FISMA',                         'compliance',  'curated'),
  ('eMASS',                         'compliance',  'curated'),
  ('ICD 503',                       'compliance',  'curated'),
  ('DISA STIGs',                    'compliance',  'curated'),
  ('FedRAMP',                       'compliance',  'curated'),
  ('CMMC',                          'compliance',  'curated'),
  ('Supply Chain Risk Management',  'compliance',  'curated'),
  -- SIEM, SOAR, and security tooling
  ('SIEM',                          'tool',        'curated'),
  ('SOAR',                          'tool',        'curated'),
  ('Splunk',                        'tool',        'curated'),
  ('Elasticsearch',                 'tool',        'curated'),
  ('Wireshark',                     'tool',        'curated'),
  ('Nessus',                        'tool',        'curated'),
  ('Metasploit',                    'tool',        'curated'),
  ('IDA Pro',                       'tool',        'curated'),
  ('Ghidra',                        'tool',        'curated'),
  -- Cloud and platform
  ('AWS',                           'cloud',       'curated'),
  ('Azure',                         'cloud',       'curated'),
  ('GCP',                           'cloud',       'curated'),
  ('AWS GovCloud',                  'cloud',       'curated'),
  ('Azure Government',              'cloud',       'curated'),
  ('Kubernetes',                    'platform',    'curated'),
  ('Docker',                        'platform',    'curated'),
  ('Terraform',                     'platform',    'curated'),
  ('Ansible',                       'platform',    'curated'),
  ('Linux',                         'platform',    'curated'),
  ('VMware',                        'platform',    'curated'),
  ('OpenShift',                     'platform',    'curated'),
  -- Programming languages and data
  ('Python',                        'data',        'curated'),
  ('Go',                            'data',        'curated'),
  ('Java',                          'data',        'curated'),
  ('SQL',                           'data',        'curated'),
  ('Tableau',                       'tool',        'curated'),
  ('Data Engineering',              'data',        'curated'),
  -- Engineering disciplines
  ('DevSecOps',                     'engineering', 'curated'),
  ('Software Engineering',          'engineering', 'curated'),
  ('Systems Engineering',           'engineering', 'curated'),
  ('Mission Engineering',           'engineering', 'curated'),
  ('Cloud Architecture',            'engineering', 'curated'),
  ('Security Architecture',         'engineering', 'curated'),
  ('Technical Writing',             'engineering', 'curated'),
  -- Language skills relevant to cleared workforce
  ('Arabic',                        'language',    'curated'),
  ('Mandarin',                      'language',    'curated'),
  ('Russian',                       'language',    'curated'),
  ('Farsi',                         'language',    'curated'),
  ('Pashto',                        'language',    'curated')
ON CONFLICT (name) DO NOTHING;