mysql-mcp-server

mysql-mcp-server

0

The MySQL MCP Server provides a secure interface for AI assistants to interact with MySQL databases by listing tables, reading data, and executing queries. It focuses on safe and structured database exploration with comprehensive logging and minimal permission requirements.

MySQL MCP Server

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases. Key features include:

  • Listing of available MySQL tables as resources
  • Reading table contents
  • Executing SQL queries with error handling
  • Secure database access using environment variables
  • Comprehensive logging

Security Considerations

  • Avoid committing environment variables or credentials
  • Use a database user with minimal permissions
  • Implement query whitelisting for production
  • Monitor and log all operations