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:

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:

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:

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

You must be authenticated.

security – no known vulnerabilities

license - not found

quality - confirmed to work

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

Tools

mysql

MCP server that allows Claude AI to interact directly with MySQL databases, enabling query execution and table information retrieval through natural language.

Related MCP Servers

Salesforce MCP Server
tsmztech
A
security
A
license
A
quality
An MCP server implementation that integrates Claude with Salesforce, enabling natural language interactions with Salesforce data and metadata for querying, modifying, and managing objects and records.
Last updated -
7
87
15
TypeScript
MIT License
Salesforce MCP Server
SurajAdsul
A
security
A
license
A
quality
An MCP server implementation that integrates Claude with Salesforce, enabling natural language interactions with Salesforce data and metadata for querying, modifying, and managing objects and records.
Last updated -
7
18
4
TypeScript
MIT License
SQL MCP Server for Claude Desktop
meanands
-
security
F
license
-
quality
A natural language interface that allows Claude to execute SQL queries on your local MySQL databases, enabling database interaction using natural language.
Last updated -
2
Python
mysqldb-mcp-server
burakdirin
-
security
A
license
-
quality
An MCP server that enables MySQL database integration with Claude. You can execute SQL queries and manage database connections.
Last updated -
1
Python
MIT License

View all related MCP servers

Database Tools for Claude AI