PostHog query API

The query API from PostHog — 14 operation(s) for query.

Operations 16

POST /api/environments/{environment_id}/query/ #
GET /api/environments/{environment_id}/query/{id}/ #
DELETE /api/environments/{environment_id}/query/{id}/ #
GET /api/environments/{environment_id}/query/{id}/log/ #
POST /api/environments/{environment_id}/query/{query_kind}/ #
POST /api/environments/{environment_id}/query/check_auth_for_async/ #
GET /api/environments/{environment_id}/query/draft_sql/ #
POST /api/environments/{environment_id}/query/upgrade/ #
POST /api/projects/{project_id}/query/ #
GET /api/projects/{project_id}/query/{id}/ #
DELETE /api/projects/{project_id}/query/{id}/ #
GET /api/projects/{project_id}/query/{id}/log/ #
POST /api/projects/{project_id}/query/{query_kind}/ #
POST /api/projects/{project_id}/query/check_auth_for_async/ #
GET /api/projects/{project_id}/query/draft_sql/ #
POST /api/projects/{project_id}/query/upgrade/ #

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API
curl "https://apis.io/api/v1/apis/posthog-query-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

posthog-query-api-openapi.yml Raw ↑
openapi: 3.2.0
info:
  title: PostHog actions Query API
  version: 1.0.0
  description: ''
servers:
- url: https://app.posthog.com/api
  description: Base URL declared by the provider in apis.yml (roadmap#122).
tags:
- name: query
paths:
  /api/environments/{environment_id}/query/:
    post:
      operationId: environments_query_create
      description: 'DRF ViewSet mixin that gates coalesced responses behind permission checks.


        The QueryCoalescingMiddleware attaches cached response data to

        request.META["_coalesced_response"] for followers. This mixin runs DRF''s

        initial() (auth + permissions + throttling) before returning the

        cached response, ensuring the request is authorized.'
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      tags:
      - query
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/QueryRequest'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/QueryRequest'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/QueryRequest'
        required: true
      security:
      - PersonalAPIKeyAuth:
        - query:read
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/QueryResponseAlternative'
          description: ''
      deprecated: true
      x-explicit-tags: []
  /api/environments/{environment_id}/query/{id}/:
    get:
      operationId: environments_query_retrieve
      description: (Experimental)
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
        required: true
      tags:
      - query
      security:
      - PersonalAPIKeyAuth:
        - query:read
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/QueryStatusResponse'
          description: ''
      deprecated: true
      x-explicit-tags: []
    delete:
      operationId: environments_query_destroy
      description: (Experimental)
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
        required: true
      tags:
      - query
      security:
      - PersonalAPIKeyAuth:
        - query:read
      responses:
        '204':
          description: Query cancelled
      deprecated: true
      x-explicit-tags: []
  /api/environments/{environment_id}/query/{id}/log/:
    get:
      operationId: environments_query_log_retrieve
      description: Get query log details from query_log_archive table for a specific query_id, the query must have been issued in last 24 hours.
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: id
        schema:
          type: string
        required: true
      tags:
      - query
      responses:
        '200':
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
          description: ''
      deprecated: true
      x-explicit-tags: []
  /api/environments/{environment_id}/query/{query_kind}/:
    post:
      operationId: environments_query_create_with_kind
      description: 'DRF ViewSet mixin that gates coalesced responses behind permission checks.


        The QueryCoalescingMiddleware attaches cached response data to

        request.META["_coalesced_response"] for followers. This mixin runs DRF''s

        initial() (auth + permissions + throttling) before returning the

        cached response, ensuring the request is authorized.'
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      - in: path
        name: query_kind
        schema:
          type: string
          pattern: ^[A-Z][A-Za-z]*$
        required: true
      tags:
      - query
      responses:
        '200':
          description: No response body
      deprecated: true
      x-explicit-tags: []
  /api/environments/{environment_id}/query/check_auth_for_async/:
    post:
      operationId: environments_query_check_auth_for_async_create
      description: 'DRF ViewSet mixin that gates coalesced responses behind permission checks.


        The QueryCoalescingMiddleware attaches cached response data to

        request.META["_coalesced_response"] for followers. This mixin runs DRF''s

        initial() (auth + permissions + throttling) before returning the

        cached response, ensuring the request is authorized.'
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      tags:
      - query
      responses:
        '200':
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
          description: ''
      deprecated: true
      x-explicit-tags: []
  /api/environments/{environment_id}/query/draft_sql/:
    get:
      operationId: environments_query_draft_sql_retrieve
      description: 'DRF ViewSet mixin that gates coalesced responses behind permission checks.


        The QueryCoalescingMiddleware attaches cached response data to

        request.META["_coalesced_response"] for followers. This mixin runs DRF''s

        initial() (auth + permissions + throttling) before returning the

        cached response, ensuring the request is authorized.'
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      tags:
      - query
      responses:
        '200':
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
          description: ''
      deprecated: true
      x-explicit-tags: []
  /api/environments/{environment_id}/query/upgrade/:
    post:
      operationId: environments_query_upgrade_create
      description: Upgrades a query without executing it. Returns a query with all nodes migrated to the latest version.
      parameters:
      - $ref: '#/components/parameters/EnvironmentIdPath'
      tags:
      - query
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/QueryUpgradeRequest'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/QueryUpgradeRequest'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/QueryUpgradeRequest'
        required: true
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/QueryUpgradeResponse'
          description: ''
      deprecated: true
      x-explicit-tags: []
  /api/projects/{project_id}/query/:
    post:
      operationId: query_create
      description: 'DRF ViewSet mixin that gates coalesced responses behind permission checks.


        The QueryCoalescingMiddleware attaches cached response data to

        request.META["_coalesced_response"] for followers. This mixin runs DRF''s

        initial() (auth + permissions + throttling) before returning the

        cached response, ensuring the request is authorized.'
      parameters:
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - query
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/QueryRequest'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/QueryRequest'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/QueryRequest'
        required: true
      security:
      - PersonalAPIKeyAuth:
        - query:read
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/QueryResponseAlternative'
          description: ''
      x-explicit-tags: []
  /api/projects/{project_id}/query/{id}/:
    get:
      operationId: query_retrieve
      description: (Experimental)
      parameters:
      - in: path
        name: id
        schema:
          type: string
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - query
      security:
      - PersonalAPIKeyAuth:
        - query:read
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/QueryStatusResponse'
          description: ''
      x-explicit-tags: []
    delete:
      operationId: query_destroy
      description: (Experimental)
      parameters:
      - in: path
        name: id
        schema:
          type: string
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - query
      security:
      - PersonalAPIKeyAuth:
        - query:read
      responses:
        '204':
          description: Query cancelled
      x-explicit-tags: []
  /api/projects/{project_id}/query/{id}/log/:
    get:
      operationId: query_log_retrieve
      description: Get query log details from query_log_archive table for a specific query_id, the query must have been issued in last 24 hours.
      parameters:
      - in: path
        name: id
        schema:
          type: string
        required: true
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - query
      responses:
        '200':
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
          description: ''
      x-explicit-tags: []
  /api/projects/{project_id}/query/{query_kind}/:
    post:
      operationId: query_create_with_kind
      description: 'DRF ViewSet mixin that gates coalesced responses behind permission checks.


        The QueryCoalescingMiddleware attaches cached response data to

        request.META["_coalesced_response"] for followers. This mixin runs DRF''s

        initial() (auth + permissions + throttling) before returning the

        cached response, ensuring the request is authorized.'
      parameters:
      - $ref: '#/components/parameters/ProjectIdPath'
      - in: path
        name: query_kind
        schema:
          type: string
          pattern: ^[A-Z][A-Za-z]*$
        required: true
      tags:
      - query
      responses:
        '200':
          description: No response body
      x-explicit-tags: []
  /api/projects/{project_id}/query/check_auth_for_async/:
    post:
      operationId: query_check_auth_for_async_create
      description: 'DRF ViewSet mixin that gates coalesced responses behind permission checks.


        The QueryCoalescingMiddleware attaches cached response data to

        request.META["_coalesced_response"] for followers. This mixin runs DRF''s

        initial() (auth + permissions + throttling) before returning the

        cached response, ensuring the request is authorized.'
      parameters:
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - query
      responses:
        '200':
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
          description: ''
      x-explicit-tags: []
  /api/projects/{project_id}/query/draft_sql/:
    get:
      operationId: query_draft_sql_retrieve
      description: 'DRF ViewSet mixin that gates coalesced responses behind permission checks.


        The QueryCoalescingMiddleware attaches cached response data to

        request.META["_coalesced_response"] for followers. This mixin runs DRF''s

        initial() (auth + permissions + throttling) before returning the

        cached response, ensuring the request is authorized.'
      parameters:
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - query
      responses:
        '200':
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
          description: ''
      x-explicit-tags: []
  /api/projects/{project_id}/query/upgrade/:
    post:
      operationId: query_upgrade_create
      description: Upgrades a query without executing it. Returns a query with all nodes migrated to the latest version.
      parameters:
      - $ref: '#/components/parameters/ProjectIdPath'
      tags:
      - query
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/QueryUpgradeRequest'
          application/x-www-form-urlencoded:
            schema:
              $ref: '#/components/schemas/QueryUpgradeRequest'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/QueryUpgradeRequest'
        required: true
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/QueryUpgradeResponse'
          description: ''
      x-explicit-tags: []
components:
  schemas:
    FunnelCorrelationQuery:
      additionalProperties: false
      properties:
        funnelCorrelationEventExcludePropertyNames:
          default: null
          title: Funnelcorrelationeventexcludepropertynames
          items:
            type: string
          type:
          - array
          - 'null'
        funnelCorrelationEventNames:
          default: null
          title: Funnelcorrelationeventnames
          items:
            type: string
          type:
          - array
          - 'null'
        funnelCorrelationExcludeEventNames:
          default: null
          title: Funnelcorrelationexcludeeventnames
          items:
            type: string
          type:
          - array
          - 'null'
        funnelCorrelationExcludeNames:
          default: null
          title: Funnelcorrelationexcludenames
          items:
            type: string
          type:
          - array
          - 'null'
        funnelCorrelationNames:
          default: null
          title: Funnelcorrelationnames
          items:
            type: string
          type:
          - array
          - 'null'
        funnelCorrelationType:
          $ref: '#/components/schemas/FunnelCorrelationResultsType'
        kind:
          default: FunnelCorrelationQuery
          title: Kind
          type: string
          enum:
          - FunnelCorrelationQuery
        response:
          default: null
          allOf:
          - $ref: '#/components/schemas/FunnelCorrelationResponse'
        source:
          $ref: '#/components/schemas/FunnelsActorsQuery'
        version:
          default: null
          description: version of the node, used for schema migrations
          title: Version
          type:
          - number
          - 'null'
      required:
      - funnelCorrelationType
      - source
      title: FunnelCorrelationQuery
      type: object
    QueryResponseAlternative3:
      additionalProperties: false
      properties:
        columns:
          items: {}
          title: Columns
          type: array
        error:
          default: null
          description: Query error. Returned only if 'explain' or `modifiers.debug` is true. Throws an error otherwise.
          title: Error
          type:
          - string
          - 'null'
        hasMore:
          default: null
          title: Hasmore
          type:
          - boolean
          - 'null'
        hogql:
          description: Generated HogQL query.
          title: Hogql
          type: string
        limit:
          title: Limit
          type: integer
        missing_actors_count:
          default: null
          title: Missing Actors Count
          type:
          - integer
          - 'null'
        modifiers:
          default: null
          description: Modifiers used when performing the query
          allOf:
          - $ref: '#/components/schemas/HogQLQueryModifiers'
        offset:
          title: Offset
          type: integer
        query_status:
          default: null
          description: Query status indicates whether next to the provided data, a query is still running.
          allOf:
          - $ref: '#/components/schemas/QueryStatus'
        resolved_date_range:
          default: null
          description: The date range used for the query
          allOf:
          - $ref: '#/components/schemas/ResolvedDateRangeResponse'
        results:
          items:
            items: {}
            type: array
          title: Results
          type: array
        timings:
          default: null
          description: Measured timings for different parts of the query generation process
          title: Timings
          items:
            $ref: '#/components/schemas/QueryTiming'
          type:
          - array
          - 'null'
        types:
          default: null
          title: Types
          items:
            type: string
          type:
          - array
          - 'null'
      required:
      - columns
      - hogql
      - limit
      - offset
      - results
      title: QueryResponseAlternative3
      type: object
    QueryResponseAlternative22:
      additionalProperties: false
      properties:
        error:
          default: null
          description: Query error. Returned only if 'explain' or `modifiers.debug` is true. Throws an error otherwise.
          title: Error
          type:
          - string
          - 'null'
        hasMore:
          default: null
          title: Hasmore
          type:
          - boolean
          - 'null'
        hogql:
          default: null
          description: Generated HogQL query.
          title: Hogql
          type:
          - string
          - 'null'
        limit:
          default: null
          title: Limit
          type:
          - integer
          - 'null'
        modifiers:
          default: null
          description: Modifiers used when performing the query
          allOf:
          - $ref: '#/components/schemas/HogQLQueryModifiers'
        offset:
          default: null
          title: Offset
          type:
          - integer
          - 'null'
        query_status:
          default: null
          description: Query status indicates whether next to the provided data, a query is still running.
          allOf:
          - $ref: '#/components/schemas/QueryStatus'
        resolved_date_range:
          default: null
          description: The date range used for the query
          allOf:
          - $ref: '#/components/schemas/ResolvedDateRangeResponse'
        results:
          items:
            $ref: '#/components/schemas/EmbeddingDistance'
          title: Results
          type: array
        timings:
          default: null
          description: Measured timings for different parts of the query generation process
          title: Timings
          items:
            $ref: '#/components/schemas/QueryTiming'
          type:
          - array
          - 'null'
      required:
      - results
      title: QueryResponseAlternative22
      type: object
    MaterializationType:
      enum:
      - materialized
      - inline
      - null
      title: MaterializationType
    QueryResponseAlternative8:
      additionalProperties: false
      properties:
        clickhouse:
          default: null
          description: Executed ClickHouse query
          title: Clickhouse
          type:
          - string
          - 'null'
        columns:
          default: null
          description: Returned columns
          title: Columns
          items: {}
          type:
          - array
          - 'null'
        error:
          default: null
          description: Query error. Returned only if 'explain' or `modifiers.debug` is true. Throws an error otherwise.
          title: Error
          type:
          - string
          - 'null'
        explain:
          default: null
          description: Query explanation output
          title: Explain
          items:
            type: string
          type:
          - array
          - 'null'
        hasMore:
          default: null
          title: Hasmore
          type:
          - boolean
          - 'null'
        hogql:
          default: null
          description: Generated HogQL query.
          title: Hogql
          type:
          - string
          - 'null'
        limit:
          default: null
          title: Limit
          type:
          - integer
          - 'null'
        metadata:
          default: null
          description: Query metadata output
          allOf:
          - $ref: '#/components/schemas/HogQLMetadataResponse'
        modifiers:
          default: null
          description: Modifiers used when performing the query
          allOf:
          - $ref: '#/components/schemas/HogQLQueryModifiers'
        offset:
          default: null
          title: Offset
          type:
          - integer
          - 'null'
        query:
          default: null
          description: Input query string
          title: Query
          type:
          - string
          - 'null'
        query_status:
          default: null
          description: Query status indicates whether next to the provided data, a query is still running.
          allOf:
          - $ref: '#/components/schemas/QueryStatus'
        resolved_date_range:
          default: null
          description: The date range used for the query
          allOf:
          - $ref: '#/components/schemas/ResolvedDateRangeResponse'
        results:
          items: {}
          title: Results
          type: array
        timings:
          default: null
          description: Measured timings for different parts of the query generation process
          title: Timings
          items:
            $ref: '#/components/schemas/QueryTiming'
          type:
          - array
          - 'null'
        types:
          default: null
          description: Types of returned columns
          title: Types
          items: {}
          type:
          - array
          - 'null'
      required:
      - results
      title: QueryResponseAlternative8
      type: object
    RETENTION:
      additionalProperties: false
      properties:
        hideLineGraph:
          default: null
          title: Hidelinegraph
          type:
          - boolean
          - 'null'
        hideSizeColumn:
          default: null
          title: Hidesizecolumn
          type:
          - boolean
          - 'null'
        useSmallLayout:
          default: null
          title: Usesmalllayout
          type:
          - boolean
          - 'null'
      title: RETENTION
      type: object
    QueryResponseAlternative86:
      additionalProperties: false
      properties:
        error:
          default: null
          description: Query error. Returned only if 'explain' or `modifiers.debug` is true. Throws an error otherwise.
          title: Error
          type:
          - string
          - 'null'
        hogql:
          default: null
          description: Generated HogQL query.
          title: Hogql
          type:
          - string
          - 'null'
        modifiers:
          default: null
          description: Modifiers used when performing the query
          allOf:
          - $ref: '#/components/schemas/HogQLQueryModifiers'
        query_status:
          default: null
          description: Query status indicates whether next to the provided data, a query is still running.
          allOf:
          - $ref: '#/components/schemas/QueryStatus'
        resolved_date_range:
          default: null
          description: The date range used for the query
          allOf:
          - $ref: '#/components/schemas/ResolvedDateRangeResponse'
        results:
          items:
            $ref: '#/components/schemas/VectorSearchResponseItem'
          title: Results
          type: array
        timings:
          default: null
          description: Measured timings for different parts of the query generation process
          title: Timings
          items:
            $ref: '#/components/schemas/QueryTiming'
          type:
          - array
          - 'null'
      required:
      - results
      title: QueryResponseAlternative86
      type: object
    DataTableNode:
      additionalProperties: false
      properties:
        allowSorting:
          default: null
          description: 'Can the user click on column headers to sort the table? (default: true)'
          title: Allowsorting
          type:
          - boolean
          - 'null'
        columns:
          default: null
          description: Columns shown in the table, unless the `source` provides them.
          title: Columns
          items:
            type: string
          type:
          - array
          - 'null'
        context:
          default: null
          description: Context for the table, used by components like ColumnConfigurator
          allOf:
          - $ref: '#/components/schemas/DataTableNodeViewPropsContext'
        contextKey:
          default: null
          description: Context key for universal column configuration (e.g., "survey:123")
          title: Contextkey
          type:
          - string
          - 'null'
        defaultColumns:
          default: null
          description: Default columns to use when resetting column configuration
          title: Defaultcolumns
          items:
            type: string
          type:
          - array
          - 'null'
        embedded:
          default: null
          description: Uses the embedded version of LemonTable
          title: Embedded
          type:
          - boolean
          - 'null'
        expandable:
          default: null
          description: 'Can expand row to show raw event data (default: true)'
          title: Expandable
          type:
          - boolean
          - 'null'
        full:
          default: null
          description: Show with most visual options enabled. Used in scenes.
          title: Full
          type:
          - boolean
          - 'null'
        hiddenColumns:
          default: null
          description: Columns that aren't shown in the table, even if in columns or returned data
          title: Hiddencolumns
          items:
            type: string
          type:
          - array
          - 'null'
        kind:
          default: DataTableNode
          title: Kind
          type: string
          enum:
          - DataTableNode
        pinnedColumns:
          default: null
          description: Columns that are sticky when scrolling horizontally
          title: Pinnedcolumns
          items:
            type: string
          type:
          - array
          - 'null'
        propertiesViaUrl:
          default: null
          description: 'Link properties via the URL (default: false)'
          title: Propertiesviaurl
          type:
          - boolean
          - 'null'
        response:
          default: null
          title: Response
          anyOf:
          - additionalProperties: true
            type: object
          - $ref: '#/components/schemas/Response'
          - $ref: '#/components/schemas/Response1'
          - $ref: '#/components/schemas/Response2'
          - $ref: '#/components/schemas/Response3'
          - $ref: '#/components/schemas/Response4'
          - $ref: '#/components/schemas/Response5'
          - $ref: '#/components/schemas/Response6'
          - $ref: '#/components/schemas/Response8'
          - $ref: '#/components/schemas/Response9'
          - $ref: '#/components/schemas/Response10'
          - $ref: '#/components/schemas/Response11'
          - $ref: '#/components/schemas/Response12'
          - $ref: '#/components/schemas/Response13'
          - $ref: '#/components/schemas/Response14'
          - $ref: '#/components/schemas/Response15'
          - $ref: '#/components/schemas/Response16'
          - $ref: '#/components/schemas/Response18'
          - $ref: '#/components/schemas/Response19'
          - $ref: '#/components/schemas/Response20'
          - $ref: '#/components/schemas/Response21'
          - $ref: '#/components/schemas/Response22'
          - $ref: '#/components/schemas/Response23'
          - $ref: '#/components/schemas/Response24'
          - $ref: '#/components/schemas/Response25'
          - $ref: '#/components/schemas/Response26'
        showActions:
          default: null
          description: Show the kebab menu at the end of the row
          title: Showactions
          type:
          - boolean
          - 'null'
        showColumnConfigurator:
          default: null
          description: Show a button to configure the table's columns if possible
          title: Showcolumnconfigurator
          type:
          - boolean
          - 'null'
        showCount:
          default: null
          description: Show count of total and filtered results
          title: Showcount
          type:
          - boolean
          - 'null'
        showDateRange:
          default: null
          description: Show date range selector
          title: Showdaterange
          type:
          - boolean
          - 'null'
        showElapsedTime:
          default: null
          description: Show the time it takes to run a query
          title: Showelapsedtime
          type:
          - boolean
          - 'null'
        showEventFilter:
          default: null
          description: Include an event filter above the table (EventsNode only)
          title: Showeventfilter
          type:
          - boolean
          - 'null'
        showEventsFilter:
          default: null
          description: Include an events filter above the table to filter by multiple events (EventsQuery only)
          title: Showeventsfilter
          type:
          - boolean
          - 'null'
        showExport:
          default: null
          description: Show the export button
          title: Showexport
          type:
          - boolean
          - 'null'
        showHogQLEditor:
          default: null
          description: Include a HogQL query editor above HogQL tables
          title: Showhogqleditor
          type:
          - boolean
          - 'null'
        showOpenEditorButton:
          default: null
          description: 'Show a button to open the current query as a new insight. (default: true)'
          title: Showopeneditorbutton
          type:
          - boolean
          - 'null'
        showPersistentColumnConfigurator:
          default: null
          description: Show a button to configure and persist the table's default columns if possible
          title: Showpersistentcolumnconfigurator
          type:
          - boolean
          - 'null'
        showPropertyFilter:
          default: null
          description: Include a property filter above the table
          title: Showpropertyfilter
          anyOf:
          - type: boolean
          - items:
              $ref: '#/components/schemas/TaxonomicFilterGroupType'
            type: array
        showRecordingColumn:
          default: null
          description: Show a recording column for events with session recordings
          title: Showrecordingcolumn
          type:
          - boolean
          - 'null'
        showReload:
          default: null
          description: Show a reload button
          title: Showreload
          type:
          - boolean
          - 'null'
        showResultsTable:
          default: null
          description: Show a results table
          title: Showresultstable
          type:
          - boolean
          - 'null'
        showSavedFilters:
          default: null
          description: Show saved filters feature for this table (requires uniqueKey)
          title: Showsavedfilters
          type:
          - boolean
          - 'null'
        showSavedQueries:
          default: null
          description: Shows a list of saved queries
          title: Showsavedqueries
          type:
          - boolean
          - 'null'
        showSearch:
          default: null
          description: Include a free text search field (PersonsNode only)
          title: Showsearch
          type:
          - boolean
          - 'null'
        showSourceQueryOptions:
          default: null
          description: Show actors query options and back to source
          title: Showsourcequeryoptions


# --- truncated at 32 KB (867 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/posthog/refs/heads/main/openapi/posthog-query-api-openapi.yml