Database Tools for Claude AI
[](https://smithery.ai/server/@elber-code/database-tools)
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](https://smithery.ai/server/@elber-code/database-tools):
To install and use this tool, follow these steps:
- **Clone or download the repository** ``` git clone [repository-url] ``` or download and extract the ZIP file.
- **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:
With the following structure:
Usage
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 table `name_table`."
- **Query the size of a table** "Execute query in MySQL to show me the size of the table `name_table`."
- **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?"