{"type":"mcp_server","name":"mcp-mysql-server","description":"This repository provides a Model Context Protocol (MCP) server enabling AI models to interact with MySQL databases through a standardized interface for executing queries and managing data. This repository provides","category":"Database","language":"JavaScript","stars":163,"forks":10,"owner":"f4ww4z","github_url":"https://github.com/f4ww4z/mcp-mysql-server","homepage":null,"setup":"## Setup\n\n### Installing via Smithery\nTo install MySQL Server for Claude Desktop automatically via [Smithery](https://smithery.ai/server/@f4ww4z/mcp-mysql-server):\n\n```bash\nnpx -y @smithery/cli install @f4ww4z/mcp-mysql-server --client claude\n```\n\n### Manual Installation\n```bash\nnpx @f4ww4z/mcp-mysql-server\n```\n\nThe server requires the following environment variables to be set in your MCP settings configuration file:\n\n```json\n{\n  \"mcpServers\": {\n    \"mysql\": {\n      \"command\": \"npx\",\n      \"args\": [\"-y\", \"@f4ww4z/mcp-mysql-server\"],\n      \"env\": {\n        \"MYSQL_HOST\": \"your_host\",\n        \"MYSQL_USER\": \"your_user\",\n        \"MYSQL_PASSWORD\": \"your_password\",\n        \"MYSQL_DATABASE\": \"your_database\"\n      }\n    }\n  }\n}\n```","tools":"## Available Tools\n\n1. connect_db (Establish connection to MySQL database using provided credentials.)\n2. query (Execute SELECT queries with optional prepared statement parameters.)\n3. execute (Execute INSERT, UPDATE, or DELETE queries with optional prepared statement parameters.)\n4. list_tables (List all tables in the connected database.)\n5. describe_table (Get the structure of a specific table.)","faq":null,"created_at":"2024-12-13T09:39:28+00:00","updated_at":"2025-03-28T14:08:49+00:00","source_url":"https://model-context-protocol.com/servers/mcp-mysql-server-ai-model-interface","related_articles":[]}