Census MCP by usefulapi
Hosted MCP server to read and trigger Census reverse-ETL syncs from AI clients
- 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/mcpAdd to Settings → Connectors → Add custom connector
https://census.usefulapi.io/mcpAdd to ~/.cursor/mcp.json
{
"mcpServers": {
"census": {
"url": "https://census.usefulapi.io/mcp"
}
}
}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.