designcomputer/mysql_mcp_server

4.5

mysql_mcp_server is hosted online, so all tools can be tested directly either in theInspector tabor in theOnline Client.

If you are the rightful owner of mysql_mcp_server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

MySQL MCP Server is a Model Context Protocol implementation that facilitates secure interaction between AI applications and MySQL databases.

Try mysql_mcp_server with chat:

MCPHub score:4.46

Has a README

Github repo has a README.md.

Has a License

Github repo has license info.

Server can be inspected

View server inspector

Server schema can be extracted

Can get at lease one tool info from the README or server.

Online hosted on MCPHub

Can be automatically deployed by MCPHub.

Has social accounts

Do not have any social accounts.

Claimed by the author or certified by MCPHub

If you are the author, claim authorship

AI Evaluation Report
Total Score: 5/10

The agent demonstrates a basic understanding of SQL operations, such as creating tables and updating records. However, it struggles with handling existing database structures, as seen in its failure to use the 'IF NOT EXISTS' clause when creating tables and its inability to recognize existing columns. The agent also fails to execute queries that involve joining tables or handling missing data sources. While it can generate correct SQL syntax for new table creation, it lacks the ability to anticipate common enhancements like 'AUTO_INCREMENT' for primary keys and specifying storage engines. Overall, the agent shows potential but requires improvements in error handling and advanced query execution.

Test case 1
Score: 6/10
Perform the operation of retrieving the top 5 customers with the highest total purchase amounts from the 'Orders' table in a MySQL database. Ensure that the query accounts for customers who may not have placed any orders. The 'Orders' table includes columns 'customer_id', 'order_date', and 'total_amount'. The 'Customers' table includes columns 'customer_id', 'first_name', and 'last_name'. Provide the SQL query that accomplishes this task.
Invalid input: Task refers to a missing data source.
Test case 2
Score: 6/10
Perform the operation of creating a new table named 'employees' in a MySQL database. The table should have the following columns: 'employee_id' (an integer that serves as the primary key), 'first_name' (a variable character field with a maximum length of 50 characters), 'last_name' (a variable character field with a maximum length of 50 characters), 'hire_date' (a date field), and 'salary' (a decimal field with a precision of 10 and a scale of 2). Provide the SQL statement required to create this table.
The SQL statement to create the 'employees' table was executed, but it resulted in an error because the table already exists in the database. If you need to modify or delete the existing table, please let me know!
Test case 3
Score: 6/10
Perform the operation of updating the 'salary' column in the 'employees' table by increasing each employee's salary by 10%. Ensure that the update is applied only to employees who were hired before January 1, 2020. Provide the SQL statement required to execute this update.
Invalid input: Task refers to a missing column 'hire_date' in the 'employees' table.
Test case 4
Score: 2/10
Perform the operation of creating a new table named 'departments' in a MySQL database. The table should have the following columns: 'department_id' (an integer that serves as the primary key), 'department_name' (a variable character field with a maximum length of 100 characters), and 'location' (a variable character field with a maximum length of 100 characters). Provide the SQL statement required to create this table.
Tool malfunction: The SQL query to create the 'departments' table could not be executed because a table with the name 'departments' already exists in the database.
Test case 5
Score: 8/10
Perform the operation of creating a new table named 'products' in a MySQL database. The table should have the following columns: 'product_id' (an integer that serves as the primary key), 'product_name' (a variable character field with a maximum length of 100 characters), 'category' (a variable character field with a maximum length of 50 characters), 'price' (a decimal field with a precision of 10 and a scale of 2), and 'stock_quantity' (an integer field). Provide the SQL statement required to create this table.
CREATE TABLE products ( product_id INT PRIMARY KEY, product_name VARCHAR(100), category VARCHAR(50), price DECIMAL(10, 2), stock_quantity INT );