Skip to main content
Glama
TickHaiJun

MCP MySQL Server

by TickHaiJun

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
DB_HOSTNoThe database hostlocalhost
DB_NAMENoThe database name
DB_PORTNoThe database port3306
DB_USERNoThe database userroot
DB_PASSWORDNoThe database password

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Server capabilities have not been inspected yet.

Tools

Functions exposed to the LLM to take actions

NameDescription
connect_dbC

Connect to MySQL database using URL or config

queryC

Execute a SELECT query

executeC

Execute an INSERT, UPDATE, or DELETE query

list_tablesB

List all tables in the database

describe_tableB

Get table structure

create_tableC

Create a new table in the database

add_columnC

Add a new column to existing table

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

TDQS

A3.5/5.0

Scored across 7 tools

Disambiguation5/5

Each tool has a clearly distinct purpose with no overlap: add_column modifies table structure, connect_db handles connections, create_table creates tables, describe_table inspects structure, execute handles write queries, list_tables enumerates tables, and query handles read queries. The separation between execute (for INSERT/UPDATE/DELETE) and query (for SELECT) is particularly well-defined.

Naming Consistency5/5

All tools follow a consistent verb_noun pattern with clear, descriptive names in snake_case: add_column, connect_db, create_table, describe_table, execute, list_tables, query. The naming convention is uniform throughout the set, making it easy to predict tool functions.

Tool Count5/5

With 7 tools, this server is well-scoped for MySQL database operations. Each tool serves a distinct, essential function in the database management workflow, from connection and table listing to query execution and schema modification. The count is neither too sparse nor bloated.

Completeness4/5

The tool set covers core MySQL operations effectively: connection management, table CRUD (create, list, describe), schema modification (add_column), and query execution (both read and write). A minor gap is the lack of tools for deleting tables or columns, which might require workarounds using execute, but the surface is otherwise complete for basic database interactions.

Maintenance

ActivityInactive
ResponsivenessNo issues