mysql-query-mcp-server

mysql-query-mcp-server

3.3
databases

If you are the rightful owner of mysql-query-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

A Model Context Protocol (MCP) server that provides read-only MySQL database queries for AI assistants.

The MySQL Query MCP Server is a specialized tool designed to facilitate read-only interactions with MySQL databases through AI assistants. It allows users to execute SELECT, SHOW, and DESCRIBE queries, providing a secure and efficient way to explore and investigate data without the risk of data modification. The server supports multiple predefined environments such as local, development, staging, and production, ensuring flexibility and adaptability to various deployment scenarios. With SSL support and query timeouts, it ensures secure and efficient database access. This tool is particularly useful for data exploration and analysis, making it an ideal choice for AI-driven applications that require database insights without the need for write operations.

Features

  • Read-Only Queries: Execute SELECT, SHOW, and DESCRIBE queries only, ensuring data integrity.
  • Predefined Environments: Supports local, development, staging, and production environments for flexible deployment.
  • SSL Connections: Provides secure database access through SSL connections.
  • Query Timeouts: Implements timeouts to prevent long-running operations.
  • Environment Listing: Lists all available database environments for easy management.

Tools

  1. query

    Execute read-only SQL queries against a specific environment.

  2. info

    Get detailed information about your database.

  3. environments

    List all configured environments from your configuration.

Related MCP Servers

View all databases servers →
mysql_mcp_server

mysql_mcp_server

4.5

by designcomputer

MySQL MCP Server is a Model Context Protocol implementation that facilitates secure interaction between AI applications and MySQL databases.

databases
dbhub

dbhub

4.4

by bytebase

DBHub is a universal database gateway implementing the Model Context Protocol (MCP) server interface.

databases
pg-mcp-server

pg-mcp-server

4.4

by stuzero

unknown

databases
mcp-server-neon

mcp-server-neon

4.3

by neondatabase-labs

Neon MCP Server is an open-source tool that enables natural language interaction with Neon Postgres databases.

databases
mysql_mcp_server_pro

mysql_mcp_server_pro

3.9

by wenb1n-dev

mcp_mysql_server_pro is a comprehensive MySQL server tool that extends beyond basic CRUD operations to include database anomaly analysis and custom tool extensions.

databases
postgres-mcp

postgres-mcp

3.8

by crystaldba

Postgres MCP Pro is an open-source Model Context Protocol server designed to enhance database performance and management through advanced tools and features.

databases
genai-toolbox

genai-toolbox

3.8

by googleapis

MCP Toolbox for Databases is an open source MCP server for databases, designed to simplify and secure the development of database tools.

databases
supabase-mcp

supabase-mcp

3.8

by supabase-community

Connect your Supabase projects to AI assistants using the Model Context Protocol (MCP) server.

databases
mcp-server-qdrant

mcp-server-qdrant

3.8

by qdrant

The mcp-server-qdrant is a Model Context Protocol server designed to integrate with the Qdrant vector search engine, providing a semantic memory layer for storing and retrieving information.

knowledge_and_memory
anyquery

anyquery

3.7

by julien040

Anyquery is a versatile SQL query engine that allows users to run SQL queries on various data sources, including files, databases, and applications, with support for LLMs and MySQL server functionality.

databases
mcp-server-mysql

mcp-server-mysql

3.7

by benborla

A Model Context Protocol server for MySQL databases using NodeJS, enabling LLMs to inspect schemas and execute SQL queries.

databases
supabase-mcp-server

supabase-mcp-server

3.7

by alexander-zuev

Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.

databases
mariadb-mcp-server

mariadb-mcp-server

3.7

by rjsalgado

This MCP server provides access to MariaDB / MySQL databases, allowing users to list databases, tables, describe table schemas, and execute SQL queries with security features.

databases
mcp-clickhouse

mcp-clickhouse

3.7

by ClickHouse

An MCP server for ClickHouse that allows executing SQL queries and managing databases and tables.

databases
chroma-mcp

chroma-mcp

3.7

by chroma-core

Chroma MCP Server is an open-source embedding database server that facilitates the integration of LLM applications with external data sources using the Model Context Protocol.

databases
mcp-server-milvus

mcp-server-milvus

3.6

by zilliztech

The MCP Server for Milvus enables seamless integration between LLM applications and the Milvus vector database, providing a standardized way to connect LLMs with the context they need.

databases
db-mcp-server

db-mcp-server

3.6

by FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

databases
mcp-google-sheets

mcp-google-sheets

3.6

by xing5

mcp-google-sheets is a Python-based MCP server that connects MCP-compatible clients to Google Sheets API for automation and data manipulation.

cloud_platforms
mcp-mongo-server

mcp-mongo-server

3.6

by kiliczsh

A Model Context Protocol server that enables LLMs to interact with MongoDB databases, providing capabilities for inspecting collection schemas and executing MongoDB operations through a standardized interface.

databases
airtable-mcp-server

airtable-mcp-server

3.6

by domdomegg

A Model Context Protocol server that provides read and write access to Airtable databases, enabling LLMs to inspect database schemas and manage records.

databases
mongodb-lens

mongodb-lens

3.6

by furey

MongoDB Lens is a local Model Context Protocol (MCP) server that provides full-featured access to MongoDB databases using natural language via LLMs.

databases
mcp-redis

mcp-redis

3.6

by redis

The Redis MCP Server is a natural language interface designed for agentic applications to efficiently manage and search data in Redis.

databases
firebase-mcp

firebase-mcp

3.6

by gannonh

Firebase MCP enables AI assistants to work directly with Firebase services, including Firestore, Storage, and Authentication.

databases
mcp-pinecone

mcp-pinecone

3.6

by sirmews

The Pinecone Model Context Protocol Server for Claude Desktop allows users to read and write to a Pinecone index, facilitating operations like semantic search and document processing.

databases
meilisearch-mcp

meilisearch-mcp

3.6

by meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces like Claude.

databases
mcp-mysql-server

mcp-mysql-server

3.6

by f4ww4z

A Model Context Protocol server that provides MySQL database operations, enabling AI models to interact with MySQL databases through a standardized interface.

databases
doris-mcp-server

doris-mcp-server

3.6

by apache

Doris MCP Server is a backend service built with Python and FastAPI, designed to connect to Apache Doris databases and potentially leverage LLMs for tasks like NL2SQL.

databases