mcpField
C
Census MCP by usefulapi

Census MCP by usefulapi

Remote
usefulapi.ioDatabases0Updated today

About Census MCP by usefulapi

Census MCP by usefulapi is a hosted MCP server for teams managing Census reverse-ETL. It lets MCP clients inspect sources, destinations, models, syncs, and run history, and trigger syncs that send warehouse data to SaaS tools.

Key features

  1. 01List and inspect sources and destinations
  2. 02Browse models and syncs
  3. 03Review sync run history
  4. 04List segments and workspaces
  5. 05Trigger data syncs

Use cases

  1. 01Check Census configuration and sync status
  2. 02Send warehouse data to SaaS tools

MCP support

Exposes Census workspace, source, destination, model, sync, segment, and run operations to MCP clients. The hosted server accepts the user's Census API key and includes a tool for triggering syncs.

Configuration

Remote servers need no local install. Pick your client, then copy the config or install in one click.

Endpointhttps://census.usefulapi.io/mcp
Copy install command
Claude CodeTerminal
Cursor.cursor/mcp.json
VS Code.vscode/mcp.json
Claude Desktopclaude_desktop_config.json
Windsurf~/.codeium/windsurf/mcp_config.json

Run commands in a terminal; paste JSON into the client’s MCP config and restart. Servers that need sign-in will prompt on first connect.

Tools

13
ParameterTypeRequiredDescription
pageintegerNoPage number (1-based) for pagination.
per_pageintegerNoNumber of records per page.

Details

From the project 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:
{
  "mcpServers": {
    "census": {
      "url": "https://census.usefulapi.io/mcp"
    }
  }
}

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

ToolTypeWhat it does
census_list_sourcesreadList sources
census_get_sourcereadGet source
census_list_destinationsreadList destinations
census_get_destinationreadGet destination
census_list_modelsreadList models
census_get_modelreadGet model
census_list_syncsreadList syncs
census_get_syncreadGet sync
census_list_sync_runsreadList sync runs
census_get_sync_runreadGet sync run
census_list_segmentsreadList segments
census_list_workspacesreadList workspaces
census_trigger_syncwriteTrigger sync
census_usage_statusmetaUsage status (free-tier meter)
census_request_featuremetaRequest a missing feature
census_upgrademetaUpgrade to Pro (unlimited*)
census_cancel_subscriptionmetaCancel 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

PlanPriceLimit
Free$050 tool calls / month
Pro (per user)$9/mo or $90/yr (2 months free)Unlimited*

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

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.