data-platforms MCP servers & tools

Confluent integration to interact with Confluent Kafka and Confluent Cloud REST APIs.

Official PostHog MCP Server for product analytics, feature flags, experiments, and more.

Validate oh-my-posh configurations and segment snippets against the official schema.

MCP server for Capsule CRM. 81 tools (49 in read-only mode) covering contacts, opportunities, projects, tasks, timeline activity, structured + saved filters, workflow tracks, and file attachments. Two transports — stdio (npx capsulemcp) and HTTP+OAuth for hosted Custom Connectors. Read-only-mode env flag for safer defaults. Apache 2.0.

68 tools for Swiss open data: transport, weather, geodata, companies, parliament, and more. Zero API keys required.

Define, ship & query your analytics tracking from one source of truth, trusted by humans and agents.

The Redis official MCP Server offers an interface to manage and search data in Redis.

MCP Server for natural language querying of Snowflake, Google BigQuery, and DataBricks Data Products through Alkemi.ai.

Official MCP server for dbt (data build tool) providing integration with dbt Core/Cloud CLI, project metadata discovery, model information, and semantic layer querying capabilities.

Open-source data catalog. Search assets, explore lineage, and find ownership.

MCP and MCP SSE Server that automatically generate API based on database schema and data. Supports PostgreSQL, Clickhouse, MySQL, Snowflake, BigQuery, Supabase

96 tools across 21 modules for La Réunion (French overseas region) open data: economy, demographics, geography, transport, health, education, elections, tourism, housing, environment, and more. Powered by data.regionreunion.com and data.gouv.fr. Install: npx -y mcp-reunion.

Brazilian public data for AI agents — companies (CNPJ), addresses (CEP), banks (BACEN), national holidays — via BrasilAPI. No auth, no API key. Install: npx -y brasil-data-mcp.

HelpMyAgent is a remote MCP server for AI agents that need structured, agent-ready data and services on demand. Agents can discover available capabilities, inspect input/output schemas, pricing, provenance, coverage and limitations, then execute the appropriate tool over Streamable HTTP. Paid calls use x402 v2 with supported digital payment rails, without subscriptions or API keys.

MCP server that connects to Apache Airflow using official client.

Reference implementation of an "operational ontology": MCP tools are generated from a typed business domain model (objects, links, actions) — one tool per query shape and per action, deliberately no raw SQL tool. Writes pass business-rule preconditions, are audited, and write back to the systems of record; refusals are machine-readable. Demo scenario included (pnpm demo / pnpm mcp).

MCP server connecting Claude to Metabase with 28 tools for natural language data analysis, dashboard management, SQL queries, and automated insights. Features SQL guardrails, rate limiting, and audit logging.

data.ny.gov — New York State open-data Socrata portal

Airflow REST API — 7 tools (DAG list, runs, task instances, log tails, trigger, clear). dag-health-rollup aggregation. Airflow 3.x /api/v2 + JWT (SimpleAuthManager); pin 0.1.x for Airflow 2.x. Read-only by default; trigger/clear write-gated.

Universal database MCP server supporting multiple database types including PostgreSQL, Redshift, CockroachDB, MySQL, RDS MySQL, Microsoft SQL Server, BigQuery, Oracle DB, and SQLite.

data.overheid.nl MCP — the Netherlands national open-data portal (CKAN API).

MCP server for Google Sheets API integration with comprehensive reading, writing, formatting, and sheet management capabilities.

Netherlands Open Data (data.overheid.nl/data) CKAN MCP.

Query Swedish public data through Apiverket, including company data, SCB statistics, weather, transport, and more. Install: npx -y apiverket-mcp-server.

interact with Keboola Connection Data Platform. This server provides tools for listing and accessing data from Keboola Storage API.

Link multiple data sources (SQL, CSV, Parquet, etc.) and ask AI to analyze the data for insights and visualizations.

MCP server for VTENext CRM (open-source vtiger-based). Query, create and update opportunities and contacts via the WebService API. Available on npm as @castaldosolutions/mcp-vtenext.

Generic Opendatasoft portal client (3000+ public OpenDataSoft instances)

Sourced greenhouse-gas emission factors and audit-traced carbon calculations (activity, embodied EN 15978, PCAF financed emissions) — every value returns with its exact source cell and data version, so answers are citable and reproducible. 13,000+ factors, 11 tools. Install: npx -y greencalculus-mcp, or connect remotely at https://mcp.greencalculus.com. Free tier, no card.

Full-featured Apache Superset MCP server with 135+ tools for dashboards, charts, datasets, SQL Lab, security (users, roles, RLS, groups), permissions audit, and 30+ built-in safety validations. Supports HTTP, SSE, and stdio transports.

Brussels Open Data (opendata.bruxelles.be) — OpenDataSoft MCP.

Allows you to automate or monitor business operations, sales recorder, POS software, CRM.

data.europa.eu — official EU open-data hub (~1.6M datasets)

Sonoma County Open Data (data.sonomacounty.ca.gov) Socrata MCP.

Norfolk Open Data (data.norfolk.gov) Socrata MCP.

Rennes Métropole Open Data (data.rennesmetropole.fr) — OpenDataSoft MCP.

Providence Open Data (data.providenceri.gov) Socrata MCP.

New Jersey Open Data (data.nj.gov) Socrata MCP.

Centre-Val de Loire Open Data (data.centrevaldeloire.fr) — OpenDataSoft MCP.

Pierce County Open Data (internal.open.piercecountywa.gov) Socrata MCP.

Nantes Métropole Open Data (data.nantesmetropole.fr) — OpenDataSoft MCP.

Fort Worth Open Data (data.fortworthtexas.gov) Socrata MCP.

Bloomington Open Data (data.bloomington.in.gov) Socrata MCP.

Fulton County Open Data (sharefulton.fultoncountyga.gov) Socrata MCP.

data.gov.ie MCP — Ireland's national open-data portal (CKAN API).

Oakland Open Data (data.oaklandca.gov) Socrata MCP.

Pennsylvania Open Data (data.pa.gov) Socrata MCP.

Nova Scotia Open Data (data.novascotia.ca) Socrata MCP.

datos.gov.co — Colombia's national open-data portal (Socrata platform).

Paris Open Data (opendata.paris.fr) — OpenDataSoft MCP.

data.gov.il MCP — Israel national open-data portal (CKAN API).

Connect to Databricks API, allowing LLMs to run SQL queries, list jobs, and get job status.

Santa Clara County Open Data (data.sccgov.org) Socrata MCP.

Réunion Open Data (data.regionreunion.com) — OpenDataSoft MCP.

China's apparel supply chain data for AI agents. 1,000+ verified suppliers, 350+ lab-tested fabrics, 170+ industrial clusters with AATCC / ISO / GB lab-test verification.

65+ MCP tools for business operations: ecommerce, finance, marketing, and analytics data through one streamable-HTTP endpoint. Built for operators.

dbt MCP — manifest/run_results/sources/catalog parsing + DQ result tables (BigQuery/Postgres)

Couchbase MCP server provides unfied access to both Capella cloud and self-managed clusters for document operations, SQL++ queries and natural language data analysis.

Comprehensive Kafka Schema Registry MCP server with 48 tools for multi-registry management, schema migration, and enterprise features.