Integrations
Allows Claude to query MySQL databases directly, execute SQL queries, get information about tables (including size and structure), and receive formatted query results.
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:
To install and use this tool, follow these steps:
- Clone or download the repositoryor download and extract the ZIP file.Copy
- Install dependencies
Navigate to the project directory and run:Copy
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 tablename_table
." - Query the size of a table
"Execute query in MySQL to show me the size of the tablename_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.
local-only server
The server can only run on the client's local machine because it depends on local resources.
Tools
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
- AsecurityAlicenseAqualityAn 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 -78715TypeScriptMIT License
- AsecurityAlicenseAqualityAn 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 -7184TypeScriptMIT License
- -securityFlicense-qualityA natural language interface that allows Claude to execute SQL queries on your local MySQL databases, enabling database interaction using natural language.Last updated -2Python
- -securityAlicense-qualityAn MCP server that enables MySQL database integration with Claude. You can execute SQL queries and manage database connections.Last updated -1PythonMIT License