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
- 01List and inspect sources and destinations
- 02Browse models and syncs
- 03Review sync run history
- 04List segments and workspaces
- 05Trigger data syncs
Use cases
- 01Check Census configuration and sync status
- 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.
https://census.usefulapi.io/mcpclaude mcp add --transport http io-usefulapi-census https://census.usefulapi.io/mcp{"mcpServers":{"io-usefulapi-census":{"type":"http","url":"https://census.usefulapi.io/mcp"}}}Open in Cursor{"servers":{"io-usefulapi-census":{"type":"http","url":"https://census.usefulapi.io/mcp"}}}Open in VS Code{"mcpServers":{"io-usefulapi-census":{"type":"http","url":"https://census.usefulapi.io/mcp"}}}{"mcpServers":{"io-usefulapi-census":{"serverUrl":"https://census.usefulapi.io/mcp"}}}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| Parameter | Type | Required | Description |
|---|---|---|---|
| page | integer | No | Page number (1-based) for pagination. |
| per_page | integer | No | Number of records per page. |
Details
From the project READMECensus 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/mcpto 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
| 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 (unlimited*) |
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
| Plan | Price | Limit |
|---|---|---|
| Free | $0 | 50 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
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.