What is Database Tools

database-tools is an MCP server designed to facilitate interaction between Claude AI and MySQL databases, allowing users to execute SQL queries and retrieve database information seamlessly.

Use cases

Use cases for database-tools include listing all databases, viewing tables within a specific database, querying the size of a table, and executing custom SQL queries based on user requirements.

How to use

To use database-tools, clone the repository, install the necessary dependencies, and configure the ‘claude_desktop_config.json’ file to include the database-tools settings. After configuration, you can issue commands to interact with MySQL databases directly from Claude.

Key features

Key features include the ability to query MySQL databases, execute any valid SQL query, retrieve information about tables (such as size and structure), and receive formatted results for easier reading.

Where to use

database-tools can be used in various fields such as data analysis, application development, and database management, where interaction with MySQL databases is required.

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:

With the following structure:

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?”