MCP Server

census

io.usefulapi/census
Business & Operations Data & Analytics Public & reachable MCP 2026-07-28

What this MCP does

Inspects Census reverse-ETL sources, models, destinations, syncs, segments, and run history, and can trigger data syncs into SaaS applications.

census_get_destination
Get destination
Get a single destination connection by id. Census: GET /destinations/{id}.
Read only
Input schema
{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['id'], 'properties': {'id': {'type': 'string', 'description': 'The resource id (a numeric id, passed as a string).'}}}
census_get_model
Get model
Get a single model by id, including its SQL/query. Census: GET /models/{id}.
Read only
Input schema
{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['id'], 'properties': {'id': {'type': 'string', 'description': 'The resource id (a numeric id, passed as a string).'}}}
census_get_source
Get source
Get a single source connection by id. Census: GET /sources/{id}.
Read only
Input schema
{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['id'], 'properties': {'id': {'type': 'string', 'description': 'The resource id (a numeric id, passed as a string).'}}}
census_get_sync
Get sync
Get a single sync's full configuration by id. Census: GET /syncs/{id}.
Read only
Input schema
{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['id'], 'properties': {'id': {'type': 'string', 'description': 'The resource id (a numeric id, passed as a string).'}}}
census_get_sync_run
Get sync run
Get a single sync run by id — status, counts, errors. Census: GET /sync_runs/{id}.
Read only
Input schema
{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['id'], 'properties': {'id': {'type': 'string', 'description': 'The resource id (a numeric id, passed as a string).'}}}
census_list_destinations
List destinations
List configured destination connections (SaaS apps data is synced INTO, e.g. Salesforce, HubSpot, Marketo). Census: GET /destinations.
Read only
Input schema
{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'properties': {'page': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': -9007199254740991, 'description': 'Page number (1-based) for pagination.'}, 'per_page': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': -9007199254740991, 'description': 'Number of records per page.'}}}
census_list_models
List models
List SQL models / datasets defined in the workspace (the queries that produce rows to sync). Census: GET /models.
Read only
Input schema
{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'properties': {'page': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': -9007199254740991, 'description': 'Page number (1-based) for pagination.'}, 'per_page': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': -9007199254740991, 'description': 'Number of records per page.'}}}
census_list_segments
List segments
List audience segments defined in the workspace. Census: GET /segments.
Read only
Input schema
{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'properties': {'page': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': -9007199254740991, 'description': 'Page number (1-based) for pagination.'}, 'per_page': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': -9007199254740991, 'description': 'Number of records per page.'}}}
census_list_sources
List sources
List configured data warehouse sources (Snowflake, BigQuery, Redshift, Databricks, etc.). Census: GET /sources.
Read only
Input schema
{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'properties': {'page': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': -9007199254740991, 'description': 'Page number (1-based) for pagination.'}, 'per_page': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': -9007199254740991, 'description': 'Number of records per page.'}}}
census_list_sync_runs
List sync runs
List sync run history (each run's status, records processed, timing). Filter by sync_id. Census: GET /sync_runs.
Read only
Input schema
{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'properties': {'page': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': -9007199254740991, 'description': 'Page number (1-based) for pagination.'}, 'sync_id': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': -9007199254740991, 'description': 'Filter runs to a single sync id.'}, 'per_page': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': -9007199254740991, 'description': 'Number of records per page.'}}}
census_list_syncs
List syncs
List syncs (a sync maps a source model to a destination object and keeps them in sync). Returns id, label, status, source_attributes, destination_attributes. Census: GET /syncs.
Read only
Input schema
{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'properties': {'page': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': -9007199254740991, 'description': 'Page number (1-based) for pagination.'}, 'per_page': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': -9007199254740991, 'description': 'Number of records per page.'}}}
census_list_workspaces
List workspaces
List workspaces in the organization (note: usually requires an organization-level token). Census: GET /workspaces.
Read only
Input schema
{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'properties': {}}
census_trigger_sync
Trigger sync
TRIGGERS a sync run for the given sync id — this KICKS OFF a live data sync that writes records into the connected destination SaaS tool. Set force_full_sync=true to re-sync all rows instead of just changes. Census: POST /syncs/{id}/trigger.
Destructive
Input schema
{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['id'], 'properties': {'id': {'type': 'string', 'description': 'The resource id (a numeric id, passed as a string).'}, 'force_full_sync': {'type': 'boolean', 'description': 'Re-sync ALL rows instead of just changes since the last run.'}}}
Changed
census_trigger_sync
Oct. 1, 2026, 2:50 a.m.
Changed
census_list_workspaces
Oct. 1, 2026, 2:50 a.m.
Changed
census_list_segments
Oct. 1, 2026, 2:50 a.m.
Changed
census_get_sync_run
Oct. 1, 2026, 2:50 a.m.
Changed
census_list_sync_runs
Oct. 1, 2026, 2:50 a.m.
Changed
census_get_sync
Oct. 1, 2026, 2:50 a.m.
Changed
census_list_syncs
Oct. 1, 2026, 2:50 a.m.
Changed
census_get_model
Oct. 1, 2026, 2:50 a.m.
Changed
census_list_models
Oct. 1, 2026, 2:50 a.m.
Changed
census_get_destination
Oct. 1, 2026, 2:50 a.m.
Changed
census_list_destinations
Oct. 1, 2026, 2:50 a.m.
Changed
census_get_source
Oct. 1, 2026, 2:50 a.m.
Changed
census_list_sources
Oct. 1, 2026, 2:50 a.m.
Added
census_trigger_sync
Sept. 17, 2026, 12:53 p.m.
Added
census_list_workspaces
Sept. 17, 2026, 12:53 p.m.
Added
census_list_segments
Sept. 17, 2026, 12:53 p.m.
Added
census_get_sync_run
Sept. 17, 2026, 12:53 p.m.
Added
census_list_sync_runs
Sept. 17, 2026, 12:53 p.m.
Added
census_get_sync
Sept. 17, 2026, 12:53 p.m.
Added
census_list_syncs
Sept. 17, 2026, 12:53 p.m.
Added
census_get_model
Sept. 17, 2026, 12:53 p.m.
Added
census_list_models
Sept. 17, 2026, 12:53 p.m.
Added
census_get_destination
Sept. 17, 2026, 12:53 p.m.
Added
census_list_destinations
Sept. 17, 2026, 12:53 p.m.
Added
census_get_source
Sept. 17, 2026, 12:53 p.m.
Added
census_list_sources
Sept. 17, 2026, 12:53 p.m.