PostHog · Schema

DatabaseSchemaSystemTable

A/B TestingAnalyticsFeature FlagsOpen-SourceProduct AnalyticsSession Recording

Properties

Name	Type	Description
fields	object
id	string
name	string
row_count	number
type	string

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/DatabaseSchemaSystemTable",
  "title": "DatabaseSchemaSystemTable",
  "additionalProperties": false,
  "properties": {
    "fields": {
      "additionalProperties": {
        "$ref": "#/components/schemas/DatabaseSchemaField"
      },
      "title": "Fields",
      "type": "object"
    },
    "id": {
      "title": "Id",
      "type": "string"
    },
    "name": {
      "title": "Name",
      "type": "string"
    },
    "row_count": {
      "default": null,
      "title": "Row Count",
      "type": "number",
      "nullable": true
    },
    "type": {
      "default": "system",
      "title": "Type",
      "type": "string",
      "enum": [
        "system"
      ]
    }
  },
  "required": [
    "fields",
    "id",
    "name"
  ],
  "type": "object"
}

Work with this as data

Every JSON Schema 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 schemas

4 MCP tools reach this

find_json_schemasBrowse and filter every JSON Schema in the catalog.
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 JSON Schema

curl "https://apis.io/api/v1/json-schemas/posthog-databaseschemasystemtable"

All schemas

curl "https://apis.io/api/v1/json-schemas?limit=25"

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

Get an API key

Free tier, no email required.

GitHub Google LinkedIn

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