Skip to main content
Glama
donald-ada

mysql

by donald-ada
OverviewSchemaRelated ServersScoreDiscussions
JavaScript
Remote

@longlonga/mysql

A Model Context Protocol (MCP) server for interacting with MySQL databases. Provides tools for querying, inspecting, and modifying MySQL databases directly from Claude.

Installation

Via Claude Code (recommended)

claude mcp add --scope user mysql \
  -e MYSQL_HOST=your-host \
  -e MYSQL_PORT=3306 \
  -e MYSQL_USER=your-user \
  -e MYSQL_PASSWORD=your-password \
  -e MYSQL_DATABASE=your-database \
  -- npx -y @longlonga/mysql

Via claude_desktop_config.json

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["-y", "@longlonga/mysql"],
      "env": {
        "MYSQL_HOST": "your-host",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your-user",
        "MYSQL_PASSWORD": "your-password",
        "MYSQL_DATABASE": "your-database"
      }
    }
  }
}

Related MCP server: MCP MySQL App

Configuration

Environment Variable

Required

Default

Description

MYSQL_HOST

Yes

—

MySQL server hostname or IP

MYSQL_PORT

No

3306

MySQL server port

MYSQL_USER

Yes

—

MySQL username

MYSQL_PASSWORD

Yes

—

MySQL password

MYSQL_DATABASE

No

—

Default database (can be overridden per tool call)

Tools

Tool

Description

mysql_list_databases

List all databases the user has access to

mysql_list_tables

List all tables in a database

mysql_describe_table

Get column definitions for a table

mysql_show_create_table

Get the full CREATE TABLE DDL statement

mysql_query

Execute a read-only SELECT/SHOW/EXPLAIN query

mysql_execute

Execute a write SQL statement (INSERT/UPDATE/DELETE/DDL)

mysql_table_stats

Get row count and size statistics for tables

Usage Examples

Once connected, you can ask Claude things like:

  • "List all tables in my database"

  • "Describe the structure of the users table"

  • "Query the last 10 orders"

  • "How many rows are in each table?"

License

MIT

Install Server
A
license - permissive license
A
quality
D
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Tools

Related MCP Servers

  • MCP MySQL App

    zalab-inc
    A
    license
    -
    quality
    D
    maintenance
    A Model Context Protocol (MCP) server that enables AI assistants to interact with MySQL databases by executing SQL queries and checking database connectivity.
    MIT

  • MCP MySQL Server

    Atomzzm
    A
    license
    B
    quality
    D
    maintenance
    A Model Context Protocol server that enables AI models to interact with MySQL databases, providing tools for querying, executing statements, listing tables, and describing table structures.
    5
    559
    MIT

  • MCP MySQL Server

    kevinbin
    F
    license
    B
    quality
    D
    maintenance
    A Model Context Protocol server that enables AI models to interact with MySQL databases through a standardized interface, providing tools for querying, executing commands, and managing database schemas.
    7

View all related MCP servers

Related MCP Connectors

  • hithereiamaliff-mcp-nextcloud

    A comprehensive Model Context Protocol (MCP) server that enables AI assistants to interact with yo…

  • mcp

    MCP server for managing Prisma Postgres.

  • mcp

    MCP (Model Context Protocol) server for Appwrite

View all MCP Connectors

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/donald-ada/mysql'

If you have feedback or need assistance with the MCP directory API, please join our Discord server