Awesome MCPDatabases

opensearch-project/opensearch-mcp-server-py

⭐ 149 Python repository created 2025-05-14

opensearch-mcp-server-py is the OpenSearch project's official MCP server for its search and analytics engine. It gives an assistant a standard interface to a cluster: running search queries against indices, listing indices and retrieving their mappings so the model knows the field structure before querying, inspecting cluster and index state, and managing shards. Because mapping retrieval is a first-class tool, the normal pattern is discovery before querying — the model asks what fields exist and of what type, then composes a query that will actually match, rather than guessing at an index it has never seen. Two transports are supported: stdio for a local client such as Claude Desktop, and streaming over SSE or streamable HTTP for a server deployment where several clients or a remote agent connect over the network. The project also documents an agent memory feature, tying conversational state to OpenSearch itself. It is written in Python and lives in the opensearch-project GitHub organisation under the Apache 2.0 licence, which matters for adoption: it is maintained alongside the engine rather than by a third party, so tool coverage tracks OpenSearch releases. The audience is teams running OpenSearch for logs, observability or application search who want analysts to query it in natural language.

https://github.com/opensearch-project/opensearch-mcp-server-py

mcpopensearchsearchpythonanalyticselasticsearch-compatiblessecluster-management

Also in Databases

dolthub/dolt

Dolt is a SQL database with Git-like version control capabilities, enabling users to manage, version, and collaborate on data and schemas as easily as code in Git repositories.

t8y2/dbx

DBX is a lightweight, cross-platform database client supporting over 70 databases, featuring a built-in AI assistant, MCP Server, and available as desktop, Docker, or CLI.

Canner/WrenAI

Open-source generative BI engine that exposes governed text-to-SQL, a semantic layer and dashboard generation to AI agents through an MCP server and CLI across more than twenty data sources.

googleapis/mcp-toolbox

MCP Toolbox for Databases is an open-source Model Context Protocol (MCP) server that connects AI agents, IDEs, and applications directly to enterprise databases, offering both pre-built and custom ...

makenotion/notion-mcp-server

The Notion MCP Server is an official MCP server implementation that enables secure, programmatic interaction with Notion content through MCP commands, optimized for AI agents and supporting multiple deployment options.

bytebase/dbhub

DBHub is a universal database gateway implementing the Model Context Protocol (MCP) server interface, enabling MCP clients to connect to and explore multiple database systems including MySQL, PostgreSQL, Oracle, SQL Server, MariaDB, and SQLite.

crystaldba/postgres-mcp

Postgres MCP Pro is an open-source Model Context Protocol server for PostgreSQL that provides advanced database health monitoring, index tuning, query plan analysis, and safe SQL execution to support AI agents and developers throughout the application lifecycle.

supabase-community/supabase-mcp

Supabase MCP Server connects Supabase projects to AI assistants using the Model Context Protocol, enabling LLMs to manage and query Supabase resources.