DB Query

db-query-mcp is a mcp tool supporting diverse database querying and exporting, featuring:

- Multi-DB Support: Full compatibility with mainstream databases (ElasticSearch, MySQL, PostgreSQL, Oracle, SQLite, etc.)
- Secure Access: Default read-only mode for data protection
- Smart Query: Natural language to SQL conversion with query optimization
- Data Export: CSV / Json export capabilities
- Roadmap: Expanding support for MongoDB and GraphDatabase to become full-stack DB query MCP

https://github.com/user-attachments/assets/60771cda-8b52-41bd-90e3-523c836f6366

pip install "db-query-mcp[elasticsearch]"

pip install git+https://github.com/NewToolAI/db-query-mcp

PostgreSQL requires additional dependencies:

For other databases, install their respective connection packages:

Note: ​For certain clients, such as Cursor, only one db-query-mcp server can run at a time.​​

{ "mcpServers": { "sqlite_db_mcp": { "command": "uvx", "args": [ "db-query-mcp", "--db", "sqlite", "--uri", "sqlite:///sqlite_company.db" ] } } }

{ "mcpServers": { "es_db_mcp": { "command": "uvx", "args": [ "db-query-mcp", "--db", "elasticsearch", "--uri", "https://user:password@localhost:9200?index=test_data_index&ca_certs=/home/user/http_ca.crt" ] } } }

{ "mcpServers": { "sqlite_db_mcp": { "command": "db-query-mcp", "args": [ "--db", "sqlite", "--uri", "sqlite:///sqlite_company.db" ] } } }

{ "mcpServers": { "es_db_mcp": { "command": "db-query-mcp", "args": [ "--db", "elasticsearch", "--uri", "https://user:password@localhost:9200?index=test_data_index&ca_certs=/home/user/http_ca.crt" ] } } }

Unified MCP server giving AI coding agents direct access to your databases: 70+ SQL databases via SqlKit (PostgreSQL, MySQL, SQL Server, SQLite, ClickHouse, Snowflake, BigQuery) and NoSQL via DocKit (Elasticsearch, MongoDB, DynamoDB). Local-first: credentials never leave your machine, read-only by default, 79 tools.

Interact with an Elasticsearch cluster via the Model Context Protocol (MCP), enabling clients to query, manage, and analyze data.

Connect to and interact with an Elasticsearch cluster directly from any MCP client using environment variables for configuration.

Connects agents to Elasticsearch data, enabling natural language interaction with indices.

Manage Elasticsearch indices and execute queries using LLMs.

An MCP Server for interacting with Elasticsearch and OpenSearch clusters.

An MCP server for interacting with Elasticsearch clusters, enabling LLM-powered applications to search, update, and manage data.

A simple MCP server for Elasticsearch, designed for cloud environments where your public key is already authorized.

Search, Query and interact with data in your Milvus Vector Database.

A Python-based MCP server that connects to an Elasticsearch index with Apple HealthKit data.