Census logoMCP server · Databases and warehouses

Census MCP server

Census in any MCP client, through Memtro: Census does not publish this server. Memtro's Census connector reads Census through its API with the credentials you connect, and one endpoint hands those tools, every other system you connect and Memtro's memory tools to Claude Code, Cursor, Claude Desktop or anything else that speaks Streamable HTTP, as you.

What the model can do

Census (Fivetran Activations) reverse ETL: read sources, activations, datasets, syncs with status and schedule and each sync's runs, and run a sync now, pause or resume it, cancel a running sync run, or delete a sync.

Reads

  • census_list_sourcesCensus sources (the warehouses data is read from): id, name, type, sync engine, region, whether the last connection test passed.
  • census_list_activationsCensus activations (the destinations data is sent to, formerly 'destinations'): id, name, destination type, the source it reads from…
  • census_list_datasetsCensus datasets (the queries that select records to sync, formerly 'models'): id, name, description, source id, column count, cached record count…
  • census_list_syncsCensus syncs: id, label, status (ready, up to date, failing), operation (upsert, mirror…), the activation it sends to, the destination object…
  • census_sync_runsRuns of one Census sync, newest first: status, when created and completed, source records, records processed, updated, failed and invalid…

Acts, when you ask

These change something in Census. The model is told to use them only when you ask for exactly that, and each one is granted by name: per team on a shared connection, by the owner on a personal one.

  • census_trigger_syncRuns a Census sync now: its dataset is queried on the warehouse and changed records are written to the destination system (a CRM, ad platform, etc.).
  • census_pause_syncPauses a Census sync (paused = true) so it stops running on its schedule, or resumes it with paused = false.
  • census_cancel_sync_runCancels a Census sync run that is running.
  • census_delete_syncPermanently deletes a Census sync (its mappings, schedule and run history).

Connect it

First connect Census on Dashboard → Connections, then add Memtro to your client once. The Census tools appear alongside the tools of everything else you have connected; nothing is configured per connector.

Claude Code

The Memtro plugin registers the server and a skill for when to use it; the tools are then available in every session.

claude plugin marketplace add memtro-org/claude-memtro
claude plugin install memtro@memtro --config api_key=sk-memtro-...

Cursor

Add the server to .cursor/mcp.json in the project, or to the global file under ~/.cursor/.

{
  "mcpServers": {
    "memtro": {
      "url": "https://platform.memtro.com/api/mcp",
      "headers": {
        "Authorization": "Bearer sk-memtro-..."
      }
    }
  }
}

Claude Desktop

Create a personal API key on Dashboard → Profile → API keys. In Claude Desktop add an MCP server of type HTTP with URL https://platform.memtro.com/api/mcp and the header Authorization: Bearer sk-memtro-…

OpenCode

A remote server in opencode.json.

{
  "mcp": {
    "memtro": {
      "type": "remote",
      "url": "https://platform.memtro.com/api/mcp",
      "headers": {
        "Authorization": "Bearer sk-memtro-..."
      }
    }
  }
}

Pi

One command: pi mcp add memtro --url https://platform.memtro.com/api/mcp --bearer-token-env-var MEMTRO_API_KEY. Tools arrive as mcp__memtro__*. The pi-memtro extension registers it for you, alongside Memtro as the model.

Any other client

Add an MCP server of type HTTP (Streamable HTTP, stateless) at https://platform.memtro.com/api/mcp with the header Authorization: Bearer sk-memtro-.... Codex, Zed, Windsurf, Cline and the SDKs all take a remote server this way.

Who may use it

The key identifies the person, and the server offers that person the tools they may use everywhere else in Memtro. A shared Census connection is used by the teams an administrator granted it to, tool by tool, on the Permissions page; a personal connection is used by its owner alone, and its tools that act stay off until the owner allows them. See Teams and permissions and Connectors.

Ask it like this

  • › Which Census syncs are failing?
  • › Why did the HubSpot upsert sync fail this morning?
  • › How many records were invalid on the last Salesforce run?
  • › Which Census syncs are paused?
  • › Pause the HubSpot upsert sync until Monday

Questions

Is this an official Census MCP server?
No. It is Memtro's MCP server with Memtro's Census connector behind it: the connector reads Census through its API with the credentials you connect on Dashboard → Connections, and Census publishes nothing here. The same endpoint carries every other system you connect and Memtro's memory tools.
What does it cost?
Nothing on top of Memtro. One price per organisation by its number of users, from $50 a month for up to 10 users after a 7-day free trial, with every connector, the MCP server, jobs and memory included. You bring your own model keys.
Can it change anything in Census?
Only when you ask, and only what it has been granted: run a sync now, sending changed records to its destination (optionally a full sync); pause a sync, or resume a paused one; cancel a running sync run; delete a sync permanently. Every other tool reads, searches or lists. An administrator grants each acting tool by name per team, and a personal connection acts only after its owner allows it.
Which clients work?
Any MCP client that speaks Streamable HTTP: Claude Code, Cursor, Claude Desktop, OpenCode, Codex, Zed, Windsurf, Cline and the Anthropic and OpenAI SDKs. There is no local process to run; the server is remote and authenticated with your key.

Other MCP servers · Databases and warehouses

Where agents remember your company

Sign in, add a provider key, create an API key and point your tools at Memtro. It takes about five minutes.

7-day free trial · card on file, nothing charged until it ends · cancel any time