Production Safe Mysql Mcp Server

Created By

turkeryildirim25 days ago

A Model Context Protocol (MCP) server that gives AI agents direct access to MySQL databases even on production environments.

# mysql

# database

Overview Content Tools Comments

Overview

What It Can Do

Data Query & Mutation

execute_query — Run SELECT, INSERT, UPDATE, or DELETE statements with parameterized query support (? placeholders)
execute_transaction — Execute multiple statements as an atomic batch; if any statement fails the entire transaction is automatically rolled back

Schema Management

create_table — Create a new table
alter_table — Add/drop columns, rename columns, add indexes, and more
drop_table — Drop a table (requires ALLOW_DESTRUCTIVE_DDL=true)
show_tables — List all tables in a database
describe_table — Show column structure of a table

Database Management

list_databases — List all user databases (system databases excluded)
create_database — Create a new database with optional charset and collation
drop_database — Drop a database (requires ALLOW_DESTRUCTIVE_DDL=true)

Introspection

ping — Check MySQL connection health
show_columns — Show detailed column information for a table
get_server_info — Return MySQL version, character set, and collation (read-only)

Multi-Database Support

Every tool accepts a database parameter. You can query different databases within the same session without any extra configuration.

What It Cannot Do

The following operations are permanently blocked by the security filter and cannot be bypassed under any circumstances:

Category	Blocked Commands
MySQL settings	`SET GLOBAL`, `SET @@global.*`, `SET @@SESSION.sql_mode`
User management	`CREATE USER`, `DROP USER`, `ALTER USER`, `RENAME USER`
Privilege management	`GRANT`, `REVOKE`
System commands	`FLUSH`, `KILL`, `SHUTDOWN`
Replication	`RESET MASTER/REPLICA`, `START/STOP SLAVE/REPLICA`, `CHANGE MASTER`
File access	`LOAD DATA INFILE`, `SELECT INTO OUTFILE/DUMPFILE`
Plugins	`INSTALL PLUGIN`, `UNINSTALL PLUGIN`

Additional constraints:

Multiple statements separated by ; in a single call are not allowed — use execute_transaction instead
drop_table and drop_database are disabled by default and will return an error unless ALLOW_DESTRUCTIVE_DDL=true is set
Query results are capped at MAX_ROWS rows (default: 1000); add a LIMIT clause for large tables

Try in Playground

Server Config

{
  "mcpServers": {
    "mysql": {
      "command": "node",
      "args": [
        "/absolute/path/to/mysql-mcp/dist/index.js"
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "mcp_user",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "",
        "MAX_ROWS": "1000",
        "ALLOW_DESTRUCTIVE_DDL": "false"
      }
    }
  }
}

Project Info

Created At

25 days ago

Updated At

25 days ago

Author Name

turkeryildirim

Star

Language

License

Recommend Servers

View All

Feedjolt

@Feedjolt

Feedjolt's MCP server gives AI agents and MCP clients programmatic access to your feedback boards, posts, comments, roadmap, and changelog. Read feature requests, triage and tag feedback, change post statuses, merge duplicates, and publish changelog entries straight from any MCP-compatible client. Built for startups and indie teams who run their feedback loop where they build. Streamable-HTTP transport, API-key auth.

a day ago

LLMtoMD

@Gabriel Jacob

LLMtoMD turns your docs into clean, AI-ready Markdown and serves them to Cursor, Claude Code, and any MCP client so your coding agent retrieves your spec instead of forgetting it.

20 hours ago

a day ago

a day ago

MCP bridge that lets Claude Code delegate heavy tasks to the Antigravity CLI (agy) — purpose-built tools, model routing with fallback, session continuity, and output truncation to save Claude's context and tokens.

a day ago

Filesystem

Secure file operations with configurable access controls

a year ago

Spectra

@Jorge Sandoval

Generates high-quality unit tests for Python code with a coverage before/after report on every run. Derives concrete edge cases (None inputs, numeric boundaries, empty collections, exception paths) and returns ready-to-run pytest files with external I/O automatically mocked. Free tier: 100 executions. Pro: $19/month.

21 hours ago

Tavily Mcp

@tavily-ai

JavaScript

a year ago

GBOX Android MCP

@babelcloud

GBOX provides environments for AI Agents to operate computer and mobile devices. Mobile Scenario: Your agents can use GBOX to develop/test android apps, or run apps on the Android to complete various tasks(mobile automation). Desktop Scenario: Your agents can use GBOX to operate desktop apps such as browser, terminal, VSCode, etc(desktop automation). MCP: You can also plug GBOX MCP to any Agent you like, such as Cursor, Claude Code. These agents will instantly get the ability to operate computer and mobile devices.

10 months ago

Whats App Mcp Server

@meharajM

Human-in-the-loop approvals & notifications for AI agents via WhatsApp (MCP server)

a day ago

EdgeOne Pages MCP

@TencentEdgeOne

An MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.

TypeScript

a year ago

EQVPS — pay-per-use VPS for AI agents (MCP + REST)

@EQVPS

Crypto-paid no-KYC VPS that AI agents rent and operate end-to-end over MCP — list plans, fund a USDC/USDT balance, order a server, get root access. 16 tools, Streamable HTTP, root in ~60s. No card, no human at checkout. Humans can use it too.

a day ago

MCP Advisor

@istarwyh

MCP Advisor & Installation - Use the right MCP server for your needs

TypeScript

a year ago

Framelink Figma MCP Server

@GLips

MCP server to provide Figma layout information to AI coding agents like Cursor

TypeScript

a year ago

Liveauth Mcp Server

@dulzuradev

LiveAuth MCP Server gives AI agents cryptographic proof-of-work + Lightning Network authentication. Agents solve a PoW challenge, get a signed JWT, and use it to call paid MCP tools. Each tool call is metered in sats and recorded as a signed revenue event with a verifiable receipt. Built on L402 (the Lightning-Native HTTP 402 protocol from Lightning Labs). Compatible with x402 (Cloudflare/Coinbase). Non-custodial — no KYC, no account, no email. Pay per call in sats over Lightning. Install: `npx -y @liveauth-labs/mcp-server` Docs: https://docs.liveauth.app/mcp-liveauth-gate Source: https://github.com/dulzuradev/liveauth-mcp

17 hours ago

Aiimagemultistyle

@codecraftm

A Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.

a year ago

Unterm

@zhitongblog

The terminal AI agents can drive: a cross-platform desktop terminal (macOS/Linux/Windows, MIT) that runs a local MCP server. Spawn tabs/panes, run commands with structured output, read screens and full scrollback, take scrolling screenshots, record sessions with secret redaction, switch identity profiles. Auto-registers with Claude Code / Codex / Gemini CLI on install.

a day ago

PostgreSQL

@modelcontextprotocol

Read-only database access with schema inspection

a year ago

Sequential Thinking

@modelcontextprotocol

An MCP server implementation that provides a tool for dynamic and reflective problem-solving through a structured thinking process.

a year ago

302_sandbox_mcp

@302ai

Create a remote sandbox that can execute code/run commands/upload and download files. 创建远程沙盒，可以执行代码/运行命令/上传下载文件

a year ago

Primerfp Scout

@PrimeRFP

Remote govcon intelligence MCP for US federal + SLED contracting: semantic opportunity search, USASpending awards, recompete pipeline, congressional policy intel, GAO protests, capture/teaming, and 32 read-only tools. Streamable HTTP at https://mcp.primerfp.com/mcp.

15 hours ago

Achivx Forum

@ACHIVX

Agent-native forum for the x402/A2A ecosystem. The hosted MCP server exposes the whole forum as tools — threads, comments, votes, USDC bounties (x402 on Base), provider reviews, and search.

a day ago

Aws Kb Retrieval Server

@modelcontextprotocol

An MCP server implementation for retrieving information from the AWS Knowledge Base using the Bedrock Agent Runtime.

a year ago

Bucket Feature Flags MCP Server

@bucketco

Flag features directly from chat in your code editor, including VS Code, Cursor, Windsurf, Claude Code—any IDE with MCP support.

a year ago

Playwright Mcp

@microsoft

Playwright MCP server

TypeScript

10 months ago

Perplexity Ask MCP Server

@ppl-ai

A Model Context Protocol Server connector for Perplexity API, to enable web search without leaving the MCP ecosystem.

JavaScript

a year ago

Serper MCP Server

@garymengcom

A Serper MCP Server

Python

a year ago

Apex Copilot

@Apex-Foundation

Web3 founder diligence: contract audit, jurisdiction matching, fund discovery, portfolio comparison, scoring. Free, open source.

an hour ago

MCP Server for Milvus

@zilliztech

The Milvus MCP server enables AI applications to interact with Milvus vector databases using natural language commands. It allows AI models to perform vector searches, manage collections, and retrieve data without writing custom database queries. This integration facilitates seamless access to vector data, enhancing the capabilities of AI tools like Claude Desktop and Cursor.

a year ago

Amap Maps

@amap

高德地图官方 MCP Server

a year ago