Skip to main content
Glama
Database Tools for Claude AI

Database Tools for Claude AI

by elber-code

Claude AI 的数据库工具

铁匠徽章

这是一个 MCP(模型上下文协议)服务器,允许 Claude AI 直接与 MySQL 数据库交互。

特征

  • 通过 Claude 查询 MySQL 数据库

  • 执行任何有效的 SQL 查询

  • 获取有关表的信息,包括大小和结构

  • 格式化结果以便于在 Claude 中阅读

Related MCP server: MariaDB MCP Server

安装

通过 Smithery 安装

要通过Smithery自动安装 Claude Desktop 的数据库工具:

npx -y @smithery/cli install @elber-code/database-tools --client claude

要安装和使用此工具,请按照以下步骤操作:

  1. 克隆或下载存储库

    git clone [repository-url]

    或下载并解压 ZIP 文件。

  2. 安装依赖项导航到项目目录并运行:

    npm install

配置

为了让 Claude 使用此工具,您需要将配置添加到您的claude_desktop_config.json文件中,该文件通常位于:

C:\Users\YOUR_USER\AppData\Roaming\Claude\claude_desktop_config.json

具有以下结构:

{
  "mcpServers": {
    // Other existing configurations...
    "database-tools": {
      "command": "node",
      "args": [
        "C:\\path\\to\\index.js"
      ]
    }
  }
}

用法

配置完成后,您可以使用以下命令从 Claude 与 MySQL 数据库进行交互:

  1. 列出所有数据库
    “在 MySQL 中执行查询以显示数据库。”

  2. 查看数据库中的表
    “在 MySQL 中执行查询以显示表name_table 。”

  3. 查询表的大小
    “在 MySQL 中执行查询以显示表name_table的大小。”

  4. 执行自定义查询
    “在 MySQL 中执行查询:‘您希望查询执行的操作的描述。’”

安全

此工具使用mysql.js文件中配置的权限运行。请确保提供的凭据仅具有您要允许的操作所需的必要权限。

故障排除

如果您遇到连接问题,请检查:

  • MySQL 正在运行

  • mysql.js中的凭据正确

  • Claude配置文件中的路径是正确的

执行

要查询数据库,只需向 Claude 询问类似“显示我的 MySQL 中的所有数据库”或“用户表的大小是多少?”

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