README.md•2.52 kB
# 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):
```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
```
## 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:
```json
C:\Users\YOUR_USER\AppData\Roaming\Claude\claude_desktop_config.json
```
With the following structure:
```json
{
"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?"