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

Related MCP server: MariaDB MCP Server

Demo

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

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:

Database	Connection Package	Example Connection String
SQLite	Built-in Python	`sqlite:///example.db`
MySQL	`pymysql` or `mysql-connector-python`	`mysql+pymysql://user:password@localhost/dbname`
PostgreSQL	`psycopg2` or `psycopg2-binary`	`postgresql://user:password@localhost:5432/dbname`
Oracle	`cx_Oracle`	`oracle+cx_oracle://user:password@hostname:1521/sidname`
SQL Server	`pyodbc` or `pymssql`	`mssql+pyodbc://user:password@hostname/dbname`

Configuration

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

Run using uvx

{ "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" ] } } }

Run Using command

{ "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" ] } } }