Source identity
| Field | Recorded value |
|---|---|
| Source type | GitHub source |
| Original record | Janady13/missionmatch / db/seed/cleared_skills_growth.sql |
| Date | Not specified in source |
| Repository | Janady13/missionmatch |
| Revision | 720d47fae476b0d38477ae4401697d372b1ea2bc |
| Branch | feature/opportunity-to-outcome |
| Path or archive member | db/seed/cleared_skills_growth.sql |
| Original SHA-256 | 878797f9ef42eeccc13215f0985419f5a51cd78d33a3ccba48eabeb1d8d60367 |
| Git blob SHA | 3975b9b8b08df4a4f037f109441219792f8f0114 |
| Reading-copy SHA-256 | 878797f9ef42eeccc13215f0985419f5a51cd78d33a3ccba48eabeb1d8d60367 |
Every recorded occurrence
These 2 records contain identical original source bytes. Their paths and revisions remain part of the archive.
| Original record | Branch or archive | Revision / identifier | Original location |
|---|---|---|---|
| Janady13/missionmatch / db/seed/cleared_skills_growth.sql | feature/opportunity-to-outcome | 720d47fae476b0d38477ae4401697d372b1ea2bc | Open original |
| Janady13/missionmatch / db/seed/cleared_skills_growth.sql | feature/aioe-upgrade | 2178e7298d0e5d9af83afa12402fd587f0ba6ed8 | Open original |
Recovered source transcript
Download complete source text ↓209 lines · 14.0 KB
-- Knowledge layer growth: additional curated cleared workforce skills, aliases, and relationships.
-- Companion to cleared_skills.sql and skill_aliases.sql, same editorial rules and same idempotency
-- (ON CONFLICT DO NOTHING). Source label 'curated'. Clearances are NOT skills (scored separately).
-- Apply with the base seeds; promote-ontology then carries curated skills into the global table and
-- embed-backfill vectorizes them for semantic matching. Aliases here are unambiguous expansions in
-- the cleared staffing context.
INSERT INTO skills (name, category, source) VALUES
-- Intel and mission craft
('Full Motion Video Analysis', 'intel', 'curated'),
('Geospatial Analysis', 'intel', 'curated'),
('Order of Battle Analysis', 'intel', 'curated'),
('Link Analysis', 'intel', 'curated'),
('Threat Analysis', 'intel', 'curated'),
('Indications and Warning', 'intel', 'curated'),
('Cyber Threat Intelligence', 'intel', 'curated'),
('Open Source Research', 'intel', 'curated'),
('Digital Network Intelligence', 'intel', 'curated'),
('Foreign Language Analysis', 'intel', 'curated'),
('Requirements Collection', 'intel', 'curated'),
('Watch Officer Operations', 'intel', 'curated'),
-- Space domain
('Space Control', 'space', 'curated'),
('Payload Operations', 'space', 'curated'),
('Flight Dynamics', 'space', 'curated'),
('Launch Operations', 'space', 'curated'),
('RF Systems Engineering', 'space', 'curated'),
('Electro Optical Systems', 'space', 'curated'),
-- Cyber
('Threat Hunting', 'cyber', 'curated'),
('Incident Response', 'cyber', 'curated'),
('Digital Forensics', 'cyber', 'curated'),
('Malware Analysis', 'cyber', 'curated'),
('Reverse Engineering', 'cyber', 'curated'),
('Penetration Testing', 'cyber', 'curated'),
('Vulnerability Management', 'cyber', 'curated'),
('Red Team Operations', 'cyber', 'curated'),
('Blue Team Operations', 'cyber', 'curated'),
('Security Operations Center', 'cyber', 'curated'),
('SIEM Engineering', 'cyber', 'curated'),
('Endpoint Detection and Response', 'cyber', 'curated'),
('Network Traffic Analysis', 'cyber', 'curated'),
('Exploit Development', 'cyber', 'curated'),
('Cyber Protection Team Operations','cyber', 'curated'),
('Zero Trust Architecture', 'cyber', 'curated'),
('Identity and Access Management', 'cyber', 'curated'),
('Privileged Access Management', 'cyber', 'curated'),
-- Compliance and assurance
('Risk Management Framework', 'compliance', 'curated'),
('Assessment and Authorization', 'compliance', 'curated'),
('Security Control Assessment', 'compliance', 'curated'),
('Continuous Monitoring', 'compliance', 'curated'),
('STIG Compliance', 'compliance', 'curated'),
('Security Documentation', 'compliance', 'curated'),
('Supply Chain Risk Management', 'compliance', 'curated'),
('Privacy Engineering', 'compliance', 'curated'),
-- Cloud
('AWS GovCloud', 'cloud', 'curated'),
('Azure Government', 'cloud', 'curated'),
('Cloud Security Engineering', 'cloud', 'curated'),
('Kubernetes Administration', 'cloud', 'curated'),
('Infrastructure as Code', 'cloud', 'curated'),
('Terraform', 'cloud', 'curated'),
('Container Orchestration', 'cloud', 'curated'),
('Site Reliability Engineering', 'cloud', 'curated'),
-- Data and analytics
('Data Engineering', 'data', 'curated'),
('Data Science', 'data', 'curated'),
('Machine Learning Engineering', 'data', 'curated'),
('Natural Language Processing', 'data', 'curated'),
('Computer Vision', 'data', 'curated'),
('Data Visualization', 'data', 'curated'),
('Extract Transform Load', 'data', 'curated'),
('Big Data Analytics', 'data', 'curated'),
-- Platform and tools
('Elasticsearch', 'platform', 'curated'),
('Splunk Administration', 'tool', 'curated'),
('Palantir Foundry', 'tool', 'curated'),
('ServiceNow', 'tool', 'curated'),
('Distributed Common Ground System','platform', 'curated'),
('Global Command and Control System','platform', 'curated'),
('Wireshark', 'tool', 'curated'),
('Nessus', 'tool', 'curated'),
('Metasploit', 'tool', 'curated'),
('IDA Pro', 'tool', 'curated'),
('Ghidra', 'tool', 'curated'),
-- Engineering
('Software Engineering', 'engineering', 'curated'),
('DevSecOps', 'engineering', 'curated'),
('Systems Engineering', 'engineering', 'curated'),
('Model Based Systems Engineering', 'engineering', 'curated'),
('Embedded Systems', 'engineering', 'curated'),
('Signal Processing', 'engineering', 'curated'),
('Network Engineering', 'engineering', 'curated'),
-- Languages (mission relevant)
('Arabic Language', 'language', 'curated'),
('Mandarin Chinese Language', 'language', 'curated'),
('Russian Language', 'language', 'curated'),
('Korean Language', 'language', 'curated'),
('Persian Farsi Language', 'language', 'curated'),
('Pashto Language', 'language', 'curated')
ON CONFLICT (name) DO NOTHING;
-- Aliases: unambiguous full name to canonical skill. Each subselect yields zero rows if the
-- canonical skill is not present, keeping this safely re-runnable in any order.
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'CTI', 'acronym', 'curated', now() FROM skills WHERE name = 'Cyber Threat Intelligence'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'DNI', 'acronym', 'curated', now() FROM skills WHERE name = 'Digital Network Intelligence'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'DFIR', 'acronym', 'curated', now() FROM skills WHERE name = 'Digital Forensics'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'RE', 'acronym', 'curated', now() FROM skills WHERE name = 'Reverse Engineering'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'Pen Testing', 'synonym', 'curated', now() FROM skills WHERE name = 'Penetration Testing'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'SOC', 'acronym', 'curated', now() FROM skills WHERE name = 'Security Operations Center'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'EDR', 'acronym', 'curated', now() FROM skills WHERE name = 'Endpoint Detection and Response'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'ZTA', 'acronym', 'curated', now() FROM skills WHERE name = 'Zero Trust Architecture'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'IAM', 'acronym', 'curated', now() FROM skills WHERE name = 'Identity and Access Management'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'PAM', 'acronym', 'curated', now() FROM skills WHERE name = 'Privileged Access Management'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'RMF', 'acronym', 'curated', now() FROM skills WHERE name = 'Risk Management Framework'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'A and A', 'synonym', 'curated', now() FROM skills WHERE name = 'Assessment and Authorization'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'IaC', 'acronym', 'curated', now() FROM skills WHERE name = 'Infrastructure as Code'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'SRE', 'acronym', 'curated', now() FROM skills WHERE name = 'Site Reliability Engineering'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'ETL', 'acronym', 'curated', now() FROM skills WHERE name = 'Extract Transform Load'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'NLP', 'acronym', 'curated', now() FROM skills WHERE name = 'Natural Language Processing'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'MBSE', 'acronym', 'curated', now() FROM skills WHERE name = 'Model Based Systems Engineering'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'ML Engineering', 'synonym', 'curated', now() FROM skills WHERE name = 'Machine Learning Engineering'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'DCGS', 'acronym', 'curated', now() FROM skills WHERE name = 'Distributed Common Ground System'
ON CONFLICT (lower(alias_text)) DO NOTHING;
INSERT INTO skill_aliases (skill_id, alias_text, alias_type, source, verified_at)
SELECT id, 'GCCS', 'acronym', 'curated', now() FROM skills WHERE name = 'Global Command and Control System'
ON CONFLICT (lower(alias_text)) DO NOTHING;
-- Relationships: substitutes and adjacencies the resolver uses for partial credit. Strengths are
-- editorial and conservative, matching the existing seed convention.
INSERT INTO skill_relationships (from_skill_id, to_skill_id, relation, strength, source, verified_at)
SELECT a.id, b.id, 'related_to', 0.70, 'curated', now()
FROM skills a, skills b WHERE a.name = 'Threat Hunting' AND b.name = 'Incident Response'
ON CONFLICT (from_skill_id, to_skill_id, relation) DO NOTHING;
INSERT INTO skill_relationships (from_skill_id, to_skill_id, relation, strength, source, verified_at)
SELECT a.id, b.id, 'requires', 0.70, 'curated', now()
FROM skills a, skills b WHERE a.name = 'Digital Forensics' AND b.name = 'Incident Response'
ON CONFLICT (from_skill_id, to_skill_id, relation) DO NOTHING;
INSERT INTO skill_relationships (from_skill_id, to_skill_id, relation, strength, source, verified_at)
SELECT a.id, b.id, 'related_to', 0.65, 'curated', now()
FROM skills a, skills b WHERE a.name = 'Red Team Operations' AND b.name = 'Penetration Testing'
ON CONFLICT (from_skill_id, to_skill_id, relation) DO NOTHING;
INSERT INTO skill_relationships (from_skill_id, to_skill_id, relation, strength, source, verified_at)
SELECT a.id, b.id, 'related_to', 0.65, 'curated', now()
FROM skills a, skills b WHERE a.name = 'Blue Team Operations' AND b.name = 'Security Operations Center'
ON CONFLICT (from_skill_id, to_skill_id, relation) DO NOTHING;
INSERT INTO skill_relationships (from_skill_id, to_skill_id, relation, strength, source, verified_at)
SELECT a.id, b.id, 'requires', 0.65, 'curated', now()
FROM skills a, skills b WHERE a.name = 'Machine Learning Engineering' AND b.name = 'Data Science'
ON CONFLICT (from_skill_id, to_skill_id, relation) DO NOTHING;
INSERT INTO skill_relationships (from_skill_id, to_skill_id, relation, strength, source, verified_at)
SELECT a.id, b.id, 'related_to', 0.60, 'curated', now()
FROM skills a, skills b WHERE a.name = 'Natural Language Processing' AND b.name = 'Machine Learning Engineering'
ON CONFLICT (from_skill_id, to_skill_id, relation) DO NOTHING;
INSERT INTO skill_relationships (from_skill_id, to_skill_id, relation, strength, source, verified_at)
SELECT a.id, b.id, 'requires', 0.70, 'curated', now()
FROM skills a, skills b WHERE a.name = 'Kubernetes Administration' AND b.name = 'Container Orchestration'
ON CONFLICT (from_skill_id, to_skill_id, relation) DO NOTHING;
INSERT INTO skill_relationships (from_skill_id, to_skill_id, relation, strength, source, verified_at)
SELECT a.id, b.id, 'requires', 0.65, 'curated', now()
FROM skills a, skills b WHERE a.name = 'DevSecOps' AND b.name = 'Software Engineering'
ON CONFLICT (from_skill_id, to_skill_id, relation) DO NOTHING;
INSERT INTO skill_relationships (from_skill_id, to_skill_id, relation, strength, source, verified_at)
SELECT a.id, b.id, 'related_to', 0.60, 'curated', now()
FROM skills a, skills b WHERE a.name = 'Malware Analysis' AND b.name = 'Reverse Engineering'
ON CONFLICT (from_skill_id, to_skill_id, relation) DO NOTHING;
INSERT INTO skill_relationships (from_skill_id, to_skill_id, relation, strength, source, verified_at)
SELECT a.id, b.id, 'related_to', 0.60, 'curated', now()
FROM skills a, skills b WHERE a.name = 'Terraform' AND b.name = 'Infrastructure as Code'
ON CONFLICT (from_skill_id, to_skill_id, relation) DO NOTHING;