MCP Servers

mysql-mcp-zag

Enables SQL query execution and database structure browsing via MCP tools and resources.

README

MySQL MCP Server

A modern MySQL Model Context Protocol (MCP) server built with FastMCP.

Features

Execute SQL queries via MCP tools
Browse database tables and structure via MCP resources
SSL certificate support
Connection pooling and error handling

Configuration

Command Line Arguments

Required Arguments

Argument	Description	Default
`--user`	MySQL username	(required)
`--password`	MySQL password	(required)
`--database`	MySQL database name	(required)

Database Connection (Optional)

Argument	Description	Default
`--host`	MySQL server host	`localhost`
`--port`	MySQL server port	`3306`

SSL Configuration (Optional)

Argument	Description	Default
`--ssl-ca`	Path to SSL CA certificate file	(none - SSL auto-negotiated)
`--ssl-cert`	Path to SSL client certificate file	(none)
`--ssl-key`	Path to SSL client private key file	(none)
`--ssl-disabled`	Disable SSL connection entirely	`false`

Note: If --ssl-cert is provided, --ssl-key must also be provided, and vice versa.

Advanced Options (Optional)

Argument	Description	Default
`--charset`	Character set for the connection	`utf8mb4`
`--collation`	Collation for the connection	`utf8mb4_unicode_ci`
`--sql-mode`	MySQL SQL mode	`TRADITIONAL`

Usage

Simple Configuration

{
  "mcpServers": {
    "mysql": {
      "command": "uvx",
      "args": [
        "mysql-mcp-zag",
        "--host", "localhost",
        "--port", "3306",
        "--user", "your_user",
        "--password", "your_password",
        "--database", "your_database"
      ]
    }
  }
}

Complex Configuration

{
  "mcpServers": {
    "mysql": {
      "command": "uvx",
      "args": [
        "mysql-mcp-zag",
        "--host", "your-remote-host.com",
        "--port", "25060",
        "--user", "your_user",
        "--password", "your_password",
        "--database", "your_database",
        "--ssl-ca", "/path/to/ca-certificate.pem"
      ]
    }
  }
}

Available Tools

execute_sql: Execute SQL queries

Available Resources

mysql://tables: List all tables
mysql://tables/{table}: Describe table structure

Requirements

Python 3.13+
MySQL server
uvx (for installation and usage)

Created by Michael Zag, Michael@MichaelZag.com

Recommended Servers

playwright-mcp

A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.

Official

Featured

TypeScript

Magic Component Platform (MCP)

An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.

Audiense Insights MCP Server

Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.

VeyraX MCP

Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.

Official

Featured

Local

graphlit-mcp-server

The Model Context Protocol (MCP) Server enables integration between MCP clients and the Graphlit service. Ingest anything from Slack to Gmail to podcast feeds, in addition to web crawling, into a Graphlit project - and then retrieve relevant contents from the MCP client.

Official

Featured

TypeScript

Kagi MCP Server

An MCP server that integrates Kagi search capabilities with Claude AI, enabling Claude to perform real-time web searches when answering questions that require up-to-date information.

Official

Featured

Python

E2B

Using MCP to run code via e2b.

Official

Featured

Neon Database

MCP server for interacting with Neon Management API and databases

Official

Featured

Exa Search

A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.

Official

Featured

Qdrant Server

This repository is an example of how to create a MCP server for Qdrant, a vector search engine.

Official

Featured