"Open Collective" matching MCP servers:

Enables agents to discover, inspect, and query municipal open datasets from data.seattle.gov through Socrata SODA2, with bounded reads, aggregates, and reference guidance.

An MCP server that lets an LLM query a DuckDB warehouse of EuroLeague and EuroCup basketball data in natural language, offering tools for player and team stats, shot charts, boxscores, and fantasy draft analysis without contacting upstream APIs.

Enables AI clients to search and read over 2,400 New York City public datasets through the Socrata SODA API, with ready-made tools for restaurant health inspections and 311 service requests plus general dataset discovery and querying.

Enables answering questions about Ukrainian open data from the data.gov.ua CKAN portal by searching datasets, inspecting resource schemas, and running read-only SQL aggregates over a single tabular resource. Every data-backed answer is computed from retrieved data and returned with machine-readable provenance, and unsupported or unanswerable requests are refused rather than guessed.

AI-native ontology engineering MCP server for OWL/RDF/SPARQL. Validate, query, diff, lint, version, and govern knowledge graphs via Oxigraph triple store.

An open-source Model Context Protocol application management platform that allows users to create applications from GitHub repositories with automatic information extraction and database integration.

A multi-database MCP server that enables LLM agents to safely access MySQL, Oracle, DM, PostgreSQL, and SQLite databases with security features like whitelist, row count pre-check, and audit logging.

MCP server to query public open data from Recife, Brazil using natural language. It exposes tools for schema exploration and SQL query generation via Gemini 2.5 Flash, backed by a local DuckDB database.

Connects AI coding assistants like Claude Code, Cursor, and Windsurf to enterprise data sources (databases, files, APIs, etc.) via a single binary, with 45+ connector categories and built-in memory tools.

This MCP server provides a read-only tool to find products without entitlement records using deterministic mock data, supporting publisher filtering and result limits. It is a pilot scaffold for Open iT and ServiceNow SAM Pro integration.

Lets an agent query JSON files too large for its context: JSONPath with aggregation pipes, schema, field profiles, samples, identity-keyed diff, CSV and spreadsheet export, and checks that gate a file. Int64 IDs and decimals keep their exact digits, and zstd, Base64-Zstd and PostgreSQL bytea payloads open directly.

Model Context Protocol (MCP) server providing access to 155 normalized Japanese public open datasets (10.16M+ records) including GEPS procurement, healthcare, land prices, and DuckDB SQL.

Check 22,000+ devices with open firmware or open protocols (OpenWrt, LineageOS, coreboot, Zigbee2MQTT, Tasmota…) before reverse engineering one; claim a device while you work on it and publish your findings when done.

Enables users to answer California drinking water questions about public water systems, SAFER risk/violation status, source-water chemistry, school lead sampling, and latest tap/treated-water results by ZIP code or water system ID, using curated Databricks Gold views over State Water Board open data.

An MCP server for Oracle that won't get you fired... This MCP server does not expose a SQL prompt, and can't tell you how to log into Oracle. Only the selected objects and SQL statements are usable.

Enables read-only FHIR access to Practice Fusion EHR to search patients, appointments, conditions, medications, and lab results.

Enables AI assistants to query a garage workshop database for live information on open jobs, vehicle history, parts availability, and bookings, and to append notes to job cards.

Open-source MCP server for MetricBridge (formerly Health Export AI). 16 tools and 22 prompts let any MCP agent query 190 Apple Health metrics from files on your own machine. The server is read-only, has zero dependencies and makes zero network calls.

Enables an LLM to answer questions about Colombian public procurement from the SECOP II electronic contracts open dataset on datos.gov.co, with typed queries that are built into SoQL by the server. A column allowlist and local entity directory keep personal-data fields unreachable and resolve institution names to NITs, so users get aggregate contract figures without writing queries themselves.

Enables an AI client to search Australian federal and South Australian government open data catalogues, inspect a dataset file's schema and sample rows, then run read-only SQL over the full file in a sandboxed DuckDB. Every answer carries the source URL, publisher and licence, with extra tools for ABN checksum validation and Australian financial-year dates.

Enables users to ask natural-language questions about their spending, transactions, and connected bank accounts or cards by aggregating read-only Pluggy Open Finance data across multiple itemIds. It exposes schema and SELECT-only query tools over accounts and transactions without moving money or modifying data.

Read-only-by-default MCP server for Datanika, an open-source dlt + dbt-core data pipeline platform: browse connections, introspect and preview source tables, compile and run dbt transformations, and monitor pipeline runs. 25 tools (17 read-only, plus 8 write tools gated behind --allow-write); source lives in the datanika-mcp/ subdirectory of the repo.

Open Ephemeris is a high-precision astrology API with an MCP server exposing 116+ endpoints across natal charts, transits, synastry, Human Design, BaZi, solar returns, and much more.

Postgres Pro is an open source Model Context Protocol (MCP) server built to support you and your AI agents throughout the entire development process—from initial coding, through testing and deployment, and to production tuning and maintenance.

MCP server for accessing Uruguay's IMPO open data API with SQLite caching. Provides tools to retrieve legal norms, search regulations, and access schema documentation from Uruguay's official legal database.

An open-source MCP server that connects to various data sources (SQL databases, CSV, Parquet files), allowing AI models to execute SQL queries and generate data visualizations for analytics and business intelligence.

Apple HealthKit → PostgreSQL sync + MCP server for Claude Code, Cursor, and Ollama. Open-source iOS app with reliable background sync (HKObserverQuery). 11 tools covering health summary, sleep, HRV trends, workouts, daily snapshots, metric stats, period comparison, and coaching briefs. Supports Supabase, Neon, and self-hosted Postgres. Privacy-first: your data goes to your own database.

Enables an AI assistant to manage personal tasks in SQLite, answer questions from a local SQLite database through bounded read-only queries, and retrieve weather forecasts from Open-Meteo.

A Node.js implementation that provides tools for advanced PubMed searching, including full abstract retrieval and PMC full-text search within open access articles. It features SQLite-backed search history and allows users to filter results by MeSH terms and specific publication dates.

Enables an AI agent to run 1C queries, evaluate expressions, execute BSL code, and inspect configuration metadata inside a user's open 1C session, exchanging commands and results through a folder in the user's profile without any intermediate gateway. Results can be gated by user confirmation on the 1C form, and write operations are rolled back unless explicitly permitted.