github: https://github.com/NewToolAI/db-query-mcp

db-query-mcp

Introduction

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

Changelog

• 2025-06-02: Added support for ElasticSearch database queries

Installation

pip install db-query-mcp

ElasticSearch:

pip install db-query-mcp[elasticsearch]

Install from GitHub:

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

MySQL requires additional dependencies:

pip install pymysql

PostgreSQL requires additional dependencies:

pip install psycopg2-binary

For other databases, install their respective connection packages:

Configuration

{
  "mcpServers": {
    "sqlite_db_mcp": {
      "command": "db-query-mcp",
      "args": [
        "--db",
        "sqlite",
        "--uri",
        "sqlite:///sqlite_company.db",
      ]
    },
    "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",
      ]
    }
  }
}