ElectricSQL · Schema
SubsetSnapshot
Response object returned by the Electric HTTP API when any subset__* parameters are present. Contains a data array of operation messages and PostgreSQL snapshot metadata.
Developer ToolsDatabaseSyncLocal-FirstPostgresReal-TimeOpen-Source
Properties
| Name | Type | Description |
|---|---|---|
| metadata | object | PostgreSQL snapshot metadata used by clients to determine which subsequent change-stream events to skip. |
| data | array | Array of operation messages representing the subset snapshot data (no control messages). |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12",
"$id": "https://electric.ax/schemas/subset-snapshot",
"title": "SubsetSnapshot",
"description": "Response object returned by the Electric HTTP API when any subset__* parameters are present. Contains a data array of operation messages and PostgreSQL snapshot metadata.",
"type": "object",
"required": ["data", "metadata"],
"properties": {
"metadata": {
"type": "object",
"description": "PostgreSQL snapshot metadata used by clients to determine which subsequent change-stream events to skip.",
"properties": {
"xmin": {
"type": "string",
"description": "Minimum active transaction ID at snapshot time (uint64 as string)."
},
"xmax": {
"type": "string",
"description": "Next transaction ID that had not yet started at snapshot time (uint64 as string)."
},
"xip_list": {
"type": "array",
"items": { "type": "string" },
"description": "Transaction IDs that were in-progress during the snapshot (uint64 as strings)."
},
"snapshot_mark": {
"type": "integer",
"description": "Random number identifying this snapshot, matching snapshot_mark in operation headers."
},
"database_lsn": {
"type": "string",
"description": "PostgreSQL write-ahead log sequence number at snapshot time."
}
}
},
"data": {
"type": "array",
"description": "Array of operation messages representing the subset snapshot data (no control messages).",
"items": {
"type": "object",
"properties": {
"headers": {
"type": "object",
"properties": {
"operation": {
"type": "string",
"enum": ["insert", "update", "delete"]
},
"snapshot_mark": {
"type": "integer"
},
"lsn": { "type": "string" },
"op_position": { "type": "integer" },
"txids": {
"type": "array",
"items": { "type": "string" }
}
}
},
"key": { "type": "string" },
"value": {
"type": "object",
"additionalProperties": { "type": "string" }
},
"old_value": {
"type": "object",
"additionalProperties": { "type": "string" }
}
}
}
}
}
}
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/electric-sql-subset-snapshot"
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.