MySQL Database Tools

by elber-code

3 stars

367 downloads

Not rated

GitHub

About

Enables direct SQL query execution and table exploration with MySQL databases through a simple interface for seamless data analysis and database operations.

Details

Author: elber-code
Repository: elber-code/database-tools
GitHub stars: 3
Downloads: 367
Categories: Database, Other, AI, Design, Developer Tools, Search, Infrastructure, Knowledge Base

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below
Plugin Name MySQL Database Tools

Command (node, npx, python, etc.) node
Arguments
- Argument 1 C:\path\to\index.js
Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "mysql database tools": {
            "cwd": "string (optional)",
            "env": {},
            "args": [
                "C:\\path\\to\\index.js"
            ],
            "shell": false,
            "command": "node"
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql database tools": {
            "cwd": "string (optional)",
            "env": {},
            "args": [
                "C:\\path\\to\\index.js"
            ],
            "shell": false,
            "command": "node"
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql database tools": {
            "cwd": "string (optional)",
            "env": {},
            "args": [
                "C:\\path\\to\\index.js"
            ],
            "shell": false,
            "command": "node"
        }
    }
}

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

{
    "mcpServers": {
        "mysql database tools": {
            "cwd": "string (optional)",
            "env": {},
            "args": [
                "C:\\path\\to\\index.js"
            ],
            "shell": false,
            "command": "node"
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql database tools": {
            "cwd": "string (optional)",
            "env": {},
            "args": [
                "C:\\path\\to\\index.js"
            ],
            "shell": false,
            "command": "node"
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql database tools": {
            "cwd": "string (optional)",
            "env": {},
            "args": [
                "C:\\path\\to\\index.js"
            ],
            "shell": false,
            "command": "node"
        }
    }
}

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "mysql database tools": {
            "cwd": "string (optional)",
            "env": {},
            "args": [
                "C:\\path\\to\\index.js"
            ],
            "shell": false,
            "command": "node"
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql database tools": {
            "cwd": "string (optional)",
            "env": {},
            "args": [
                "C:\\path\\to\\index.js"
            ],
            "shell": false,
            "command": "node"
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql database tools": {
            "cwd": "string (optional)",
            "env": {},
            "args": [
                "C:\\path\\to\\index.js"
            ],
            "shell": false,
            "command": "node"
        }
    }
}

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

{
    "mcpServers": {
        "mysql database tools": {
            "cwd": "string (optional)",
            "env": {},
            "args": [
                "C:\\path\\to\\index.js"
            ],
            "shell": false,
            "command": "node"
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql database tools": {
            "cwd": "string (optional)",
            "env": {},
            "args": [
                "C:\\path\\to\\index.js"
            ],
            "shell": false,
            "command": "node"
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql database tools": {
            "cwd": "string (optional)",
            "env": {},
            "args": [
                "C:\\path\\to\\index.js"
            ],
            "shell": false,
            "command": "node"
        }
    }
}

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "mysql database tools": {
            "cwd": "string (optional)",
            "env": {},
            "args": [
                "C:\\path\\to\\index.js"
            ],
            "shell": false,
            "command": "node"
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql database tools": {
            "cwd": "string (optional)",
            "env": {},
            "args": [
                "C:\\path\\to\\index.js"
            ],
            "shell": false,
            "command": "node"
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql database tools": {
            "cwd": "string (optional)",
            "env": {},
            "args": [
                "C:\\path\\to\\index.js"
            ],
            "shell": false,
            "command": "node"
        }
    }
}

From the repository

For Claude to use this tool, you need to add the configuration to your claude_desktop_config.json file, which is typically located at:

To install Database Tools for Claude Desktop automatically via Smithery:

bash
npx -y @smithery/cli install @elber-code/database-tools --client claude

To install and use this tool, follow these steps:

1. Clone or download the repository

git clone [repository-url]

or download and extract the ZIP file.

2. Install dependencies Navigate to the project directory and run:

npm install
```

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "mysql database tools": {
            "cwd": "string (optional)",
            "env": {},
            "args": [
                "C:\\path\\to\\index.js"
            ],
            "shell": false,
            "command": "node"
        }
    }
}

Linux

{
    "cwd": "string (optional)",
    "env": [],
    "args": [
        "C:\\path\\to\\index.js"
    ],
    "shell": false,
    "command": "node"
}

Macos

{
    "cwd": "string (optional)",
    "env": [],
    "args": [
        "C:\\path\\to\\index.js"
    ],
    "shell": false,
    "command": "node"
}

Windows

{
    "cwd": "string (optional)",
    "env": [],
    "args": [
        "C:\\path\\to\\index.js"
    ],
    "shell": false,
    "command": "node"
}

Allows Claude AI to interact directly with MySQL databases.

This is an MCP (Model Context Protocol) server that allows Claude AI to interact directly with MySQL databases.

- Query MySQL databases through Claude
- Execute any valid SQL query
- Get information about tables, including size and structure
- Formatted results for easy reading in Claude

To install Database Tools for Claude Desktop automatically viaSmithery:

npx -y @smithery/cli install @elber-code/database-tools --client claude

To install and use this tool, follow these steps:

Install dependenciesNavigate to the project directory and run:

For Claude to use this tool, you need to add the configuration to yourclaude_desktop_config.jsonfile, which is typically located at:

C:\Users\YOUR_USER\AppData\Roaming\Claude\claude_desktop_config.json

{ "mcpServers": { // Other existing configurations... "database-tools": { "command": "node", "args": [ "C:\\path\\to\\index.js" ] } } }

Once configured, you can interact with your MySQL databases from Claude with commands like:
-

List all databases
"Execute query in MySQL to show me the databases."

View tables in a database
"Execute query in MySQL to show me the tablename_table."

Query the size of a table
"Execute query in MySQL to show me the size of the tablename_table."

Execute custom queries
"Execute query in MySQL: 'The description of what you want your query to do.'"

This tool runs with the permissions configured in themysql.jsfile. Make sure the credentials provided have only the necessary permissions for the operations you want to allow.

- That MySQL is running
- That the credentials inmysql.jsare correct
- That the path in the Claude configuration file is correct

To query databases, simply ask Claude something like: "Show me all databases in my MySQL" or "What is the size of the users table?"

Multi-database agent access (PostgreSQL, SQLite, MySQL, Oracle, SQL Server) with batch queries, pre-configured connections, and SQLGlot-enforced read-only safety

A read-only MCP server for MySQL, enabling LLMs to query live data using the CData JDBC Driver.

Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite

A single-binary MCP server for MySQL, MariaDB, PostgreSQL, and SQLite

A Model Context Protocol (MCP) server that provides multi-database query execution capabilities with support for SQLite, PostgreSQL, and MySQL databases. Includes a built-in Web UI for managing database connections.

Update various databases (PostgreSQL, MySQL, MongoDB, SQLite) using data from CSV and Excel files.

Enables AI assistants to interact with various databases through JDBC connections.

An MCP server for retrieving data from a MariaDB database.

Access and manage MariaDB or MySQL databases using an MCP server.

Provides access to MariaDB and MySQL databases for querying and data manipulation.

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

About

Details

Jump to

Setting up with Highlight

From the repository

Claude Desktop / Cursor

Linux

Macos

Windows

Install

More like this

Sequential Thinking

Redis

Filesystem

EverArt

Google Drive

Sqlite