Skip to main content
Glama

MySQL MCP Server

by vitalyDV
npmGitHub
JavaScript
491
3
OverviewInspectNewEndpointsSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

MySQL MCP Server

This project implements an MCP (Model Context Protocol) server for working with MySQL database.

Repository

This project is available on GitHub: https://github.com/vitalyDV/mysql-mcp

Clone the repository

git clone https://github.com/vitalyDV/mysql-mcp.git cd mysql-mcp npm install

add config to mcp.json

{ "mcpServers": { "mysql_mcp_readonly": { "command": "node", "args": [ "./mysql-mcp/index.js" ], "env": { "MYSQL_HOST": "127.0.0.1", "MYSQL_PORT": "3306", "MYSQL_USER": "root", "MYSQL_PASS": "", "MYSQL_DB": "db", } } } }

Environment Variables

  • MYSQL_HOST - MySQL server host
  • MYSQL_PORT - MySQL server port
  • MYSQL_USER - MySQL username
  • MYSQL_PASS - MySQL password
  • MYSQL_DB - MySQL database name

Available MCP tools

  • query - execute SQL queries (only SELECT, SHOW, EXPLAIN, DESCRIBE)
  • table-schema - get table structure
  • list-tables - get list of all tables in the database

Available MCP resources

  • table://{name} - get data from the specified table (up to 100 rows)

This server cannot be installed

-
security - not tested
F
license - not found
-
quality - not tested

How are these scores calculated?

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

An MCP server that allows working with MySQL databases by providing tools for executing read-only SQL queries, getting table schemas, and listing database tables.

  1. Repository
    1. Clone the repository
  2. add config to mcp.json
    1. Environment Variables
      1. Available MCP tools
        1. Available MCP resources

          Related MCP Servers

          • MySQL MCP Server

            kevinwatt
            -
            security
            A
            license
            -
            quality
            An MCP server that integrates with MySQL databases, enabling secure read and write operations through LLM-driven interfaces with support for transaction handling and performance monitoring.
            Last updated -
            130
            16
            MIT License

          • MySQL Database Access

            dpflucas
            A
            security
            A
            license
            A
            quality
            An MCP server that provides read-only access to MySQL databases.
            Last updated -
            4
            235
            43
            MIT License
            • Linux
            • Apple

          • Python MySQL MCP

            hoonzinope
            -
            security
            F
            license
            -
            quality
            A FastMCP-based server that enables interaction with MySQL databases, supporting client-server communication for querying and analyzing MySQL data.
            Last updated -

          • MSSQL MCP Server

            ralacher
            -
            security
            A
            license
            -
            quality
            An MCP server that enables connection to Microsoft SQL Server databases, providing tools for schema inspection and querying through standardized interfaces.
            Last updated -
            MIT License

          View all related MCP servers

          Appeared in Searches

          New MCP Servers

          MCP directory API

          We provide all the information about MCP servers via our MCP API.

          curl -X GET 'https://glama.ai/api/mcp/v1/servers/vitalyDV/mysql-mcp'

          If you have feedback or need assistance with the MCP directory API, please join our Discord server