mcp-mysql-server

mcp-mysql-server

0
databases

The '@f4ww4z/mcp-mysql-server' is a Model Context Protocol server that facilitates the interaction of AI models with MySQL databases through a standardized interface. It features secure connection handling, prepared statement support, and comprehensive error management.

@f4ww4z/mcp-mysql-server

A Model Context Protocol server designed for MySQL database operations, enabling AI models to interact with MySQL databases through a standardized interface.

Installation

Installing via Smithery

Install automatically using Smithery.

Manual Installation

Install manually via npx.

Configuration

Requires specific environment variables for MySQL connection.

Available Tools

  • connect_db: Establish a connection to a MySQL database.
  • query: Execute SELECT queries with prepared statement parameters.
  • execute: Perform INSERT, UPDATE, or DELETE queries with parameters.
  • list_tables: List tables in the database.
  • describe_table: Get table structure.

Features

  • Secure connection handling
  • Prepared statement support
  • Comprehensive error handling
  • TypeScript support

Security

  • Prevents SQL injection
  • Secure password handling

Error Handling

Detailed error messages for connection failures, invalid queries, missing parameters, and database errors.

Contributing

Contributions are welcome via GitHub.

License

MIT