Database Tools for Claude AI

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

Features

• 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

Installation

Installing via Smithery

To install Database Tools for Claude Desktop automatically via Smithery:

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

Configuration

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

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

With the following structure:

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

Usage

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

1. List all databases

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

2. View tables in a database

"Execute query in MySQL to show me the table `name_table`."

3. Query the size of a table

"Execute query in MySQL to show me the size of the table `name_table`."

4. Execute custom queries

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

Security

This tool runs with the permissions configured in the `mysql.js` file. Make sure the credentials provided have only the necessary permissions for the operations you want to allow.

Troubleshooting

If you have connection problems, check:

• That MySQL is running
• That the credentials in `mysql.js` are correct
• That the path in the Claude configuration file is correct

Implementation

To query databases, simply ask Claude something like:

"Show me all databases in my MySQL" or "What is the size of the users table?"