Skip to main content
Glama
Database Tools for Claude AI

Database Tools for Claude AI

by elber-code

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

Available Tools

1 tool
mysqlC

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

    B3.1/5.0

    Scored across 1 tool

    Disambiguation5/5

    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.

    Naming Consistency5/5

    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.

    Tool Count2/5

    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.

    Completeness2/5

    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

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      An MCP server implementation that enables Claude to execute read-only queries against MariaDB databases and explore database schemas through natural language.
      20
      MIT
    • A
      license
      A
      quality
      C
      maintenance
      MCP server for Claude that connects to MySQL, MariaDB, and SQLite databases. Query your databases using natural language.
      3
      132 PyPI
      MIT
    • A
      license
      B
      quality
      C
      maintenance
      MCP server that connects AI agents to MySQL databases for schema exploration, data querying, and SQL execution via natural language.
      7
      22 PyPI
      2
      MIT