List reverse-ETL sources, destinations, models, syncs and runs; trigger syncs into SaaS tools. Hosted by usefulapi: connect it to Claude, ChatGPT, Cursor or any MCP client.
Turn on the Census connector, then ask in plain words. The AI picks the tools.
For data and operations teams who sync warehouse data into SaaS tools with Census.
The AI lists sync runs, optionally for one sync, and reads status, records processed and errors. You see which runs worked and which failed.
The AI lists your syncs with their source and destination attributes and reads the full setup of one sync. You get a clear map of what feeds which tool.
The AI lists the models in the workspace and reads the query of one model. You can see which rows a sync takes from the warehouse.
The AI lists the data warehouse sources (such as Snowflake or BigQuery) and the audience segments defined in the workspace.
The AI finds the sync and triggers a run that writes records into the destination tool. It can also force a full sync of all rows instead of only changes.
Changes dataThe login page asks for your Census API key.
Find it in Census → Settings → API (create a workspace API key). Your key is used only to call the API on your behalf and to derive a private account id; it is never shown to anyone.
Team and Enterprise: an Owner adds the connector for the organization first.
No Add custom MCP server option? It depends on your account or workspace settings: see OpenAI's guide.
Run this command, then run /mcp in Claude Code to log in:
Add to Cursor or add this to ~/.cursor/mcp.json:
{
"mcpServers": {
"census": {
"url": "https://census.usefulapi.io/mcp"
}
}
} Add to VS Code or add this to .vscode/mcp.json:
{
"servers": {
"census": {
"type": "http",
"url": "https://census.usefulapi.io/mcp"
}
}
} Run these commands. The second one opens the login page:
Windsurf, Cline, Zed and other MCP clients: add this URL as a remote MCP server (Streamable HTTP). The client then opens the login page in your browser.
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: the login page asks for your Census API key. If the config has such a header, remove it: some clients then send that header instead of the login token, and every call fails with 401.
| Plan | Price | Limit |
|---|---|---|
| Free | $0 | 50 tool calls / month |
| Proper user | $9/mo · $90/yr | 10,000 tool calls / month |
| Pro+per user | $39/mo · $390/yr | 100,000 tool calls / month |
Each paid plan covers this Census server only. Ask your AI to run census_upgrade and choose Pro or Pro+, billed monthly or yearly (it returns a Stripe Checkout link). If you already have Pro, ask to change it to Pro+. The change requires your confirmation, keeps your billing interval and charges the price difference for the rest of the period immediately. Cancel any time with census_cancel_subscription: your paid plan continues to the end of the paid period, with no refund for the current period, and asking to resume the same plan with census_upgrade before then undoes the cancel. Or write to [email protected].
census_list_sourcescensus_get_sourcecensus_list_destinationscensus_get_destinationcensus_list_modelscensus_get_modelcensus_list_syncscensus_get_synccensus_list_sync_runscensus_get_sync_runcensus_list_segmentscensus_list_workspacescensus_trigger_synccensus_usage_statuscensus_request_featurecensus_upgradecensus_cancel_subscriptionCheck recent sync runs and their status. See where each sync sends its data. Read the SQL behind a model. Check connected warehouse sources and segments. Start a sync run. See what you can do for the details.
No. usefulapi is an independent service. It is not affiliated with or endorsed by Census. The server calls the Census API with your own Census access, so it sees only the data that your account can see.
Yes. In Claude, add this server's URL as a custom connector. In ChatGPT, add it as a custom MCP server in Plugins. Then log in once. Cursor, VS Code, Claude Code and Codex work too. See the setup steps.
The login page asks for your Census API key. See Before you connect for where to find it.
No. 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: the login page asks for your Census API key. If the config has such a header, remove it: some clients then send that header instead of the login token, and every call fails with 401.
The login stores them encrypted in the authorization grant of your connection. The server uses them to call the Census API for you and to derive a private account id for usage metering. usefulapi does not show them on any page or in any reply. To stop all access, remove the connector and change or delete these credentials in Census.
Yes, if you approve it. 1 of the 13 Census tools can create or change data. The other 12 are marked read-only. Most MCP clients ask you to approve a tool call before it runs.
The Free plan gives 50 tool calls / month. Pro costs $9/mo or $90/yr, with 10,000 tool calls / month. Pro+ costs $39/mo or $390/yr, with 100,000 tool calls / month. Each subscription covers this Census server only. Cancel any time: your paid plan then runs to the end of the paid period. Run census_usage_status to see how many calls you used.
Ask the AI to run census_upgrade and choose Pro or Pro+, billed monthly or yearly: it returns a Stripe Checkout link. If you already have Pro, ask to change it to Pro+. After you confirm, your existing subscription changes in place, keeps its billing interval and charges the price difference for the rest of the period immediately. To cancel, run census_cancel_subscription. Your paid plan continues to the end of the paid period.
Tell the AI what you wanted to do. It can send the request with census_request_feature. We store the text with the server name, the type of AI client and the tool you tried, not with your account, and read every request when we plan new tools. You can send up to 5 requests per day.
Any client that supports remote MCP servers (Streamable HTTP) with OAuth login: Claude (web and desktop), Claude Code, ChatGPT, Codex, Cursor, VS Code, Windsurf and others.
This is a Model Context Protocol endpoint — meant to be connected from an AI client, not opened in a browser. An invalid_token response at the URL is the auth gate working as designed; clients authenticate automatically.
Need a tool this server does not have, or a connection to another system? We build custom integrations and MCP servers.