Best MCP Servers for Data Pipelines and ETL in 2026
Data engineers can now give AI agents direct access to their full pipeline stack — DuckDB for analytics, dbt for transformation, Airflow for orchestration, BigQuery for the warehouse, Redis for streaming. We scored 720 data-category MCP servers from the AgentRank index using real GitHub signals. Below are the top 10. Data as of March 19, 2026.
Full comparison table
All scores are on a 0–100 scale. The average across 720 data tools is 27.4. The tools below represent the top tier — all scoring above 70.
| # | Repository | Score | Stars | Issue Close % | Use Case | Lang |
|---|---|---|---|---|---|---|
| 1 | motherduckdb/mcp-server-motherduck DuckDB in-process analytics and MotherDuck cloud scale | 89.06 | 442 | 80% | Analytics / OLAP | Python |
| 2 | redis/mcp-redis Official Redis MCP Server — natural language for streams, cache, search | 88.84 | 454 | 68% | Streaming / Cache | Python |
| 3 | mongodb-js/mongodb-mcp-server Official MongoDB MCP server — documents and Atlas clusters | 88.56 | 965 | 84% | Document Storage | TypeScript |
| 4 | tableau/tableau-mcp Tableau's official MCP Server — data visualization and BI access | 84.32 | 202 | 73% | Data Viz / BI | TypeScript |
| 5 | benborla/mcp-server-mysql Read-only MySQL access via MCP — schema inspection and SQL queries | 85.22 | 1,361 | 53% | Relational (MySQL) | JavaScript |
| 6 | astronomer/agents AI agent tooling for data engineering and Airflow workflows | 77.89 | 280 | 57% | Airflow / Orchestration | Python |
| 7 | dbt-labs/dbt-mcp Official dbt MCP server — run models, tests, and queries | 76.04 | 507 | 68% | Transformation / dbt | Python |
| 8 | runekaagaard/mcp-alchemy Multi-database MCP via SQLAlchemy — Postgres, MySQL, SQLite, Oracle, MSSQL | 74.93 | 397 | 100% | Multi-DB (SQLAlchemy) | Python |
| 9 | LucasHild/mcp-server-bigquery Google BigQuery access via Model Context Protocol | 75.28 | 123 | 41% | BigQuery / Data Warehouse | Python |
| 10 | yangkyeongmo/mcp-server-apache-airflow Apache Airflow orchestration via MCP — DAG management and monitoring | 71.1 | 148 | 56% | Orchestration (Airflow) | Python |
Top 10 breakdown
#1 — motherduckdb/mcp-server-motherduck (89.06)
motherduckdb/mcp-server-motherduck leads at 89.06. DuckDB runs in-process — there's no separate server, no network round-trips for local queries. This makes it the fastest analytical option for agents processing local Parquet files, CSV exports, or in-memory datasets. When local scale isn't enough, MotherDuck extends it to cloud-hosted DuckDB. 80% issue close rate. Best-in-category for OLAP and analytical workloads.
#2 — redis/mcp-redis (88.84)
redis/mcp-redis scores 88.84 as the official Redis Labs server. For data pipelines, Redis is the glue — pipeline state, task queues, pub/sub messaging, rate limiting, and stream processing. This server exposes all of it through natural language: strings, hashes, sets, sorted sets, streams, and full-text search. 68% issue close rate, official vendor backing for long-term reliability.
#3 — mongodb-js/mongodb-mcp-server (88.56)
mongodb-js/mongodb-mcp-server is the official MongoDB server at 88.56. With 965 stars and an 84% issue close rate — the best of the top 3 — it's the most responsive to issues. Covers both local instances and Atlas cloud clusters. For pipelines ingesting semi-structured data (logs, events, API responses), MongoDB remains the dominant document store and this is its reference MCP server.
#4 — tableau/tableau-mcp (84.32)
tableau/tableau-mcp is Tableau's official server at 84.32. It's the bridge between AI agents and business intelligence — agents can query workbooks, extract underlying data, navigate dashboards, and understand what your organization is measuring. 202 stars, 73% issue close rate. Essential for teams where Tableau sits at the end of the data pipeline as the consumption layer.
#5 — benborla/mcp-server-mysql (85.22)
benborla/mcp-server-mysql scores 85.22 with 1,361 stars — the most-starred MySQL MCP server in the index. It's read-only by design, which is a deliberate safety constraint for production pipelines. Data engineers use it for schema inspection, data quality checks, and SELECT-based validation without risk of accidental mutation. If you need write access, build on top of it or pair with a write-capable layer.
#6 — astronomer/agents (77.89)
astronomer/agents scores 77.89 as the official Astronomer (Apache Airflow) toolkit for data engineering agents. It enables AI-assisted DAG authoring, pipeline debugging, and workflow orchestration — the full Airflow development loop. 280 stars, 57% issue close rate. The highest-scoring Airflow-adjacent tool in the index and the natural choice for teams running Airflow on Astronomer's managed platform.
#7 — dbt-labs/dbt-mcp (76.04)
dbt-labs/dbt-mcp is the official dbt Labs server at 76.04. It sits between your dbt project and any agent — run models, execute tests, inspect schemas, and query outputs through natural language. 507 stars, 68% issue close rate. It's the only dbt-native MCP tool in the index. If your transformation layer is dbt, this is required.
#8 — runekaagaard/mcp-alchemy (74.93)
runekaagaard/mcp-alchemy scores 74.93 with a 100% issue close rate — every reported issue resolved. It uses SQLAlchemy under the hood, which means it connects to any SQLAlchemy-compatible database: Postgres, MySQL, SQLite, MSSQL, Oracle, and more. 397 stars. The best single tool for polyglot data environments where you're querying multiple engines from one pipeline.
#9 — LucasHild/mcp-server-bigquery (75.28)
LucasHild/mcp-server-bigquery scores 75.28 and is the primary MCP tool for Google BigQuery. It supports SQL query execution, dataset inspection, and table schema exploration. 123 stars, 41% issue close rate — the lowest in this list, which signals room for improvement. But it's the only mature BigQuery MCP option in the index, making it the default for GCP-based data warehouses.
#10 — yangkyeongmo/mcp-server-apache-airflow (71.10)
yangkyeongmo/mcp-server-apache-airflow rounds out the list at 71.10. It wraps the Airflow REST API — trigger DAGs, check run status, monitor task logs, manage pipeline health. 148 stars, 56% issue close rate. The choice for teams running self-managed Apache Airflow (versus Astronomer's managed platform). Complements astronomer/agents for Airflow-native orchestration use cases.
Choosing by stack
| Stack / Layer | Best MCP Server | Score | Notes |
|---|---|---|---|
| DuckDB / MotherDuck | mcp-server-motherduck | 89.06 | In-process, fastest analytics, cloud scale |
| Redis Streams / Cache | mcp-redis | 88.84 | Official Redis Labs, all data structures |
| MongoDB / Atlas | mongodb-mcp-server | 88.56 | Official, 84% close rate, Atlas support |
| Tableau / BI | tableau-mcp | 84.32 | Official Tableau, workbook + data access |
| MySQL | mcp-server-mysql | 85.22 | Read-only, 1,361 stars, safe for production |
| Airflow (Astronomer) | astronomer/agents | 77.89 | AI agent tooling for managed Airflow |
| dbt Core / Cloud | dbt-mcp | 76.04 | Official dbt Labs, run models + tests |
| Multi-DB (SQLAlchemy) | mcp-alchemy | 74.93 | 100% issue close, widest DB coverage |
| Google BigQuery | mcp-server-bigquery | 75.28 | Only mature BigQuery MCP in the index |
| Apache Airflow (self-managed) | mcp-server-apache-airflow | 71.10 | Airflow REST API, DAG management |
Scoring methodology
AgentRank scores combine five GitHub signals: stars (15%), commit freshness (25%), issue close rate (25%), contributor count (10%), and inbound dependents (25%). Scores are updated nightly from live crawl data. The average score across all 720 data-category tools is 27.4. Full methodology →
See all 720 data engineering tools ranked. The full leaderboard updates nightly with fresh crawl data — scores shift as maintainers commit, close issues, and gain stars.
Get the weekly AgentRank digest
Top movers, new tools, ecosystem insights — straight to your inbox.