Database Query MCP

Python Version License

[ English | 中文 ]

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

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

This server cannot be installed

security - not tested

license - permissive license

quality - not tested

How are these scores calculated?

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

A versatile tool that enables querying and exporting data from multiple relational databases (MySQL, PostgreSQL, Oracle, SQLite, etc.) in read-only mode for data safety.

Related MCP Servers

MySql MCP Server
sussa3007
A
security
A
license
A
quality
Connect and interact with MySQL databases seamlessly. Execute SQL queries, manage database connections, and retrieve data directly through AI assistants. Enhance your AI capabilities with structured access to your MySQL data.
Last updated -
9
14
3
TypeScript
MIT License
MySQL MCP
Liu-creators
-
security
F
license
-
quality
A tool that provides simple API to execute SQL queries and manage MySQL databases, designed to integrate with Cursor IDE for AI assistants to directly perform database operations.
Last updated -
Python
MCP PostgreSQL Server
Maxim2324
A
security
A
license
A
quality
A server that connects to PostgreSQL databases and provides tools for safely exploring schemas, running read-only SQL queries, and performing data analysis with pre-built templates.
Last updated -
5
690
1
JavaScript
MIT License
MariaDB MCP Server
bretoreta
-
security
F
license
-
quality
Provides secure, read-only access to MariaDB/MySQL databases, allowing users to list databases, explore table schemas, and execute SQL queries with built-in security measures.
Last updated -
JavaScript

View all related MCP servers

Appeared in Searches

Tools for Data Analysis

Database Query MCP

db-query-mcp

Introduction

Demo

Changelog

Installation

Configuration

Run using uvx

Run Using command

Related MCP Servers

MySql MCP Server

MySQL MCP

MCP PostgreSQL Server

MariaDB MCP Server

Appeared in Searches

New MCP Servers

MCP directory API