mysql-server-MCP-Server

mysql-server-MCP-Server

0

This project is a Model Context Protocol server designed for accessing MySQL databases. It is built with TypeScript and provides functionality for executing SQL queries by connecting to MySQL databases through environment variables.

mysql-server MCP Server

A Model Context Protocol server for MySQL database access

This is a TypeScript-based MCP server that provides tools for querying MySQL databases. It demonstrates core MCP concepts by providing:

  • Tools for executing SQL queries
  • Connection to MySQL databases via environment variables

Features

Tools

  • query - Execute SQL queries
    • Takes SQL query string as required parameter
    • Returns query results

Configuration

Set the following environment variables in your MCP server configuration:

  • MYSQL_HOST: MySQL server host
  • MYSQL_USER: MySQL username
  • MYSQL_PASSWORD: MySQL password
  • MYSQL_DATABASE: MySQL database name