# Estuary Flow MCP by usefulapi

> Estuary Flow MCP by usefulapi is a freemium MCP server for developer tools. Hosted MCP server to inspect Estuary Flow pipelines, stats and publications from AI. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Pricing:** Freemium
- **Starting price:** $9 a month
- **Platforms:** API, CLI, Web, vscode
- **Website:** https://usefulapi.io/estuary-flow/
- **Repository:** https://github.com/m190/usefulapi-mcp/tree/HEAD/servers/estuary-flow
- **MCP Registry name:** io.usefulapi/estuary-flow
- **Categories:** developer tools
- **Listing updated:** 2026-11-18

## About

The README describes this as a hosted remote MCP endpoint, so there is nothing to install locally. You point an MCP client at one URL, sign in with an Estuary Flow refresh token, and the assistant can then read the catalog of captures, collections and materializations on your account.

Beyond reading, the server exposes three write tools for drafts: creating a draft, staging a spec inside it, and publishing it. Publishing defaults to a dry run that only validates; the README warns that switching dry_run off applies changes to live pipelines and can delete them, so clients should ask for confirmation.

The server is an independent service by usefulapi, not an Estuary Flow product. It suits data engineers who want to check pipeline throughput, read job logs for failed publications, or browse connector versions from inside Claude, ChatGPT, Cursor or VS Code. The README says the free tier allows 50 tool calls a month.

## Features

- **Catalog listing:** Lists captures, collections, materializations and tests, filtered by name prefix or spec type.
- **Throughput statistics:** Reports bytes and documents read and written, usage seconds and error counts per time grain.
- **Publication and log inspection:** Shows publication job status and fetches job log lines by logs token to diagnose failures.
- **Connector catalog browsing:** Lists capture and materialization connectors and their image versions with documentation links.
- **Draft staging and validation:** Creates drafts and stages specs, with publish defaulting to a validation-only dry run.
- **OAuth sign-in:** Clients authenticate through a login page using an Estuary Flow refresh token, with no API key in config files.

## Good for

- Checking which data pipelines are currently configured in an Estuary Flow account
- Reviewing how much data a pipeline moved over a given week
- Diagnosing why a publication failed by reading its job logs
- Validating a catalog change as a dry-run draft before applying it
- Looking up available connector versions for a database integration

## Install

### Claude Code (Terminal)

```sh
claude mcp add --transport http estuary-flow https://estuary-flow.usefulapi.io/mcp
```

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://estuary-flow.usefulapi.io/mcp
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "estuary-flow": {
      "url": "https://estuary-flow.usefulapi.io/mcp"
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "estuary-flow": {
      "type": "http",
      "url": "https://estuary-flow.usefulapi.io/mcp"
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "estuary-flow": {
      "serverUrl": "https://estuary-flow.usefulapi.io/mcp"
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "estuary-flow": {
      "type": "http",
      "url": "https://estuary-flow.usefulapi.io/mcp"
    }
  }
}
```

## Tools

- `estuary_list_catalog`: List live catalog entities (captures, collections, materializations, tests) with connector and last-publication metadata.
- `estuary_get_catalog_spec`: Get one live catalog entity by its exact catalog name, including its serialized spec and compiled built spec.
- `estuary_get_catalog_stats`: Get usage and throughput stats for one catalog entity per time grain.
- `estuary_list_connectors`: List the connector catalog of capture and materialization connectors.
- `estuary_list_connector_versions`: List available connector image tags with protocol and documentation URL.
- `estuary_list_drafts`: List the user's draft workspaces for catalog edits.
- `estuary_list_draft_specs`: List staged spec entries within a draft.
- `estuary_list_publications`: List publication history and job status for draft publish attempts.
- `estuary_list_discovers`: List connector discovery jobs for a capture.
- `estuary_list_roles`: List the roles and prefixes the current credential is granted.
- `estuary_get_tenant`: Get tenant quotas, billing tier, recurring charge and trial details.
- `estuary_view_task_logs`: Fetch log lines for a job by its logs token.
- `estuary_create_draft`: Create a new empty draft workspace.
- `estuary_upsert_draft_spec`: Stage or replace a catalog spec inside a draft.
- `estuary_publish_draft`: Validate a draft (dry run by default) or apply it to the live catalog when dry_run is false.
- `estuary_flow_usage_status`: Report current plan usage and remaining tool calls for the month.
- `estuary_flow_request_feature`: Send a request for a capability the tools cannot provide yet.
- `estuary_flow_upgrade`: Get a Pro or Pro+ subscription payment link or change an existing plan.
- `estuary_flow_cancel_subscription`: Cancel the Pro subscription at the end of the paid period.

## FAQ

### Is this an official Estuary Flow product?

No. The README and website say usefulapi is an independent service and is not affiliated with or endorsed by Estuary Flow.

### Can the AI change my pipelines?

Three of the 19 tools can create or change data, including publishing a draft to live pipelines when dry run is off. The rest are read-only or meta tools.

### What does it cost?

The free plan allows 50 tool calls per month. Pro is $9 per month or $90 per year for 10,000 calls, and Pro+ is $39 per month or $390 per year for 100,000 calls.

### Which clients can connect?

Any client supporting remote MCP servers over Streamable HTTP with OAuth, including Claude, ChatGPT, Cursor, VS Code, Claude Code and Codex, according to the website.

### Is Estuary Flow MCP by usefulapi free?

Estuary Flow MCP by usefulapi has a free plan, with paid plans for more usage or features. Paid plans start at $9 a month.

### How do I add Estuary Flow MCP by usefulapi to Claude Code?

Run this command in your terminal: claude mcp add --transport http estuary-flow https://estuary-flow.usefulapi.io/mcp

### What are the best alternatives to Estuary Flow MCP by usefulapi?

The closest alternatives to Estuary Flow MCP by usefulapi are REA, Codebase Memory, GitHub, Serena MCP: the IDE for your agent and XERJ.

## Where this comes from

- Description: written from the project's README, the project's website and its MCP Registry entry.
- Install steps: from the official MCP Registry entry.

## Alternatives

- [REA](https://ai-powered.com/mcp/rea): REA is an open-source MCP server for developer tools.
- [Codebase Memory](https://ai-powered.com/mcp/codebase-memory): Codebase Memory is an open-source MCP server for knowledge and memory.
- [GitHub](https://ai-powered.com/mcp/github-2): GitHub is an open-source MCP server for developer tools.
- [Serena MCP: the IDE for your agent](https://ai-powered.com/mcp/serena-mcp-the-ide-for-your-agent): Serena MCP: the IDE for your agent is an open-source MCP server for developer tools.
- [XERJ](https://ai-powered.com/mcp/xerj): XERJ is an open-source MCP server for knowledge and memory.
- [Ouroboros](https://ai-powered.com/mcp/ouroboros): Ouroboros is an open-source MCP server for developer tools.
- [Claude Code Ultimate Guide](https://ai-powered.com/mcp/claude-code-ultimate-guide): Claude Code Ultimate Guide is an open-source MCP server for ai models and llm tooling.
- [Concord MCP](https://ai-powered.com/mcp/concord-mcp): Concord MCP is a freemium MCP server for developer tools.

---
Source: https://ai-powered.com/mcp/estuary-flow-mcp-by-usefulapi
