Awesome MCPDatabases

elastic/mcp-server-elasticsearch

⭐ 713 JavaScript added to this list on 2025-04-09 repository created 2025-03-24

The Elasticsearch MCP Server is an experimental project designed to connect Elasticsearch data to MCP Clients using the Model Context Protocol (MCP). This server enables natural language interaction with Elasticsearch indices and search capabilities, allowing users to query and manage their Elasticsearch data through conversational interfaces. It supports various operations such as listing all available Elasticsearch indices, retrieving field mappings for specific indices, performing searches with advanced query DSL features including highlighting, query profiling, and explanation, and obtaining shard information for indices. The project is intended for research and evaluation purposes and is not production-ready. It requires an Elasticsearch instance with proper authentication credentials, which can be provided via API key or username/password. The server can be run using Docker or as a published NPM package, and it integrates seamlessly with MCP Clients like Claude Desktop. Users configure their MCP Client to connect to the Elasticsearch MCP Server by specifying the server command and environment variables such as the Elasticsearch URL and authentication credentials. The server supports various configuration options including SSL/TLS settings, path prefixes, and version targeting to accommodate different Elasticsearch deployments. For developers, the project offers local development setup instructions, including dependency installation, building, and debugging with an MCP Inspector tool. Security best practices are emphasized, recommending the use of dedicated API keys with limited privileges and fine-grained access control to protect data. The project also provides example natural language queries to demonstrate its capabilities, such as listing indices, showing field mappings, and searching for specific data within Elasticsearch. Overall, the Elasticsearch MCP Server bridges the gap between Elasticsearch's powerful search capabilities and user-friendly natural language interfaces, leveraging the Model Context Protocol to facilitate intuitive data exploration and management.

https://github.com/elastic/mcp-server-elasticsearch

access-controlapi-keyapi-key-permissionsauthenticationclaude-desktopconversational-interfacedata-access-controldata-interactiondebuggingdevelopmentdockerelasticsearchelasticsearch-indicesexperimentalfield-mappingshighlightingindicesmcpmcp-clientmcp-clientsmcp-inspectormcp-servermodel-context-protocolnatural-language-interactionnpm-packagequery-dslquery-explanationquery-profilingresearchsearchsearch-capabilitiessearch-queriessecurityshard-informationssl/tlsvector-database

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.