convez.ai
MCP ServerIntegração & APIsIntermediário
dave-wind

MySQL MCP Server

dave-wind/mysql-mcp-server

Acesso seguro e somente leitura a MySQL para LLMs via MCP

Ver no GitHub
BomPluginScore · de 0 a 100

Servidor Model Context Protocol que fornece acesso somente leitura a bancos de dados MySQL, permitindo que LLMs inspecionem esquemas e executem consultas SELECT. Implementa validação SQL rigorosa e transações READ ONLY para segurança garantida.

Instalação

$npx convez-ai dave-wind/mysql-mcp-server

1 comando no terminal: detecta o formato do repositório (marketplace ou plugin avulso) e instala via Claude Code. Requer Node 18+ e o Claude Code instalado.

Métricas

Estrelas
16
Forks
7
Acompanhando
1
Saúde
42%
Último commit
há 6 meses
Versão
—
Issues abertas
3
Contribuidores
3

Casos de uso

  • Integrar LLMs com bancos de dados MySQL existentes para consultas de dados
  • Permitir que agentes IA explorem estruturas de banco de dados automaticamente
  • Construir aplicações n8n com capacidade de leitura de dados MySQL segura

Veredito

Solução prática e bem arquitetada para conectar LLMs a MySQL com segurança rigorosa. Recomendado para quem precisa expor dados de banco de dados a agentes IA sem risco de modificação.

README

A tradução para o português deste README ainda está na fila.

@davewind/mysql-mcp-server

Trust Score

A Model Context Protocol server that provides read-only access to Mysql databases. This server enables LLMs to inspect database schemas and execute read-only queries.

Key Features

1.Read-Only Database Access: Enforces read-only operations through SQL validation and READ ONLY transactions
2.Schema Discovery: Automatically identifies and exposes database table structures
3.SQL Query Execution: Provides a query tool that accepts and executes SELECT statements
4.Model Context Protocol Compliance: Implements the MCP specification for seamless integration with compatible LLMs
5.Simple Configuration: Easy setup with minimal configuration required

Tools

  • query
    • Execute read-only SQL queries against the connected database
    • Input: sql (string): The SQL query to execute
    • All queries are executed within a READ ONLY transaction

Resources

The server provides schema information for each table in the database:

  • Table Schemas (mysql://user:password@localhost:3306/database)
    • JSON schema information for each table
    • Includes column names and data types
    • Automatically discovered from database metadata

Install

npm install @davewind/mysql-mcp-server -g

Configuration

MCP settings configuration file:

recommended use

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["-y", "@davewind/mysql-mcp-server", "mysql://user:password@localhost:port/database"],
    }
  }
}

Test

Replace mysql://user:password@localhost:port/ and npm run inspector

  "scripts": {
    "inspector": "npx @modelcontextprotocol/inspector@0.10.2 build/index.js mysql://user:password@localhost:port/database
  }

Env


node v18 +

System Architecture

The MySQL MCP Server acts as an intermediary between LLMs and MySQL databases, processing requests according to the Model Context Protocol.

Component Interaction

Component Interaction

Security Model

The MySQL MCP Server implements a strict security model to ensure that database access is read-only.

Security measures include:

1.SQL query validation to allow only SELECT statements 2.Execution of all queries within READ ONLY transactions 3.No support for data modification operations (INSERT, UPDATE, DELETE, etc.) 4. No support for database schema modification (CREATE, ALTER, DROP, etc.)

Integration with LLMs

The MySQL MCP Server is designed to work with any LLM system that supports the Model Context Protocol. It communicates through JSON-RPC over stdio, following the MCP specification.

License

MIT

Ver o original no GitHub

Bom para

Relacionados