Enterprise-grade MySQL MCP Server with OAuth 2.0 authentication, connection pooling & tool filtering – TypeScript Edition

A MySQL MCP Server that enables AI assistants (Claude, Cursor, etc.) to interact with MySQL databases through the Model Context Protocol with deterministic error handling. It provides 241 Specialized Tools, 22 resource categories (50 endpoints), and 19 AI-powered prompts for database operations, performance analysis, and administration.

• PNPM: pnpm add -g @neverinfamous/mysql-mcp (recommended)
• Docker: docker run -i --rm writenotenow/mysql-mcp:latest

• 241 MySQL Tools across 28 categories
• Deterministic Error Handling — structured {success, error, code, category, suggestion, recoverable} on every tool
• Adaptive Instruction Architecture — dynamic loading of help content based on active tool groups to ensure clients stay within token limits
• Resource Subscriptions — native MCP subscriptions (resources/subscribe) for real-time schema and status update notifications
• Progress Tracking — real-time progress notifications (notifications/progress) for long-running administrative operations (e.g., table checks, exports, Code Mode)
• Audit Trail & Token Logging — JSONL forensic logging with pre-mutation snapshots
• 22 resource categories (50 endpoints) for database observability
• 19 AI-Powered Prompts for guided workflows
• Native Sandbox Isolation — Code Mode executes in a native isolated-vm V8 instance with synchronous callbacks, enforced heap limits, and hard timeouts
• Token-Optimized Payloads — Tools with large responses offer optional summary, limit, and compact flags to reduce token usage
• Tool Filtering Shortcuts (starter, dev-power, dba-monitor, etc.)
• Connection Pooling via mysql2
• OAuth 2.0 enterprise authentication support
• Advanced Encryption (TLS/SSL, masking, compliance tools)
• Docker Deployment with multi-arch images

The mysql-mcp project is organized into modular directories under src/:

• src/adapters/ — Database driver adapters and the 241 tool implementations
• src/audit/ — JSONL forensic logging and token tracking
• src/auth/ — OAuth 2.0 authentication flow
• src/cli/ — CLI argument parsing and help output
• src/codemode/ — Isolated-vm sandbox execution and TS type injection
• src/constants/ — Static strings, error codes, and configuration defaults
• src/filtering/ — Meta-group tool shortcuts and filtering logic
• src/logging/ — Console logging utilities
• src/observability/ — MCP resources and prompts for database diagnostics
• src/pool/ — MySQL connection pool management
• src/progress/ — Real-time progress notifications for long-running tasks
• src/server/ — Core MCP server initialization and request handling
• src/transports/ — Stdio, HTTP, and SSE transport layers
• src/types/ — Shared TypeScript interfaces and Zod schemas
• src/utils/ — Helper functions and common utilities

• GitHub Repository
• Docker Hub
• Changelog
• Security Policy

Status: Production/Stable