MCP servers that ship as code — a repository or a package you install and run locally (usually over stdio). They have no hosted endpoint, so we cannot probe or grade them: instead each one shows its repository, install command, license, stars and when it was last updated.
Collected from GitHub repositories and npm, PyPI, Cargo, Go, Maven, NuGet and RubyGems packages tagged as MCP servers, the official MCP Registry, Docker's MCP catalog, ModelScope, Baidu MCP World, Cline and other public directories; one entry per repository. A server that also offers a hosted endpoint is listed under Remote instead. These entries are not counted in our reachability, verification or readiness statistics.
-
Read-only MCP server over a DuckDB financial warehouse: AST-validated SQL guard, per-table allow-list, audit logging
MIT -
warehouse-mcpgithub.com/kalehdoo/warehouse-mcpupdated this year
mcp enabled data warehouse
npm Apache-2.0 -
Secure MCP server that lets AI assistants answer business questions from a data warehouse: semantic layer, 2-layer SQL guardrails, audit log, evals
-
Python CLI and MCP server for Microsoft Fabric Data Warehouses and SQL Analytics Endpoints: administer, query, optimize, and secure them from your terminal or your AI agent.
pypi MIT ★ 10 -
Self-hosted MCP server for secure AI access to Snowflake data warehouses.
NOASSERTION -
On-premise database agent for Kyomi — connects your data warehouse securely
cargo Apache-2.0 -
Servidor MCP somente leitura para o Data Warehouse do e-SUS APS / PEC (PostgreSQL)
MIT ★ 2 -
A sovereign, local-first MCP-Native ETL System with Hot/Cold tiering, PII scrubbing, ID stitching, Parquet buffers, and data warehouse exports.
pypi MIT -
BigQuery MCP server by Coupler.io for querying and analyzing data warehouse data with natural language and AI.
MIT ★ 1 -
mcp-servergithub.com/kyomi-ai/mcp-serverupdated this year
Kyomi MCP Server — query your data warehouse from Claude Code, Cursor, and any MCP client
-
dstgithub.com/get-dst/dstactive
dst (data serve tool) — open-source semantic layer and MCP server between the AI your team uses and your data warehouse. Governed answers with the SQL, a grade and a receipt.
pypi Apache-2.0 ★ 18 -
MCP Client and Server apps to demo integration of Azure OpenAI-based AI agent with a Data Warehouse, exposed through GraphQL in Microsoft Fabric.
MIT ★ 11 -
Python CLI and MCP server for Microsoft Fabric Data Warehouses and SQL Analytics Endpoints: administer, query, optimize, and secure them from your terminal or your AI agent
pypi MIT -
Full-Funnel AI Marketing Analytics. A modern data stack powered by dbt MetricFlow and MCP. Natural language insights across Google/Meta Ads, CRM, and 5 data warehouses. Includes XGBoost lead scoring and a $0/mo architecture.
MIT ★ 26 -
Full-stack Warehouse Management System built with ASP.NET Core, PostgreSQL, AI-assisted data entry, REST API, MCP tools, and Azure deployment.
MIT -
piiscangithub.com/cognis-digital/piiscanupdated this year
PII discovery across warehouses and lakes (data-side scanner)
NOASSERTION ★ 2 -
Airflow-orchestrated tiered data platform: raw Parquet, a 14-table DuckDB warehouse, and an MCP server for a Claude agent.
-
duckprobegithub.com/cognis-digital/duckprobeupdated this year
Zero-setup data-quality checks on any file or warehouse via DuckDB
NOASSERTION -
Read-only MCP server over the Toronto open data warehouse: curated tools plus sqlglot-checked SQL, a least-privilege role and read-only transactions, tested end to end over MCP
MIT -
dalgo-mcpgithub.com/DalgoT4D/dalgo-mcpupdated this year
MCP server for the Dalgo data platform — lets AI assistants work with data warehouses, pipelines, dbt transformations, dashboards, charts and reports via natural language
MIT -
Run Verity, the AI marketing data platform and warehouse native CDP, from ChatGPT, Claude, Codex or Cursor over MCP. Docs, tool reference and examples.
CC-BY-4.0 -
A Model Context Protocol (MCP) server for Trino, enabling AI assistants like Claude to query and explore data warehouses.
go Apache-2.0 ★ 5 -
Open-source data quality monitoring: checks across warehouses, lakehouses and object stores, triggered by ADF, Airflow and dbt, with alerting and an MCP server.
MIT -
etl-pipeline-mcpgithub.com/seosiri-official/etl-pipeline-mcpupdated this year
A sovereign, local-first MCP-Native ETL System with Hot/Cold tiering, PII scrubbing, ID stitching, Parquet buffers, and data warehouse exports.
pypi MIT -
WorldEconomygithub.com/kschmidt1144/WorldEconomyupdated this year
World Economy Lab - economics from primary data: a DuckDB warehouse (year 1 CE to 2101, 26 sources, ~14.9M observations), a fully computed chaptered report, and an MCP query apparatus (econlab).
-
my-bigquery-showcasegithub.com/pafumat/my-bigquery-showcaseupdated this year
Natural-language analytics for Google BigQuery via a Claude MCP server — lets non-technical users query a data warehouse by simply asking questions. Built & deployed in production.
-
Local NFL analytics platform: DuckDB warehouse (2007+), Streamlit dashboard, AI analyst via MCP, Kalshi market tracker, auto-updating data & news
MIT ★ 1 -
football-analystgithub.com/mikeu66/football-analystupdated this year
Local-first NFL data warehouse (DuckDB) with a curated MCP server for fantasy-football analysis in Claude, plus a Streamlit explorer
MIT -
HRSA health center sites — where federally funded community health centers (FQHCs) and FQHC look-alikes operate, with address, phone, hours and distance. Source: HRSA Data Warehouse, Health Center Program site data. US federal data, public domain.
MIT -
A universal multi-cloud data MCP Server supporting over 40 types of data source connections, providing secure, unified data access in a single platform. Supports full range of Alibaba Cloud services and Mainstream databases/data warehouses.
pypi Apache-2.0 ★ 54 -
Local-first Garmin data warehouse with an analysis-grade MCP server. Sync once, analyze forever - even when the API is down.
pypi MIT -
dbhub-analyticsgithub.com/amansingh63/dbhub-analyticsupdated this year
MCP server for Databricks SQL, Google BigQuery, PostgreSQL, MySQL, SQL Server, SQLite, MariaDB — connect AI assistants to cloud data warehouses and databases
npm MIT -
Read-only MCP gateway that unifies factory systems (MES / PLM / OA / data warehouse) behind one process, one connection pool per source, and 24 agent tools
-
Local-first Garmin data warehouse with an analysis-grade MCP server. Sync once, analyze forever - even when the API is down.
pypi MIT ★ 9 -
cordis-mcp-servergithub.com/tavitatavi/cordis-mcp-serverupdated this year
FastMCP server exposing read-only, typed tools over a DuckDB warehouse of CORDIS EU research-funding data, plus a LangGraph agent and an LLM-judged evaluation harness.
★ 1 -
complex-ui-testergithub.com/speechlabinc/complex-ui-testerupdated this year
CUIT — the deterministic feedback edge for agentic UI engineering. Recorder + harness + spec-gen + data warehouse. complex-ui-tester is the canonical npm/repo name.
MIT ★ 1 -
An analyst agent over three of my data builds, served as an MCP server, where every number is read back to the warehouse before it is shown. Graded on 150 known answers.
Apache-2.0 -
One-command "ChatGPT for your data" demo: LibreChat + Wren AI MCP text-to-SQL over a mock retail Postgres warehouse, with SearXNG web search and chart artifacts. Runs in Docker Compose.
★ 1 -
warehouse-agent-mvpgithub.com/juebunengkun/warehouse-agent-mvpupdated this year
Report-to-Warehouse controlled agent MVP with LangGraph, MCP, RAG, sqlglot, metadata providers, information_schema, and optional DataHub MCP integration.
★ 1 -
Governed, read-only MCP access to DuckDB, Postgres and BigQuery for AI agents: semantic layer, SQL guard, row policies, PII pseudonymization, audit log, cost caps. Red-teamed and eval-gated.
pypi MIT -
Read-only MCP server over a SQL warehouse: SELECT-only guard, locked read-only connection, salted PII pseudonyms, EXPLAIN pre-flight, audit log, security and answer-quality evals.
MIT ★ 1 -
Warehouse-context-layergithub.com/vaishu1408/Warehouse-context-layerupdated this year
A machine-readable semantic context layer that gives AI agents governed context about a dbt + BigQuery warehouse, built with the Claude API and Model Context Protocol.
MIT -
Your entire data pipeline. One platform
pypi AGPL-3.0 -
opensnowgithub.com/EBD-Sweden/opensnowupdated this year
OpenSnow — an open-source, Snowflake-style analytics warehouse in Rust: SQL over Parquet/Iceberg, dbt pipelines with lineage, dashboards, and a full MCP control plane for AI agents.
Apache-2.0 -
Canonical monorepo for the Irmin data platform, AI, Console, Connectors, and SDKs
NOASSERTION ★ 1 -
Query-cost foresight for AI agents across 12 database engines — preflight SQL/NoSQL/graph/warehouse/vector queries before you run them (MCP server).
pypi MIT -
A semantic data platform MCP server that composes multiple data tools with bidirectional cross-injection - tool responses automatically include critical context from other services.
go Apache-2.0 ★ 10 -
Connect Claude, ChatGPT and any MCP client to 85+ marketing data sources with the Power My Analytics MCP server.
NOASSERTION -
@renzo.johnson/bigquery-mcpactive
BigQuery MCP server for Claude Code, Cursor, Copilot and five more AI agents.
npm MIT -
Pre-flight query cost and result-size guardrails for AI agents across BigQuery, Snowflake, and Databricks
go MIT ★ 1 -
redshift-mcpgithub.com/DiligentBorer/redshift-mcpupdated this year
通用 Amazon Redshift MCP Server(Streamable HTTP)+ 插件框架:内置只读查询三件套(list_tables/describe_table/run_sql),支持 entry_points 插件与声明式 SQL 工具扩展
MIT -
@einlogic/mcp-fabric-apiactive
MCP server for Microsoft Fabric REST APIs — enables data engineers and data analysts to use AI assistants beyond Copilot to build and manage Fabric components
npm AGPL-3.0 -
Conversational OTT/streaming analytics: KPI dashboards over 5.4M viewing events in ClickHouse Cloud, queried in natural language via LibreChat + Model Context Protocol (MCP), visualized in Apache Superset, with in-database SQL forecasting. Docker Compose, one-command setup.
Apache-2.0 -
An open source MCP and REST server for Malloy semantic models, so AI agents, applications, and BI tools query one governed model instead of raw SQL.
npm -
Agentic ETL pipeline for FOIA & public comments — LangGraph, MCP, PII vault, Medallion warehouse (DuckDB/BigQuery)
Apache-2.0 -
ghost-featuresgithub.com/neoquantx/ghost-featuresupdated this year
Detects ML features whose upstream warehouse columns were renamed, dropped, or changed type — using DataHub's schema and ML lineage metadata via the MCP Server.
Apache-2.0 -
Natural-language analytics over a governed Snowflake warehouse: LangGraph agent, MCP tool server, role-based PII masking, eval harness, Terraform on AWS.
-
PR-time dbt lineage, impact analysis and rebuild plans — no warehouse, no Python. CLI, TUI, GitHub Action and MCP server, written in Rust.
pypi MIT ★ 23 -
Odoo + FEC ledger + warehouse API consolidated in DuckDB; SQL three-way-match controls recover all 22 planted discrepancies; LLM agent queries it via MCP
MIT -
Identity-scoped schema selection for text-to-SQL: give the model only the tables this caller may read (a 91% median prompt saving on 50+ table warehouses)
pypi Apache-2.0