usefulapi

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

Claude

Open Settings → Connectors → Add custom connector
Paste this URL:
https://census.usefulapi.io/mcp
Authenticate with Census when prompted

Cursor · VS Code · Windsurf · Cline

Add to your MCP config, then reload & authorize:

{
  "mcpServers": {
    "census": {
      "url": "https://census.usefulapi.io/mcp"
    }
  }
}

live15 toolsFree 100 tool calls / monthPro $9/mo · $90/yr

Tools 15

Tool	Type	What it does
`census_list_sources`	read	List sources List configured data warehouse sources (Snowflake, BigQuery, Redshift, Databricks, etc.). Census: GET /sources.
`census_get_source`	read	Get source Get a single source connection by id. Census: GET /sources/{id}.
`census_list_destinations`	read	List destinations List configured destination connections (SaaS apps data is synced INTO, e.g. Salesforce, HubSpot, Marketo). Census: GET /destinations.
`census_get_destination`	read	Get destination Get a single destination connection by id. Census: GET /destinations/{id}.
`census_list_models`	read	List models List SQL models / datasets defined in the workspace (the queries that produce rows to sync). Census: GET /models.
`census_get_model`	read	Get model Get a single model by id, including its SQL/query. Census: GET /models/{id}.
`census_list_syncs`	read	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.
`census_get_sync`	read	Get sync Get a single sync's full configuration by id. Census: GET /syncs/{id}.
`census_list_sync_runs`	read	List sync runs List sync run history (each run's status, records processed, timing). Filter by sync_id. Census: GET /sync_runs.
`census_get_sync_run`	read	Get sync run Get a single sync run by id — status, counts, errors. Census: GET /sync_runs/{id}.
`census_list_segments`	read	List segments List audience segments defined in the workspace. Census: GET /segments.
`census_list_workspaces`	read	List workspaces List workspaces in the organization (note: usually requires an organization-level token). Census: GET /workspaces.
`census_trigger_sync`	write	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.
`census_usage_status`	meta	Usage status (free-tier meter) Report the caller's current free-tier usage this month: calls used, monthly limit, remaining, and whether the cap is reached. Read-only; does not count against the meter.
`census_upgrade`	meta	Upgrade to Pro (unlimited) Subscribe to the Pro plan for UNLIMITED Census tool calls (the free tier caps monthly usage). Choose monthly ($9/month) or yearly ($90/year — 2 months free) billing. Returns a Stripe Checkout link to open in your browser; after payment your account upgrades automatically. Read-only; does not count against the meter.

Pricing

Plan	Price	Limit
Free	$0	100 tool calls / month
Proper user	$9/mo · $90/yr	Unlimited

This is a Model Context Protocol endpoint — meant to be connected from an AI client, not opened in a browser. An invalid_token response at the URL is the auth gate working as designed; clients authenticate automatically.