Skip to main content
Glama
NGRThomson

airbyte-oss-mcp

by NGRThomson

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
AIRBYTE_URLNoBase URL of your Airbyte instance. Default is http://localhost:8000http://localhost:8000
AIRBYTE_ENVSNoJSON map of named envs for multi-instance setups
AIRBYTE_API_TOKENNoBearer token if public API auth is enabled
AIRBYTE_READ_ONLYNoWhen false, exposes cancel_job and trigger_sync. Default is truetrue
AIRBYTE_DEFAULT_ENVNoDefault key when AIRBYTE_ENVS has multiple entries

Capabilities

Features and capabilities supported by this server

CapabilityDetails
tools
{
  "listChanged": true
}
logging
{}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}
extensions
{
  "io.modelcontextprotocol/ui": {}
}
experimental
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
get_instance_statusA

Global Airbyte health snapshot. Start here for monitoring workflows.

Returns health text, workspace count, connection counts by status, and counts of running / pending / failed sync jobs (recent sample).

list_connectionsA

List Airbyte connections with schedule and status metadata.

Filters:

  • name_prefix: case-insensitive substring on connection name

  • status: exact status filter (e.g. 'active')

  • limit: max results (paginates beyond the 100-item API page size when needed)

  • offset: skip first N connections from the API ordering

get_connectionA

Get one connection by exact name or connectionId UUID.

Returns connection metadata with stream summaries (name, namespace, prefix, syncMode) and the three most recent sync jobs.

list_jobsA

List recent sync jobs, newest first.

Returns jobId, status, startTime, duration, bytesSynced, rowsSynced, connectionId, and connectionName.

Filters:

  • connection: connection name, UUID, or substring (must match exactly one)

  • status: pending, running, incomplete, failed, succeeded, cancelled

  • limit: max results (paginates beyond the 100-item API page size when needed)

  • offset: skip first N jobs from the API ordering

get_active_syncsB

List all currently running sync jobs with connection names.

Best tool to answer 'what is blocking the Airbyte worker pool?' or 'why is this sync taking so long?'

find_duplicate_destination_tablesA

Detect multiple active connections writing the same BigQuery project.dataset.table.

Best-effort audit using connection stream config and destination settings. Skips non-BigQuery destinations and inactive connections.

get_jobC

Get public job metadata for a sync job id.

get_job_detailsA

Get job plus attempt stats via the internal OSS jobs API.

Includes per-attempt totalStats and failure summaries (without raw logs).

get_job_failure_summaryA

Consolidated failure diagnosis for a sync job (prefer over raw logs).

Returns root-cause failure messages from the latest failed attempt, plus job/connection context and row/byte stats when available.

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/NGRThomson/airbyte-oss-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server