{"repo":"dpflucas/mysql-mcp-server","free":true,"listed":false,"github":"https://github.com/dpflucas/mysql-mcp-server","clone":"git clone https://github.com/dpflucas/mysql-mcp-server.git","description":"An MCP server provides read-only access to MySQL databases.","language":"JavaScript","stars":70,"topics":[],"license":"MIT","category":"mcp-servers","readme_excerpt":"MySQL Database Access MCP Server This MCP server provides read-only access to MySQL databases. It allows you to: - List available databases - List tables in a database - Describe table schemas - Execute read-only SQL queries Security Features - Read-only access : Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are allowed - Query validation : Prevents SQL injection and blocks any data modification attempts - Query timeout : Prevents long-running queries from consuming resources - Row limit : Prevents excessive data return Installation 1. Install using one of these methods: Install from NPM Build from Source Install via Smithery To install MySQL Database Access MCP Server for Claude AI automatically via Smithery: 2. Configure environment variables The server requires the following environment variables: - MYSQL HOST : Database server hostname - MYSQL PORT : Database server port (default: 3306) - MYSQL USER : Database username - MYSQL PASSWORD : Database password (optional, but recommended for secure connections) - MYSQL DATABASE : Default database name (optional) 3. Add to MCP settings Add the following configuration to your MCP settings file: If you installed via npm (Option 1): If you built from source (Option 2): Available Tools list databases Lists all accessible databases on the MySQL server. Parameters : None Example : list tables Lists all tables in a specified database. Parameters : - database (optional): Database name (uses default if not specified) Example : desc","default_branch":null,"files":null,"tree":[],"storefront":"/r/dpflucas","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/dpflucas/mysql-mcp-server/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}