Servers Playground How we check Add a server Log in

Census MCP by usefulapi

Working · 2.2 s

io.usefulapi/censusv1.19.0 Domain verified

List reverse-ETL sources, destinations, models, syncs and runs; trigger syncs into SaaS tools.

Data & Databases

Source Website Registry entry

Maintain this server? Claim it

Try it

Call this server's tools from your browser. Nothing to install.

https://census.usefulapi.io/mcp

Requests go through mcptry because browsers can't call most MCP servers directly. Header values are sent to the server for that request only and are never stored or logged.

Tool list from our last check. Connect live to refresh it.

census_get_destination Read-only

Get a single destination connection by id. Census: GET /destinations/{id}.

idstring, required

The resource id (a numeric id, passed as a string).

Census MCP by usefulapi MCP server | mcptry

Tools (13)

census_get_destination

Get a single destination connection by id. Census: GET /destinations/{id}.

read-only

Argument	Type	Description
id*	string	The resource id (a numeric id, passed as a string).

Input schema (JSON)

{
  "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 a single model by id, including its SQL/query. Census: GET /models/{id}.

read-only

Argument	Type	Description
id*	string	The resource id (a numeric id, passed as a string).

Input schema (JSON)

{
  "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 a single source connection by id. Census: GET /sources/{id}.

read-only

Argument	Type	Description
id*	string	The resource id (a numeric id, passed as a string).

Input schema (JSON)

{
  "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 a single sync's full configuration by id. Census: GET /syncs/{id}.

read-only

Argument	Type	Description
id*	string	The resource id (a numeric id, passed as a string).

Input schema (JSON)

{
  "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 a single sync run by id — status, counts, errors. Census: GET /sync_runs/{id}.

read-only

Argument	Type	Description
id*	string	The resource id (a numeric id, passed as a string).

Input schema (JSON)

{
  "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 configured destination connections (SaaS apps data is synced INTO, e.g. Salesforce, HubSpot, Marketo). Census: GET /destinations.

read-only

Argument	Type	Description
page	integer	Page number (1-based) for pagination.
per_page	integer	Number of records per page.

Input schema (JSON)

{
  "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 SQL models / datasets defined in the workspace (the queries that produce rows to sync). Census: GET /models.

read-only

Argument	Type	Description
page	integer	Page number (1-based) for pagination.
per_page	integer	Number of records per page.

Input schema (JSON)

{
  "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 audience segments defined in the workspace. Census: GET /segments.

read-only

Argument	Type	Description
page	integer	Page number (1-based) for pagination.
per_page	integer	Number of records per page.

Input schema (JSON)

{
  "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 configured data warehouse sources (Snowflake, BigQuery, Redshift, Databricks, etc.). Census: GET /sources.

read-only

Argument	Type	Description
page	integer	Page number (1-based) for pagination.
per_page	integer	Number of records per page.

Input schema (JSON)

{
  "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 run history (each run's status, records processed, timing). Filter by sync_id. Census: GET /sync_runs.

read-only

Argument	Type	Description
page	integer	Page number (1-based) for pagination.
sync_id	integer	Filter runs to a single sync id.
per_page	integer	Number of records per page.

Input schema (JSON)

{
  "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 (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

Argument	Type	Description
page	integer	Page number (1-based) for pagination.
per_page	integer	Number of records per page.

Input schema (JSON)

{
  "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 in the organization (note: usually requires an organization-level token). Census: GET /workspaces.

read-only

No arguments.

Input schema (JSON)

{
  "type": "object",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "properties": {}
}

census_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

Argument	Type	Description
id*	string	The resource id (a numeric id, passed as a string).
force_full_sync	boolean	Re-sync ALL rows instead of just changes since the last run.

Input schema (JSON)

{
  "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."
    }
  }
}