Skip to content
MCP server

Census MCP by usefulapi

Hosted MCP server to read and trigger Census reverse-ETL syncs from AI clients

Install
Pricing
Freemium
Platforms
API, Web, vscode
Runs
Remotely
Version
1.40.1
Listing updated
today

About Census MCP by usefulapi

Census MCP by usefulapi is a freemium MCP server. It runs as a hosted remote server, so there is nothing to install locally.

The server gives an AI assistant read access to a Census workspace: warehouse sources, SaaS destinations, SQL models, syncs and run history. It can also kick off a sync run that pushes warehouse rows into a connected tool, and it can force a full re-sync instead of only changed rows.

It is a hosted remote endpoint, so there is nothing to install locally. Clients such as Claude, ChatGPT, Cursor and VS Code connect by URL and sign in through OAuth, with the login page asking for a Census API key. The README notes that the key is stored per user and that client configs should not carry an API key header.

The tool suits data and operations teams that already use Census and want to check sync status or inspect what feeds which destination from a chat. usefulapi is an independent service and is not affiliated with Census.

Install

Run in a terminal

claude mcp add --transport http census https://census.usefulapi.io/mcp

Add to Settings → Connectors → Add custom connector

https://census.usefulapi.io/mcp
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "census": {
      "url": "https://census.usefulapi.io/mcp"
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "census": {
      "type": "http",
      "url": "https://census.usefulapi.io/mcp"
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

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

Add to your client's MCP settings (most use this shape)

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

Using several servers? Build one config file with the MCP config generator.

Tools this server provides (13)

Read directly from the server.

census_list_sources
List configured data warehouse sources (Snowflake, BigQuery, Redshift, Databricks, etc.). Census: GET /sources.
census_get_source
Get a single source connection by id. Census: GET /sources/{id}.
census_list_destinations
List configured destination connections (SaaS apps data is synced INTO, e.g. Salesforce, HubSpot, Marketo). Census: GET /destinations.
census_get_destination
Get a single destination connection by id. Census: GET /destinations/{id}.
census_list_models
List SQL models / datasets defined in the workspace (the queries that produce rows to sync). Census: GET /models.
census_get_model
Get a single model by id, including its SQL/query. Census: GET /models/{id}.
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.
census_get_sync
Get a single sync's full configuration by id. Census: GET /syncs/{id}.
census_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
Get a single sync run by id — status, counts, errors. Census: GET /sync_runs/{id}.
census_list_segments
List audience segments defined in the workspace. Census: GET /segments.
census_list_workspaces
List workspaces in the organization (note: usually requires an organization-level token). Census: GET /workspaces.
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.

What it does

Sync run monitoring
Lists sync runs with their status, records processed, timing and errors, optionally filtered to one sync.
Sync mapping overview
Shows each sync's source model and destination object so you can see what feeds which tool.
Model SQL inspection
Lists workspace models and reads the query behind a given model.
Source and segment listing
Lists connected warehouse sources and audience segments defined in the workspace.
Triggered sync runs
Starts a sync that writes to the destination, with an option to force a full sync of all rows.
Usage and plan tools
Reports usage against the monthly tool call limit and handles upgrade and cancellation through the AI.

Good for

  • Check whether last night's customer sync finished and how many records it processed
  • Trace which warehouse model and destination a given sync uses
  • Review the SQL behind a model before changing a sync
  • Manually trigger a sync run after fixing upstream data
  • Confirm which warehouse sources and segments exist in a workspace

Pricing

Freemium, from $9 a month

Free plan with 50 tool calls/month; Pro $9/mo; Pro+ $39/mo

Prices change. Check usefulapi.io before you buy.

Census MCP by usefulapi FAQ

Is this an official Census product?

No. usefulapi is an independent service and is not affiliated with or endorsed by Census. The server calls the Census API with your own Census access.

What do I need to connect?

The login page asks for your Census API key, which the setup page says is found under Census settings in the API section.

Can the AI change my Census data?

Yes, if you approve it. One of the 13 Census tools can create or change data, which is the sync trigger. The other tools are read-only.

What does it cost?

The Free plan gives 50 tool calls per month. Pro is $9 per month or $90 per year with 10,000 calls per month, and Pro+ is $39 per month or $390 per year with 100,000 calls per month.

Is Census MCP by usefulapi free?

Census MCP by usefulapi has a free plan, with paid plans for more usage or features. Paid plans start at $9 a month.

How do I add Census MCP by usefulapi to Claude Code?

Run this command in your terminal: claude mcp add --transport http census https://census.usefulapi.io/mcp

Where this comes from

  • Description: written from the project's README, the project's website and its MCP Registry entry.
  • Status and tools: checked automatically by AIPoweredBot on 13 November 2026.
  • Install steps: from the official MCP Registry entry.

How AIPoweredBot checks servers