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