# Census MCP by usefulapi

> Census MCP by usefulapi is a freemium MCP server. Hosted MCP server to read and trigger Census reverse-ETL syncs from AI clients. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Pricing:** Freemium
- **Starting price:** $9 a month
- **Platforms:** API, Web, vscode
- **Website:** https://usefulapi.io/census/
- **Repository:** https://github.com/m190/usefulapi-mcp/tree/HEAD/servers/census
- **MCP Registry name:** io.usefulapi/census
- **Listing updated:** 2026-11-18

## About

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.

## Features

- **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

## Install

### Claude Code (Terminal)

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

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://census.usefulapi.io/mcp
```

### Cursor (~/.cursor/mcp.json)

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

### VS Code (.vscode/mcp.json)

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

### Windsurf (~/.codeium/windsurf/mcp_config.json)

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

### Other clients (your client's MCP settings (most use this shape))

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

## Tools

- `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.

## 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.

---
Source: https://ai-powered.com/mcp/census-mcp-by-usefulapi
