Cover image
Try Now
2024-12-31

3 years

Works with Finder

1

Github Watches

0

Github Forks

0

Github Stars

MySQL MCP Server

A Model Context Protocol (MCP) server that provides MySQL database access functionality.

Features

  • List database tables and their schemas
  • Execute read-only SQL queries
  • Secure connection handling with connection pooling

Installation

  1. Clone this repository
  2. Install dependencies:
npm install
  1. Build the project:
npm run build

Configuration

Set the following 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
  • MYSQL_SOCKET: MySQL socket path (alternative to host/port)
  • MYSQL_POOL_LIMIT: Connection pool limit (default: 10)

Usage

The server will automatically start when the MCP system initializes it. You can then use the provided tools and resources through the MCP interface.

License

MIT

相关推荐

  • NiKole Maxwell
  • I craft unique cereal names, stories, and ridiculously cute Cereal Baby images.

  • Bora Yalcin
  • Evaluator for marketplace product descriptions, checks for relevancy and keyword stuffing.

  • Joshua Armstrong
  • Confidential guide on numerology and astrology, based of GG33 Public information

  • https://suefel.com
  • Latest advice and best practices for custom GPT development.

  • Callycode Limited
  • A geek-themed horoscope generator blending Bitcoin prices, tech jargon, and astrological whimsy.

  • Emmet Halm
  • Converts Figma frames into front-end code for various mobile frameworks.

  • Khalid kalib
  • Write professional emails

  • XLwebDev.com
  • PR Professional: Guiding You to Get Media Placements and Publicity Quickly and Effectively

  • Elijah Ng Shi Yi
  • Advanced software engineer GPT that excels through nailing the basics.

  • Beniyam Berhanu
  • Therapist adept at identifying core issues and offering practical advice with images.

  • apappascs
  • Discover the most comprehensive and up-to-date collection of MCP servers in the market. This repository serves as a centralized hub, offering an extensive catalog of open-source and proprietary MCP servers, complete with features, documentation links, and contributors.

  • ShrimpingIt
  • Micropython I2C-based manipulation of the MCP series GPIO expander, derived from Adafruit_MCP230xx

  • OffchainLabs
  • Go implementation of Ethereum proof of stake

  • huahuayu
  • A unified API gateway for integrating multiple etherscan-like blockchain explorer APIs with Model Context Protocol (MCP) support for AI assistants.

  • deemkeen
  • control your mbot2 with a power combo: mqtt+mcp+llm

    Reviews

    5 (1)
    Avatar
    user_oZx4EbqO
    2025-04-15

    README by yaxhpal is a fantastic application that has significantly improved my workflow efficiency. The ease of use and intuitive design make it accessible for all users, even those new to the platform. With its comprehensive features and user-friendly interface, it's an indispensable tool. Highly recommended!