mcpField
D
Database Tools for Claude AI

Database Tools for Claude AI

Local
github.com/elber-codeDatabases4Updated 80w ago
Repository

About Database Tools for Claude AI

Database Tools for Claude AI is an MCP server that connects Claude to MySQL databases. It runs SQL queries, retrieves table information, and formats results for reading in Claude.

Key features

  1. 01Query MySQL through Claude
  2. 02Execute valid SQL queries
  3. 03Inspect table structure and size
  4. 04Format query results

Use cases

  1. 01List MySQL databases
  2. 02Check a table’s structure and size
  3. 03Retrieve data with custom SQL queries

MCP support

This MCP server lets Claude interact directly with MySQL, providing query execution, table information, and formatted results.

#mysql#mcp#node-js#claude#mcp-server

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

mcp.json · Universal config
{
  "mcpServers": {
    "database-tools": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli"
      ]
    }
  }
}
Run commandnpx -y @smithery/cli

Local servers need a runtime on your machine (e.g. Node.js 18+). Config file locations differ by client; see your client’s docs.

Packages
npm@smithery/cli

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

Database Tools for Claude AI

smithery badge

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:

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:

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

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.