Database Query MCP

Python Version License

[ 中文 | English ]

db-query-mcp

Introduction

db-query-mcp is an MCP tool that enables data querying and export operations across diverse databases, featuring:

Multi-Database Support: Full compatibility with mainstream relational databases (MySQL, PostgreSQL, Oracle, SQLite, etc.)
Secure Access: Default read-only mode connection ensures data safety
Smart Query: Provides efficient SQL generation and execution capabilities
Data Export: Supports query result export functionality
Future versions will expand support for Elasticsearch, MongoDB, and graph databases, aiming to become a full-stack database query solution.

Demo

https://github.com/user-attachments/assets/51d0e890-27b2-411d-b5c3-e748599a9543

Installation

pip install db-query-mcp

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

{
  "mcpServers": {
    "db_query_mcp": {
      "command": "db-query-mcp",
      "args": [
        "--db",
        "mysql+pymysql://user:password@host:port/database"
      ]
    }
  }
}

This server cannot be installed

security - not tested

license - permissive license

quality - not tested

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

PostgreSQL MCP Server
vinsidious
-
security
F
license
-
quality
Provides read-only access to PostgreSQL databases, enabling users to inspect database schemas and execute read-only queries through a Model Context Protocol server.
Last updated -
3
JavaScript
mcp-dbutils
donghao1393
-
security
A
license
-
quality
DButils is an all-in-one MCP service that enables your AI to do data analysis by accessing versatile types of database (sqlite, mysql, postgres, and more) within a unified connection configuration in a safe way.
Last updated -
69
Python
MIT License
PostgreSQL MCP Server
DanielRSnell
-
security
F
license
-
quality
Provides read-only access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute read-only SQL queries within a secure transaction context.
Last updated -
16,948
JavaScript
PostgreSQL MCP Server
hsinyuyen
-
security
F
license
-
quality
Provides read-only access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute read-only SQL queries.
Last updated -
16,948
JavaScript

View all related MCP servers

Database Query MCP

db-query-mcp

Introduction

Demo

Installation

Configuration

Related MCP Servers

PostgreSQL MCP Server

mcp-dbutils

PostgreSQL MCP Server

PostgreSQL MCP Server

New MCP Servers

MCP directory API