Skip to main content
Glama

Database Tools for Claude AI

by elber-code
README.md2.52 kB
# Database Tools for Claude AI [![smithery badge](https://smithery.ai/badge/@elber-code/database-tools)](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?"

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/elber-code/database-tools'

If you have feedback or need assistance with the MCP directory API, please join our Discord server