Skip to content
Agentmart
Submit a tool

MySQL MCP Server

Python MCP server for MySQL database inspection and querying

Connector by musaddiq-dev · GitHub account verified by the MCP Registry

IndexedMITLocal (stdio)
Write a review

Install

Works with Claude Code, Codex, VS Code, Cursor, Windsurf, Claude Desktop. Read the repository before you give any tool access to your data.

npx agentmarket install connector/musaddiq-dev-mysql-mcp-server

Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.

Get the weekly diff

The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.

We use your email only for this newsletter. Privacy

About

Python MCP server for MySQL database inspection and querying

Reviews

Write a review

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this server can do and what it asks for, from its tool list and install config. Checked Oct 25, 2026.

Tools
6 read · 0 write · 2 delete
Secrets
1 (API keys, tokens or passwords)
Install scripts
Not scanned yet
Runs as
Python package

Tools by what they do 8

Read from the source code; the running server may list different tools.

Read 6 · Look things up without changing anything.

  • mysql_describe_table
  • mysql_execute_read_query
  • mysql_explain_query
  • mysql_get_database_summary
  • mysql_get_table_ddl
  • mysql_list_tables

Delete 2 · Delete, drop, revoke or wipe things.

  • mysql_execute_ddl
  • mysql_execute_write_query

Secrets and settings it asks for

Secrets: values you paste in that let it act as you.

  • MYSQL_PASSWORD

Other settings (environment variables or headers).

  • LOG_LEVEL
  • MYSQL_DATABASE
  • MYSQL_HOST
  • MYSQL_POOL_SIZE
  • MYSQL_PORT
  • MYSQL_READ_QUERY_LIMIT
  • MYSQL_USER

Tools (8)

Read from the source code; the running server may differ. Descriptions are the server’s own words; hidden characters are shown as [U+…].

  • mysql_describe_tableDescribe MySQL Tableread-only

    Describe the schema of a specific table. Args: table_name: The name of the table to describe. Returns: A list of dictionaries containing column information.

  • mysql_execute_ddlExecute MySQL DDLcan change or delete data

    Execute a DDL (Data Definition Language) statement for schema modifications. This tool allows executing schema changes like CREATE TABLE, DROP TABLE, ALTER TABLE, and TRUNCATE TABLE. WARNING: This tool modifies database schema and can result in data loss. Use with extreme caution. Args: query: The SQL DDL query to execute (CREATE, DROP, ALTER, TRUNCATE). Returns: A dictionary containing: - success: Boolean indicating if the operation was successful - message: Human-readable message describing the result Raises: ValueError: If the query is not a valid DDL statement.

  • mysql_execute_read_queryExecute MySQL Read Queryread-only

    Execute a SELECT query and return the results. This tool only allows SELECT statements for safety. It prevents DROP, DELETE, INSERT, UPDATE, and other potentially dangerous statements. Args: query: The SQL SELECT query to execute. Returns: A list of dictionaries containing the query results. Raises: ValueError: If the query is not a valid SELECT statement.

  • mysql_execute_write_queryExecute MySQL Write Querycan change or delete data

    Execute a data modification query (INSERT, UPDATE, DELETE) and return the results. This tool allows executing DML (Data Manipulation Language) statements that modify data in the database. It explicitly validates that only INSERT, UPDATE, or DELETE statements are executed. WARNING: This tool modifies data. Use with caution. Args: query: The SQL INSERT, UPDATE, or DELETE query to execute. Returns: A dictionary containing: - success: Boolean indicating if the operation was successful - message: Human-readable message describing the result - rows_affected: Number of rows af…

  • mysql_explain_queryExplain MySQL Queryread-only

    Explain the execution plan of a SQL query. This function prepends EXPLAIN to the provided SQL query and executes it to help analyze the performance and execution plan of complex queries. Args: query: The SQL query to explain. Returns: A list of dictionaries containing the execution plan details.

  • mysql_get_database_summaryGet MySQL Database Summaryread-only

    Get a comprehensive summary of the current database. This function returns a JSON summary containing: - The current database name - The total number of tables - A list of all table names with their row counts Returns: A dictionary containing the database summary information.

  • mysql_get_table_ddlGet MySQL Table DDLread-only

    Get the DDL (Data Definition Language) statement for creating a table. This function executes SHOW CREATE TABLE to get the exact SQL used to create the table, including foreign keys, indexes, and specific data types. Args: table_name: The name of the table to get DDL for. Returns: A string containing the CREATE TABLE statement.

  • mysql_list_tablesList MySQL Tablesread-only

    List all tables in the database. Returns: A list of table names.

Signals

Stars
0
Forks
1
Open issues
0
Weekly downloads
43
Last commit
May 23, 2026 (5 months ago)
Last release
May 23, 2026 (5 months ago)
Last package publish
May 23, 2026 (5 months ago)

From GitHub (fetched Oct 24, 2026) and the package registry.

Details

Registry name
io.github.musaddiq-dev/mysql-mcp-server
Version
0.1.2
Auth
API key
Packages
pypi mdev-mysql-mcp-server
License
MIT
Repository
github.com/musaddiq-dev/mysql-mcp-server
First seen
Oct 24, 2026
Last checked
Oct 24, 2026
Source
Official MCP Registrygithub-graphql

More from musaddiq-dev

Cite this page

MySQL MCP Server. Agent Mart. https://agentmart.dev/connectors/musaddiq-dev-mysql-mcp-server (last updated 2026-10-24)