Systematic Review skill for Codex

PRISMA rigor from protocol to flow diagram. Codex sets up a systematic review the way methodologists expect: a PICO question, a protocol registered before screening, database-specific search strategies with full logs, dual independent screening and extraction, risk-of-bias tools matched to study design, random-effects meta-analysis in metafor or a SWiM narrative synthesis, GRADE certainty, and a PRISMA 2020 report whose flow numbers add up.

  • Research
  • $systematic-review
  • 174 lines
  • 3 files
  • ~2,100 tokens
  • MIT
  • Updated

Install

curl -fsSL codexskills.dev/install.sh \  | sh -s -- systematic-review

Installs to ~/.agents/skills/systematic-review/ for every project on this machine.

104-line POSIX script. No sudo, no telemetry. Read install.sh

Use it in Codex

Start a prompt with $systematic-review, or pick it from /skills. You can also just describe the task: Codex reads the description below and loads the playbook when your request matches.

What Codex reads before loading it

Plans and runs systematic reviews to PRISMA 2020 - PICO question, registered protocol (PROSPERO or OSF), reproducible multi-database Boolean searches, dual independent screening with agreement stats, data extraction forms, risk-of-bias tools (RoB 2, ROBINS-I), meta-analysis or structured narrative synthesis, GRADE certainty, and the PRISMA flow diagram. Use when asked for a systematic review or meta-analysis, a review protocol, a PRISMA flow diagram or checklist, or a rigorous evidence review of an intervention, exposure or diagnostic test.

Use it when

  • You are planning or running a systematic review or meta-analysis
  • You need a PRISMA flow diagram or checklist for a manuscript
  • A reviewer asked for a reproducible search strategy or risk-of-bias assessment

Use something else when

How to check the result

Flow diagram counts reconcile at every stage, every included study has dual extraction and risk-of-bias records, and the analysis script reruns to the reported estimates.

The mistake it prevents

Changing eligibility criteria or outcomes after seeing results without reporting the deviation from the registered protocol.

~/.agents/skills/systematic-review/SKILL.md

--- name: systematic-review description: Plans and runs systematic reviews to PRISMA 2020 - PICO question, registered protocol (PROSPERO or OSF), reproducible multi-database Boolean… license: MIT ---

A systematic review is defined by its method, not its length: the question and methods are fixed in a protocol before results are seen, searches are reproducible, screening and extraction are done by two people independently, every study’s risk of bias is assessed, and the report accounts for every record from search to inclusion.

Health and policy reviews inform real decisions. Codex can draft protocols, search strings, forms, code and text, but a second human reviewer is required for screening and extraction, and an information specialist and a statistician should review the search and analysis. Say so in the plan.

Workflow

- [ ] 1. Frame the question (PICO or variant) and check for existing reviews
- [ ] 2. Write and register the protocol before screening
- [ ] 3. Build and peer-review the search; run it in 2+ databases plus grey literature
- [ ] 4. De-duplicate; screen titles/abstracts, then full texts, in duplicate
- [ ] 5. Extract data in duplicate with a piloted form
- [ ] 6. Assess risk of bias per study (per outcome where the tool requires)
- [ ] 7. Synthesise: meta-analysis if appropriate, else structured synthesis (SWiM)
- [ ] 8. Rate certainty with GRADE; write to PRISMA 2020

1. Question

FrameworkUse forElements
PICOInterventionsPopulation, Intervention, Comparator, Outcome(s) (+ study design, time)
PECOExposuresPopulation, Exposure, Comparator, Outcome
PIRD / PITDiagnostic accuracyPopulation, Index test, Reference standard, Diagnosis
SPIDERQualitative evidenceSample, Phenomenon of Interest, Design, Evaluation, Research type

Search PROSPERO, the Cochrane Library and recent literature for an existing or ongoing review first. If one exists and is recent, an update or a different question is better than a duplicate.

2. Protocol

Follow PRISMA-P. Fix: eligibility criteria, primary and secondary outcomes (with time points), databases, screening process, extraction items, risk-of-bias tool, effect measures, synthesis and heterogeneity plan, subgroup and sensitivity analyses, and certainty assessment. Register on PROSPERO (health outcomes) or OSF Registries (other fields) before screening starts. Any later change is reported as a deviation with reason.

Build one concept block per PICO element (usually P and I only; outcomes are often poorly indexed), combining controlled vocabulary and free text:

#1 "Diabetes Mellitus, Type 2"[Mesh] OR "type 2 diabet*"[tiab] OR T2DM[tiab]
#2 "Telemedicine"[Mesh] OR telehealth[tiab] OR telemonitor*[tiab] OR "remote monitor*"[tiab] OR mHealth[tiab]
#3 randomized controlled trial[pt] OR randomi*[tiab] OR placebo[tiab] OR trial[tiab]
#4 #1 AND #2 AND #3
  • Translate the strategy for each database (MEDLINE/PubMed, Embase, CENTRAL, plus discipline databases such as CINAHL, PsycINFO, Scopus, Web of Science, IEEE Xplore). Syntax, field tags and thesauri differ; never paste one string into all.
  • Grey literature and registries: ClinicalTrials.gov, WHO ICTRP, preprint servers, theses, regulator documents. Plus citation chasing of included studies.
  • Record for each source: interface, date run, full strategy, limits, hits. Report the full strategies in a supplement (PRISMA-S).
  • Ask for a peer review of the search by an information specialist (PRESS checklist).
  • Re-run searches shortly before final analysis if months have passed.

Database access usually needs institutional login and network; the user runs searches that require credentials, and exports results (RIS, CSV) into the project.

4. Screening

  • De-duplicate across databases (reference manager or deduplication tool), keeping a count of removed duplicates.
  • Pilot the criteria on 50-100 records with both reviewers; refine wording, not scope.
  • Two reviewers screen independently (Rayyan, Covidence, or ASReview for active-learning prioritisation). Report Cohen’s kappa or percent agreement; resolve conflicts by discussion or a third reviewer.
  • Full-text exclusions need a single primary reason each; those reasons appear in the flow diagram.

5. Extraction

Build the form in a spreadsheet or the screening tool; pilot on 2-3 studies. Typical fields: study ID, design, setting, country, funding, participant characteristics, arms and n, intervention details, comparator, outcomes with definitions and time points, effect data (means, SDs, events, n), risk-of-bias judgements, notes. Extract in duplicate; contact authors for missing data and record the attempts.

6. Risk of bias

DesignTool
Randomised trialsCochrane RoB 2 (per outcome, five domains)
Non-randomised studies of interventionsROBINS-I (or its updated version)
Diagnostic accuracyQUADAS-2
Observational exposure studiesROBINS-E or a validated scale agreed in the protocol
Systematic reviews (overviews)AMSTAR 2, ROBIS

Present a traffic-light summary per study and domain; robvis in R draws these.

7. Synthesis

Meta-analyse only when studies are similar enough in population, intervention, comparator and outcome. Default model: random effects with REML for tau-squared and Hartung-Knapp-Sidik-Jonkman confidence intervals, in R metafor or meta:

library(metafor)
dat <- escalc(measure = "SMD", m1i = m1, sd1i = sd1, n1i = n1,
              m2i = m2, sd2i = sd2, n2i = n2, data = studies)
res <- rma(yi, vi, data = dat, method = "REML", test = "knha")
summary(res); predict(res)          # includes the prediction interval
forest(res); funnel(res)
  • Report heterogeneity (tau-squared, I-squared) and the prediction interval, not only the pooled estimate.
  • Funnel plots and Egger’s test only with roughly 10 or more studies.
  • Run pre-specified sensitivity analyses (excluding high risk-of-bias studies) and label any unplanned analysis as post hoc.
  • When meta-analysis is not appropriate, follow SWiM guidance: group studies, use a consistent effect direction metric, and tabulate; never vote-count significance.

8. Certainty and reporting

Rate each key outcome with GRADE (high, moderate, low, very low), considering risk of bias, inconsistency, indirectness, imprecision and publication bias. Present a Summary of Findings table. Write the report against the PRISMA 2020 checklist and include the flow diagram. For the item-by-item reporting checklist and the flow-diagram template, read references/prisma-reporting.md when drafting the manuscript or checking it before submission.

Gotchas

  • Changing outcomes or criteria after seeing results without reporting it is outcome switching; the protocol exists to prevent this.
  • Search filters for study design save time but cut sensitivity; use validated filters.
  • Multiple reports of one study (conference abstract, journal paper, follow-up) count as one study; link them before analysis.
  • Mixing change scores and final values, or different scales, needs care (SMD, or converting); check units of every extracted number.
  • Single-reviewer screening by an AI or a person alone does not meet the method; AI can prioritise or act as a check, documented in methods.
  • Narrative reviews dressed as systematic ones get rejected; if the protocol cannot be followed, call it a scoping or narrative review ($literature-review).

Verification

  • Flow diagram numbers add up at every stage.
  • Every included study has extraction and risk-of-bias records from two reviewers.
  • Search strategies in the supplement reproduce the reported hit counts.
  • All PRISMA 2020 items are addressed or marked not applicable with reason.
  • Analysis code reruns from the extraction file to the same estimates.

Output (project structure)

review/
  protocol.md            # PRISMA-P, registration ID, deviations log
  search/                # one file per database: strategy, date, hits, exports (RIS)
  screening/             # decisions with reasons, kappa calculation
  extraction/form.xlsx   # piloted form; dual extraction + reconciled sheet
  rob/                   # risk-of-bias judgements with support quotes
  analysis/              # R scripts, outputs, forest and funnel plots
  manuscript/            # report, PRISMA checklist, flow diagram, SoF tables

What the zip contains

Codex reads bundled files only when a step points to them. Every one is shown here, so you can review it before installing.

agents/openai.yamlgenerated from this page

Gives the Codex app a display name, a one-line description and a starter prompt for this skill.

interface:
  display_name: "Systematic Review"
  short_description: "PRISMA rigor from protocol to flow diagram"
  default_prompt: "$systematic-review Help me write a PROSPERO protocol for a review of telehealth in type 2 diabetes"
references/prisma-reporting.md97 lines, 4.5 KB
# PRISMA 2020 reporting: working checklist and flow diagram

This is a paraphrased working aid, grouped by manuscript section. Always check the
final manuscript against the official PRISMA 2020 checklist and its explanation and
elaboration paper, and any journal-specific requirements. For abstracts, PRISMA 2020
also has a separate 12-item abstract checklist.

## Item map (27 items, some with sub-items)

### Title and abstract
- Title says the work is a systematic review (and meta-analysis, if one is done).
- Structured abstract following the PRISMA abstract checklist: objectives, eligibility,
  sources and dates, risk-of-bias method, synthesis method, number of studies and
  participants, main results with effect sizes and certainty, limitations, funding,
  registration.

### Introduction
- Rationale: what is already known and why this review is needed now.
- Objectives framed explicitly (PICO or equivalent).

### Methods
- Eligibility criteria and how studies were grouped for synthesis.
- Every information source with the last date searched.
- Full search strategies for all databases, registers and websites, including limits.
- Selection process: number of reviewers, independence, automation tools used.
- Data collection process: reviewers, independence, contacting authors, tools.
- Data items: all outcomes sought (and which results were eligible per outcome), plus
  other variables (participants, interventions, funding) and assumptions for missing data.
- Risk-of-bias tool(s), reviewers and process.
- Effect measures per outcome (risk ratio, mean difference, SMD, ...).
- Synthesis methods: eligibility for each synthesis, data preparation, tabulation and
  visual display, model and software, heterogeneity exploration, sensitivity analyses.
- Reporting bias assessment method.
- Certainty assessment method (for example GRADE).

### Results
- Study selection: numbers at each stage (flow diagram) and studies that looked
  eligible but were excluded, with reasons.
- Characteristics of each included study, with citation.
- Risk-of-bias results per study.
- Results of individual studies: summary data per group and effect estimates with
  precision, ideally in tables or forest plots.
- Results of syntheses: study characteristics and risk of bias contributing to each,
  pooled estimates with confidence intervals and heterogeneity, results of
  heterogeneity investigations and sensitivity analyses.
- Reporting bias assessments.
- Certainty of evidence per outcome.

### Discussion
- Interpretation in the context of other evidence.
- Limitations of the included evidence.
- Limitations of the review process.
- Implications for practice, policy and future research.

### Other information
- Registration name and number, or a statement that it was not registered.
- Where the protocol can be accessed, or that none was prepared.
- Amendments to registration or protocol, with reasons.
- Sources of support and the role of funders.
- Competing interests of review authors.
- Availability of data, code, extraction forms and other materials.

## Flow diagram template (new review, databases plus other sources)

```text
IDENTIFICATION
  Records from databases (n = )           Records from other sources (n = )
    per database: MEDLINE n= , Embase n= ,   websites n= , registers n= ,
    CENTRAL n=                               citation searching n=
  Records removed before screening:
    duplicates (n = ), marked ineligible by automation (n = ), other reasons (n = )

SCREENING
  Records screened (n = )             -> Records excluded (n = )
  Reports sought for retrieval (n = ) -> Reports not retrieved (n = )
  Reports assessed for eligibility (n = )
                                      -> Reports excluded, by reason:
                                           wrong population (n = )
                                           wrong comparator (n = )
                                           wrong design (n = ) ...

INCLUDED
  Studies included in review (n = )
  Reports of included studies (n = )
  Studies in meta-analysis (n = )   (if applicable)
```

Arithmetic checks before submitting:

- identified - removed before screening = screened
- screened - excluded = sought for retrieval
- sought - not retrieved = assessed for eligibility
- assessed - excluded (sum of reasons) = reports of included studies
- Studies can be fewer than reports when several reports describe one study.

Updated reviews use the variant of the diagram that shows studies carried over from the
previous version alongside new records.

About this skill

Written and maintained by the Codex Skills editors to the same editorial standard as every skill here: a selective description, a real workflow, known pitfalls and a way to verify the work. First published , last updated . MIT licensed. Something wrong or out of date? Tell us.

esc
Just launched

Codex Skills Pro is live

79 premium skills for Codex, each with scripts, references and an evidence report that proves the result.

Bought one by one$882.21
All 79 skills$49
94% off

That's $0.62 a skill, paid once.

Get all 79 for $49Or pick single skills from $4.99 →

Secure checkout by Creem