Census MCP by usefulapi

io.usefulapi由 usefulapi.io 发布官方发布者v1.36.5更新于 Nov 8, 2026

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

发布方自己的服务：Ably MCP by usefulapi

已验证Streamable HTTP可网页运行数据与分析商业与电商

概览

AI 生成的概览

托管的 Census 反向 ETL 服务器：让助手查看源、目标、模型、同步与运行历史，并可触发向 SaaS 工具的数据同步。

可以做什么
  • 列出并查看数据仓库源与目标连接，例如 Salesforce、HubSpot、Marketo
  • 列出并读取 SQL 模型及其查询语句
  • 列出并读取同步配置，包括源端与目标端字段映射
  • 列出并读取同步运行历史，含状态、处理记录数、耗时与错误
  • 列出受众分群与组织内的工作区
  • 触发一次同步运行（可选全量重跑），并查看用量、管理订阅
适用场景
适合使用 Census 反向 ETL 的场景：想通过助手查询有哪些同步、数据发往何处、最近运行情况如何，或无需打开 Census 界面就启动一次同步。
运行要求
通过 HTTP 连接的远程 MCP 端点，无需本地安装。使用 OAuth 登录，首次连接时需粘贴 Census API 密钥（位于 Census 工作区设置的 API Access），按用户存储。列出工作区通常需要组织级令牌。免费方案每月 50 次工具调用。
安装前请注意
census_trigger_sync 会启动真实同步，把记录写入所连接的目标 SaaS 工具，force_full_sync 会重跑全部行，执行前应确认。服务器会索取 Census API 密钥，该密钥可访问你的 Census 工作区。元工具可发起 Stripe 付费结账或取消订阅，用量按方案计费。

安装

在 SourceWeft 中

  1. 打开 控制台中的 Census MCP by usefulapi，将其添加到工作区。
  2. 为需要使用其工具的对话启用该服务。

Web executable，通过 Streamable HTTP。 远程服务在工作区中配置后即可从网页运行时运行。

交给智能体安装

把这段提示词粘贴到 Claude Code、Codex、Cursor 等智能体，或 SourceWeft 对话中。智能体会读取该服务器的安装指南，先向你展示发布者、端点和登录方式，经你同意后再把它添加到你的客户端。密钥不会写进任何命令。

阅读 https://sourceweft.com/mcp/io.usefulapi%2Fcensus/install.md，并按其中说明把这个 MCP 服务器接入我的客户端。修改任何配置之前，先告诉我它的发布者、端点和登录方式，等我确认。不要把 API 密钥写进命令或我会提交的文件；问我密钥应从哪里获取。

查看智能体所依据的安装指南

其他 MCP 客户端

把它添加到你客户端的 mcpServers 配置中。

{
  "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:
json
{  "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 or Pro+
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.

来源：servers/census/README.md，提交 4046075

工具

13

census_list_sources

List sources

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

输入参数pageper_page

census_get_source

Get source

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

输入参数id必填

census_list_destinations

List destinations

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

输入参数pageper_page

census_get_destination

Get destination

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

输入参数id必填

census_list_models

List models

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

输入参数pageper_page

census_get_model

Get model

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

输入参数id必填

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.

输入参数pageper_page

census_get_sync

Get sync

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

输入参数id必填

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.

输入参数pagesync_idper_page

census_get_sync_run

Get sync run

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

输入参数id必填

census_list_segments

List segments

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

输入参数pageper_page

census_list_workspaces

List workspaces

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

无需输入参数。

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.

输入参数id必填force_full_sync

版本历史

22
  1. v1.36.5最新Nov 8, 2026
  2. v1.36.4Nov 7, 2026
  3. v1.35.3Nov 5, 2026
  4. v1.35.2Nov 5, 2026
  5. v1.35.1Nov 4, 2026
  6. v1.35.0Nov 3, 2026
  7. v1.34.1Nov 3, 2026
  8. v1.33.0Nov 1, 2026
  9. v1.31.0Oct 31, 2026
  10. v1.30.0Oct 31, 2026
  11. v1.29.2Oct 30, 2026
  12. v1.29.0Oct 30, 2026
  13. v1.24.0Oct 26, 2026
  14. v1.21.3Oct 25, 2026
  15. v1.21.0Oct 25, 2026
  16. v1.20.0Oct 24, 2026
  17. v1.17.0Oct 23, 2026
  18. v1.16.4Oct 22, 2026
  19. v1.16.3Oct 21, 2026
  20. v1.11.1Oct 9, 2026
  21. v1.10.0Oct 9, 2026
  22. v1.0.0Sep 16, 2026

评分

已满足适用检查项的 100%

该评分衡量此收录条目的完整程度，依据注册中心条目、端点与公开来源计算得出。它不是对服务器本身的评价，也不表示服务器安全或当前可用：可连通性是带日期的检查结果，评分也不包含安装量或用户评价。

  • 近 30 天内可连通必需25 分
  • 已声明认证方式必需10 分
  • 已列出工具必需15 分
  • 描述必需15 分
  • 图标10 分
  • 文档15 分
  • 许可证10 分

其他 Usefulapi 集成

Ably MCP by usefulapi

io.usefulapi官方发布者

面向 Ably 实时消息的托管 MCP 服务器：查看频道历史、在线状态与占用情况，发布消息，并查看应用用量与配置。

Streamable HTTP可网页运行
云端与基础设施15 个工具Nov 8, 2026

Tiltify MCP by usefulapi

io.usefulapi官方发布者

托管的只读 MCP 服务器，让助手读取 Tiltify 的募捐活动、捐款记录以及捐款人和筹款人排行榜。

Streamable HTTP可网页运行
金融5 个工具Nov 8, 2026

Termii MCP by usefulapi

io.usefulapi官方发布者

托管的 Termii 服务器，让助手发送短信，并查询钱包余额、DND 状态、发送方 ID 和消息记录。

Streamable HTTP可网页运行
沟通与协作5 个工具Nov 8, 2026

Temp Stick MCP by usefulapi

io.usefulapi官方发布者

托管型 MCP 服务器，让助手读取 Temp Stick 的温度与湿度传感器、其读数以及告警通知。

Streamable HTTP可网页运行
位置与生活4 个工具Nov 8, 2026

Stibee MCP by usefulapi

io.usefulapi官方发布者

将助手连接到 Stibee 邮件营销工作区，可读取地址簿、订阅者和邮件统计，并添加订阅者与分组。

Streamable HTTP可网页运行
沟通与协作15 个工具Nov 8, 2026