Census MCP by usefulapi

io.usefulapiPublished by usefulapi.ioOfficial publisherv1.36.5Updated Nov 8, 2026

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

The publisher's own server: Ably MCP by usefulapi

VerifiedStreamable HTTPWeb executableData & Analytics Business & Commerce

Server details

Identifier: io.usefulapi/census
Transport: Streamable HTTP
Runtime: Web executable
Trust: Verified
Published: Sep 16, 2026

Security note

MCP servers receive tool arguments from a conversation and may perform external actions. Review what a server can do before you enable it, and give it only the access it needs.

The registry verified that this server's namespace belongs to usefulapi.io, which also runs its endpoint. That identifies the publisher; it does not make the server's tools safe.

SourceWeft's checks cover whether the listing is complete and the endpoint answered; they do not review the server's code or what its tools do.

Add a badge to your README

Show readers this MCP server is listed on SourceWeft. The badge links to this page.

[![Listed on SourceWeft](https://sourceweft.com/badge/mcp/io.usefulapi%2Fcensus.svg)](https://sourceweft.com/mcp/io.usefulapi%2Fcensus?utm_source=readme&utm_medium=badge)

Overview

AI-generated overview

Hosted Census reverse-ETL server: lets an assistant inspect sources, destinations, models, syncs and run history, and trigger syncs into SaaS tools.

What you can do: List and inspect warehouse sources and destination connections, including Salesforce, HubSpot and Marketo
List and read SQL models and their queries
List and read sync configurations, including source and destination attributes
List and read sync run history with status, records processed, timing and errors
List audience segments and organization workspaces
Trigger a sync run, optionally as a full re-sync, plus check usage and manage the subscription
When to use it: Useful when you work with Census reverse-ETL and want to ask an assistant which syncs exist, where they send data, how recent runs performed, or to kick off a sync without opening the Census UI.
Requirements: Remote MCP endpoint reached over HTTP; no local install. Sign-in is via OAuth, and on first connect you paste a Census API key (Census workspace settings, API Access), which is stored per user. Listing workspaces usually needs an organization-level token. Free plan allows 50 tool calls per month.

Before you install

census_trigger_sync starts a live sync that writes records into the connected destination SaaS tool, and force_full_sync re-syncs all rows; confirm before running it. The server asks for a Census API key, which grants access to your Census workspace. Meta tools can start a paid Stripe checkout or cancel a subscription, and usage is metered by plan.

Installation

In SourceWeft

Open Census MCP by usefulapi in the dashboard and add it to a workspace.
Enable the server for the chats that should use its tools.

Web executable via Streamable HTTP. Remote servers run from the web runtime once configured in a workspace.

Use with an agent

Paste this prompt into Claude Code, Codex, Cursor or another agent — or into SourceWeft chat. The agent reads this server's install guide, shows you its publisher, endpoint and sign-in, and adds it to your client once you agree. Keys never go into a command.

Read https://sourceweft.com/mcp/io.usefulapi%2Fcensus/install.md and connect the MCP server it describes to my client. Before changing any config, show me its publisher, endpoint and sign-in method and wait for my OK. Never put an API key in a command or in a file I would commit; ask me where it should come from.

Read the install guide the agent follows

Other MCP clients

Add this to your client's mcpServers config.

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

README

Census MCP by usefulapi

Manage Census reverse-ETL from Claude, Cursor, or any MCP client — read sources, destinations, models, syncs and run history, and trigger syncs that push warehouse data into your SaaS tools. Hosted, no local install: connect with your Census API key.

Live endpoint: https://census.usefulapi.io/mcp · Homepage: https://usefulapi.io

Connect

Claude (claude.ai, Desktop): open Customize → Connectors, click + Add → Add custom connector, and paste https://census.usefulapi.io/mcp.
Claude Code: claude mcp add --transport http census https://census.usefulapi.io/mcp, then run /mcp to log in.
VS Code: Add to VS Code.
Cursor and other clients: add the URL as a remote MCP server:

Add only the URL. Do not add an Authorization header or an API key to the client config: the server signs you in with OAuth, and the login page asks for your Census credentials.

Step-by-step setup, where to find your credentials, and FAQ: https://usefulapi.io/census/

On first connect you'll paste your Census API key (Census → Workspace settings → API Access). It's validated, stored per-user, and scoped to you — no keys in config files.

Tools

Tool	Type	What it does
`census_list_sources`	read	List sources
`census_get_source`	read	Get source
`census_list_destinations`	read	List destinations
`census_get_destination`	read	Get destination
`census_list_models`	read	List models
`census_get_model`	read	Get model
`census_list_syncs`	read	List syncs
`census_get_sync`	read	Get sync
`census_list_sync_runs`	read	List sync runs
`census_get_sync_run`	read	Get sync run
`census_list_segments`	read	List segments
`census_list_workspaces`	read	List workspaces
`census_trigger_sync`	write	Trigger sync
`census_usage_status`	meta	Usage status (free-tier meter)
`census_request_feature`	meta	Request a missing feature
`census_upgrade`	meta	Upgrade to Pro or Pro+
`census_cancel_subscription`	meta	Cancel the Pro subscription

read tools are read-only; write tools mutate data (clients should confirm them); meta tools report usage, manage your subscription or send a feature request.

Pricing

*Pro has a fair use limit of 10,000 tool calls a month on this server. For more, write to [email protected].

Pro covers this server only. Subscribe with census_upgrade (it returns a Stripe Checkout link). Cancel any time with census_cancel_subscription: Pro continues to the end of the paid period, with no refund for the current period, and running census_upgrade before then undoes the cancel. Or write to [email protected].

License

MIT — see LICENSE. Documentation only; the server is hosted.

Source: servers/census/README.md at commit 4046075

Tools

census_list_sources

List sources

List configured data warehouse sources (Snowflake, BigQuery, Redshift, Databricks, etc.). Census: GET /sources.

Parameterspageper_page

census_get_source

Get source

Get a single source connection by id. Census: GET /sources/{id}.

Parametersidrequired

census_list_destinations

List destinations

List configured destination connections (SaaS apps data is synced INTO, e.g. Salesforce, HubSpot, Marketo). Census: GET /destinations.

Parameterspageper_page

census_get_destination

Get destination

Get a single destination connection by id. Census: GET /destinations/{id}.

Parametersidrequired

census_list_models

List models

List SQL models / datasets defined in the workspace (the queries that produce rows to sync). Census: GET /models.

Parameterspageper_page

census_get_model

Get model

Get a single model by id, including its SQL/query. Census: GET /models/{id}.

Parametersidrequired

census_list_syncs

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.

Parameterspageper_page

census_get_sync

Get sync

Get a single sync's full configuration by id. Census: GET /syncs/{id}.

Parametersidrequired

census_list_sync_runs

List sync runs

List sync run history (each run's status, records processed, timing). Filter by sync_id. Census: GET /sync_runs.

Parameterspagesync_idper_page

census_get_sync_run

Get sync run

Get a single sync run by id — status, counts, errors. Census: GET /sync_runs/{id}.

Parametersidrequired

census_list_segments

List segments

List audience segments defined in the workspace. Census: GET /segments.

Parameterspageper_page

census_list_workspaces

List workspaces

List workspaces in the organization (note: usually requires an organization-level token). Census: GET /workspaces.

Takes no parameters.

census_trigger_sync

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.

Parametersidrequiredforce_full_sync

Version history

v1.36.5LatestNov 8, 2026
v1.36.4Nov 7, 2026
v1.35.3Nov 5, 2026
v1.35.2Nov 5, 2026
v1.35.1Nov 4, 2026
v1.35.0Nov 3, 2026
v1.34.1Nov 3, 2026
v1.33.0Nov 1, 2026
v1.31.0Oct 31, 2026
v1.30.0Oct 31, 2026
v1.29.2Oct 30, 2026
v1.29.0Oct 30, 2026
v1.24.0Oct 26, 2026
v1.21.3Oct 25, 2026
v1.21.0Oct 25, 2026
v1.20.0Oct 24, 2026
v1.17.0Oct 23, 2026
v1.16.4Oct 22, 2026
v1.16.3Oct 21, 2026
v1.11.1Oct 9, 2026
v1.10.0Oct 9, 2026
v1.0.0Sep 16, 2026

Score

100% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

Reached in the last 30 daysRequired25 pts
Auth declaredRequired10 pts
Tools listedRequired15 pts
DescriptionRequired15 pts
Logo10 pts
Documentation15 pts
License10 pts