Database Tools for Claude AI
This server enables Claude AI to interact directly with MySQL databases, allowing users to:
Execute SQL Queries: Run any valid SQL query directly from Claude
Retrieve Database Information: List all databases, view table structures, and get table sizes
Display Formatted Results: Present query results in a readable format
Operate with Security: Function within user-specified MySQL permissions for controlled access
Allows Claude to query MySQL databases directly, execute SQL queries, get information about tables (including size and structure), and receive formatted query results.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Database Tools for Claude AI show me the last 10 orders from the customers table"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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
Related MCP server: MariaDB MCP Server
Installation
Installing via Smithery
To install Database Tools for Claude Desktop automatically via Smithery:
npx -y @smithery/cli install @elber-code/database-tools --client claudeTo 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.jsonWith 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 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.jsare correctThat 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?"
Available Tools
1 toolmysqlC
Execute a query in MySQL
Inputs: query (required).
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 1 tool
With only one tool, there is no possibility of confusion or overlap between tools. The tool's purpose is clearly defined as executing MySQL queries, leaving no ambiguity for an agent to misselect among alternatives.
Since there is only one tool named 'mysql', it inherently follows a consistent pattern with itself. There are no other tools to compare against, so no inconsistencies in naming conventions can arise.
A single tool for a server named 'Database Tools for Claude AI' is too few for the apparent scope, which suggests broader database operations. This minimal set limits functionality and does not provide a comprehensive tool surface for database management tasks.
The tool surface is severely incomplete for a database tools server, as it only offers query execution without supporting essential operations like connection management, schema inspection, data manipulation beyond queries, or CRUD lifecycle coverage. This will likely cause agent failures in handling typical database workflows.
Maintenance
Related MCP Connectors
Hosted MySQL MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
MCP server giving Claude AI access to 22+ NYC public-record databases for real estate due diligence
Related MCP Servers
- AlicenseCqualityDmaintenanceAn MCP server that enables MySQL database integration with Claude. You can execute SQL queries and manage database connections.29MIT
- AlicenseNot gradedqualityDmaintenanceAn MCP server implementation that enables Claude to execute read-only queries against MariaDB databases and explore database schemas through natural language.20MIT
- AlicenseAqualityCmaintenanceMCP server for Claude that connects to MySQL, MariaDB, and SQLite databases. Query your databases using natural language.3132 PyPIMIT
- AlicenseBqualityCmaintenanceMCP server that connects AI agents to MySQL databases for schema exploration, data querying, and SQL execution via natural language.722 PyPI2MIT