MySQL-MCP-Server

MySQL-MCP-Server

3.2
databases

If you are the rightful owner of MySQL-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 an interface for AI models to interact with MySQL databases through natural language queries.

The MySQL MCP Server is a package that establishes a Model Context Protocol server to connect with a MySQL database, allowing AI models to execute SQL queries through natural language. This server acts as an intermediary, enabling AI models like Claude to interact with MySQL databases without needing direct access. It is designed to facilitate seamless communication between AI models and databases, translating natural language queries into SQL commands. The server requires Python 3.11 or above and a MySQL database. Installation can be done via pip or UV, and configuration is managed through environment variables such as DB_HOST, DB_USER, DB_PASSWORD, and DB_NAME. The server supports various usage options, including integration with Cursor, Python code, and manual execution.

Features

  • Natural Language Query Translation: Converts natural language queries into SQL commands.
  • Secure Database Interaction: Allows AI models to interact with databases without direct access.
  • Flexible Configuration: Supports environment variable configuration for database connection.
  • Multiple Usage Options: Can be used with Cursor, Python code, or run manually.
  • SQL Execution Tool: Provides a tool to execute SQL queries against the MySQL database.

Tools

  1. MySQL Connector

    Used to establish a connection to a MySQL database

  2. MCP Python SDK

    Provides implementation and server configuration support for MCP protocol

Related MCP Servers

View all databases servers →
mindsdb

mindsdb

4.5

by mindsdb

MindsDB is an open-source server that enables seamless interaction with large-scale federated data using the Model Context Protocol (MCP).

databases
mcp-notion-server

mcp-notion-server

4.3

by suekou

MCP Server for the Notion API, enabling LLM to interact with Notion workspaces. Additionally, it employs Markdown conversion to reduce context size when communicating with LLMs, optimizing token usage and making interactions more efficient.

databases
mcp-clickhouse

mcp-clickhouse

4.3

by ClickHouse

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

databases
prisma

prisma

4.1

by prisma

Prisma is a next-generation ORM for Node.js and TypeScript, providing tools for data modeling, migrations, and querying databases.

databases
gateway

gateway

4.0

by centralmind

CentralMind Gateway is a tool designed to expose databases to AI agents via MCP or OpenAPI protocols, providing secure, LLM-optimized APIs.

databases
azure-mcp

azure-mcp

3.8

by Azure

The Azure MCP Server implements the MCP specification to create a seamless connection between AI agents and Azure services.

cloud_platforms
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
mcp-kql-server

mcp-kql-server

3.7

by 4R9UN

A Model Context Protocol (MCP) server for executing Kusto Query Language (KQL) queries against Azure Data Explorer clusters.

databases
mcp-server-elasticsearch

mcp-server-elasticsearch

3.7

by elastic

This server connects agents to your Elasticsearch data using the Model Context Protocol, allowing interaction with Elasticsearch indices through natural language conversations.

databases
atlas-mcp-server

atlas-mcp-server

3.6

by cyanheads

ATLAS (Adaptive Task & Logic Automation System) is a project, knowledge, and task management system for LLM Agents, implemented as a Model Context Protocol (MCP) server.

developer_tools
mcp-server-motherduck

mcp-server-motherduck

3.6

by motherduckdb

An MCP server implementation that interacts with DuckDB and MotherDuck databases, providing SQL analytics capabilities to AI Assistants and IDEs.

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
xiyan_mcp_server

xiyan_mcp_server

3.6

by XGenerationLab

XiYan MCP Server is a Model Context Protocol server that enables natural language queries to databases, powered by XiYan-SQL, a state-of-the-art text-to-SQL model.

databases
mcp-server-weaviate

mcp-server-weaviate

3.6

by weaviate

Weaviate MCP Server is a protocol server designed to interact with the Weaviate vector database, providing functionalities for inserting and querying data.

databases
postg-mem

postg-mem

3.6

by dariogriffo

PostgMem is a .NET-based MCP server that provides vector memory storage using PostgreSQL and pgvector for AI applications.

databases
mcp-1panel

mcp-1panel

3.6

by 1Panel-dev

1Panel MCP Server is an implementation of the Model Context Protocol (MCP) server for 1Panel, providing a range of tools for system, website, certificate, application, and database management.

os_automation
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
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
elasticsearch-mcp-server

elasticsearch-mcp-server

3.6

by cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction. This server enables searching documents, analyzing indices, and managing cluster through a set of tools.

databases
supabase-mcp

supabase-mcp

3.6

by coleam00

A Model Context Protocol (MCP) server that provides tools for interacting with a Supabase database. This server enables AI assistants to perform database operations through a standardized interface.

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-server-bigquery

mcp-server-bigquery

3.6

by LucasHild

A Model Context Protocol server that provides access to BigQuery, enabling LLMs to inspect database schemas and execute queries.

databases
mcp-database-server

mcp-database-server

3.6

by executeautomation

The MCP Database Server provides database access capabilities to Claude, supporting SQLite, SQL Server, and PostgreSQL databases.

databases
postgres-mcp-server

postgres-mcp-server

3.6

by aadarshjain

A Model Context Protocol (MCP) server implementation for PostgreSQL database exploration and querying.

databases
MCPServerForMSSQL

MCPServerForMSSQL

3.6

by shakunvohradeltek

This repository contains the SQL Server MCP (Model Context Protocol) integration for Claude, allowing direct querying and analysis of SQL Server databases using natural language.

databases
mcp-snowflake-server

mcp-snowflake-server

3.6

by isaacwasserman

A Model Context Protocol (MCP) server implementation that provides database interaction with Snowflake.

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