Models Variables · Querying PostHog Data · PostHog/skills · Skills Docs

Models Variables · Querying PostHog Data · PostHog/skills · Skills Docs

-- Basic
SELECT * FROM events WHERE event = {variables.event_names}

-- Optional string (empty check)
WHERE (coalesce({variables.org}, '') = '' OR properties.org = {variables.org})

-- Optional nullable (null check)
WHERE ({variables.browser} IS NULL OR properties.$browser = {variables.browser})

-- Multiselect List variable
WHERE event IN {variables.event_names}

-- List all
SELECT id, name, code_name, type, default_value FROM system.insight_variables

-- Find by name
SELECT * FROM system.insight_variables WHERE name ILIKE '%event%'

-- Find by type
SELECT * FROM system.insight_variables WHERE type = 'List'

-- Get by code_name
SELECT * FROM system.insight_variables WHERE code_name = 'event_names'

-- Full filter (includes properties, date range, test account exclusions)
SELECT * FROM events WHERE {filters}

-- Direct date access
SELECT * FROM events
WHERE timestamp >= {filters.dateRange.from}
  AND timestamp < {filters.dateRange.to}

-- Combined with variables
SELECT * FROM events
WHERE event = {variables.event_names}
  AND timestamp >= {filters.dateRange.from}