PostHog · Schema
DatabaseSchemaMaterializedViewTable
A/B TestingAnalyticsFeature FlagsOpen-SourceProduct AnalyticsSession Recording
Properties
| Name | Type | Description |
|---|---|---|
| fields | object | |
| id | string | |
| last_run_at | string | |
| name | string | |
| query | object | |
| row_count | number | |
| status | string | |
| type | string |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "#/components/schemas/DatabaseSchemaMaterializedViewTable",
"title": "DatabaseSchemaMaterializedViewTable",
"additionalProperties": false,
"properties": {
"fields": {
"additionalProperties": {
"$ref": "#/components/schemas/DatabaseSchemaField"
},
"title": "Fields",
"type": "object"
},
"id": {
"title": "Id",
"type": "string"
},
"last_run_at": {
"default": null,
"title": "Last Run At",
"type": "string",
"nullable": true
},
"name": {
"title": "Name",
"type": "string"
},
"query": {
"$ref": "#/components/schemas/HogQLQuery"
},
"row_count": {
"default": null,
"title": "Row Count",
"type": "number",
"nullable": true
},
"status": {
"default": null,
"title": "Status",
"type": "string",
"nullable": true
},
"type": {
"default": "materialized_view",
"title": "Type",
"type": "string",
"enum": [
"materialized_view"
]
}
},
"required": [
"fields",
"id",
"name",
"query"
],
"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.
Call it yourself
curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/posthog-databaseschemamaterializedviewtable"
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 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.