Models Flags Experiments · Querying PostHog Data · PostHog/skills · Skills Docs

Models Flags Experiments · Querying PostHog Data · PostHog/skills · Skills Docs

Column	Type	Nullable	Description
`id`	Integer	NOT NULL	Flag id.
`team_id`	Integer	NOT NULL
`key`	String	NOT NULL	Flag key used by SDKs to evaluate the flag.
`name`	String	NOT NULL	Human-readable flag name/description.
`filters`	JSON	NOT NULL	JSON targeting rules, variants, and release conditions.
`rollout_percentage`	Integer	NOT NULL	Top-level rollout percentage (0-100); detailed rules live in filters.
`created_by_id`	Integer	NULL	User who created the flag.
`created_at`	DateTime	NOT NULL	When the flag was created.
`deleted`	Integer	NOT NULL	1 if the flag has been deleted, 0 otherwise.

{
  "groups": [
    {
      "properties": [...],
      "rollout_percentage": 50,
      "variant": "test"
    }
  ],
  "multivariate": {
    "variants": [
      {"key": "control", "rollout_percentage": 50},
      {"key": "test", "rollout_percentage": 50}
    ]
  },
  "payloads": {
    "control": {"value": "A"},
    "test": {"value": "B"}
  },
  "aggregation_group_type_index": null
}

Column	Type	Nullable	Description
`id`	Integer	NOT NULL	Experiment id.
`team_id`	Integer	NOT NULL
`name`	String	NOT NULL	Experiment name.
`description`	String	NOT NULL	Experiment description/hypothesis.
`created_by_id`	Integer	NULL	User who created the experiment.
`created_at`	DateTime	NOT NULL	When the experiment was created.
`updated_at`	DateTime	NOT NULL	When the experiment was last updated.
`filters`	JSON	NOT NULL	JSON definition of the experiment’s goal metric filters.
`parameters`	JSON	NOT NULL	JSON experiment parameters (e.g. sample size settings). Flag config such as variants lives on the linked feature flag’s filters, not in this column.
`start_date`	DateTime	NOT NULL	When the experiment was launched; NULL if not started.
`end_date`	DateTime	NOT NULL	When the experiment was concluded; NULL if still running.
`archived`	Integer	NOT NULL	1 if the experiment is archived, 0 otherwise.
`feature_flag_id`	Integer	NOT NULL	Feature flag controlling variant assignment; joins to feature_flags.id.