List reverse-ETL sources, destinations, models, syncs and runs; trigger syncs into SaaS tools.
Scored across 13 tools
Each tool targets a distinct resource type (destination, model, source, sync, sync run, segment, workspace) with clear get/list/trigger actions. No overlapping purposes; agents can easily distinguish which tool to use for a given operation.
All tools follow a consistent 'census_verb_noun' pattern (e.g., census_get_destination, census_list_syncs). The only action tool, census_trigger_sync, also fits the pattern. No mixing of casing or verb styles.
13 tools is appropriate for a data integration platform that manages multiple resource types (destinations, sources, models, syncs, etc.). It's slightly on the higher side but well-scoped for the domain.
The set covers get, list, and trigger operations, but lacks create, update, and delete for resources. While Census API may not expose mutating operations via MCP, the surface is incomplete for full lifecycle management.
Get a single destination connection by id. Census: GET /destinations/{id}.
| Name | Required | Description | Default |
|---|---|---|---|
| id | Yes | The resource id (a numeric id, passed as a string). |
Get a single model by id, including its SQL/query. Census: GET /models/{id}.
| Name | Required | Description | Default |
|---|---|---|---|
| id | Yes | The resource id (a numeric id, passed as a string). |
Get a single source connection by id. Census: GET /sources/{id}.
| Name | Required | Description | Default |
|---|---|---|---|
| id | Yes | The resource id (a numeric id, passed as a string). |
Get a single sync's full configuration by id. Census: GET /syncs/{id}.
| Name | Required | Description | Default |
|---|---|---|---|
| id | Yes | The resource id (a numeric id, passed as a string). |
Get a single sync run by id — status, counts, errors. Census: GET /sync_runs/{id}.
| Name | Required | Description | Default |
|---|---|---|---|
| id | Yes | The resource id (a numeric id, passed as a string). |
List configured destination connections (SaaS apps data is synced INTO, e.g. Salesforce, HubSpot, Marketo). Census: GET /destinations.
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | Page number (1-based) for pagination. | |
| per_page | No | Number of records per page. |
List SQL models / datasets defined in the workspace (the queries that produce rows to sync). Census: GET /models.
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | Page number (1-based) for pagination. | |
| per_page | No | Number of records per page. |
List audience segments defined in the workspace. Census: GET /segments.
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | Page number (1-based) for pagination. | |
| per_page | No | Number of records per page. |
List configured data warehouse sources (Snowflake, BigQuery, Redshift, Databricks, etc.). Census: GET /sources.
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | Page number (1-based) for pagination. | |
| per_page | No | Number of records per page. |
List sync run history (each run's status, records processed, timing). Filter by sync_id. Census: GET /sync_runs.
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | Page number (1-based) for pagination. | |
| sync_id | No | Filter runs to a single sync id. | |
| per_page | No | Number of records per page. |
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.
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | Page number (1-based) for pagination. | |
| per_page | No | Number of records per page. |
List workspaces in the organization (note: usually requires an organization-level token). Census: GET /workspaces.
| Name | Required | Description | Default |
|---|---|---|---|
No parameters | |||
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.
| Name | Required | Description | Default |
|---|---|---|---|
| id | Yes | The resource id (a numeric id, passed as a string). | |
| force_full_sync | No | Re-sync ALL rows instead of just changes since the last run. |
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
census_get_destination1 field changedInput schema / $schemaPrevious value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"census_get_model1 field changedInput schema / $schemaPrevious value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"census_get_source1 field changedInput schema / $schemaPrevious value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"census_get_sync1 field changedInput schema / $schemaPrevious value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"census_get_sync_run1 field changedInput schema / $schemaPrevious value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"census_list_destinations1 field changedInput schema / $schemaPrevious value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"census_list_models1 field changedInput schema / $schemaPrevious value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"census_list_segments1 field changedInput schema / $schemaPrevious value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"census_list_sources1 field changedInput schema / $schemaPrevious value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"census_list_sync_runs1 field changedInput schema / $schemaPrevious value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"census_list_syncs1 field changedInput schema / $schemaPrevious value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"census_list_workspaces1 field changedInput schema / $schemaPrevious value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"census_trigger_sync1 field changedInput schema / $schemaPrevious value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"census_get_destinationcensus_get_modelcensus_get_sourcecensus_get_synccensus_get_sync_runcensus_list_destinationscensus_list_modelscensus_list_segmentscensus_list_sourcescensus_list_sync_runscensus_list_syncscensus_list_workspacescensus_trigger_syncManage Jitsu data pipelines: destinations, streams, connections, functions, live events.
Define, ship & query your analytics tracking from one source of truth, trusted by humans and agents.
Build and manage Whalesync syncs: connect apps, map tables and fields, monitor and fix issues.
Read Lago customers, subscriptions, invoices, usage and revenue analytics; write events.
Add one secure layer between your agents and this server.
