Allows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured
Detailed security scan evidence is not public for this MCP yet. Public identity, registry metadata, and independently observed protocol inventory remain available.
Installation and connection instructions are shown only when supported by retained package, repository, or endpoint evidence.
Version 0.4.4 declares 1 executable entrypoint.
python -m pip install 'mysql-mcp-server==0.4.4'uvx --from 'mysql-mcp-server==0.4.4' mysql-mcp-server{
"mcpServers": {
"mysql-mcp-server": {
"command": "uvx",
"args": [
"--from",
"mysql-mcp-server==0.4.4",
"mysql-mcp-server"
]
}
}
}| Canonical slug | mysql-mcp-server-3e68bf85 | Deployment | Local Only |
|---|---|---|---|
| Canonical package | pypi:mysql-mcp-server | Repository | designcomputer/mysql_mcp_server |
| First published | Jul 30, 2026 | Latest release | Jul 30, 2026 |
| Last security verification | — | Classification confidence | 90% |
| Publication | Draft | Official distribution | Not verified |
| Channel | Identifier | Current version | Versions | Source |
|---|---|---|---|---|
| pypi | mysql-mcp-server | 0.4.4 | 1 | Repository |
| Package | Version | Published / observed | Inventory | Security scan |
|---|---|---|---|---|
| pypimysql-mcp-server | 0.4.4Current | Jul 30, 2026 | 3 toolsPartial · 0 resources · 2 prompts | Evidence restricted |
Independently scan the exact version your agents use, receive alerts when its risk changes, and investigate every finding with retained version evidence.
No public current-version evidence is available yet.
| Tool | Category | Annotations | Risk |
|---|---|---|---|
execute_sqlExecute a SQL statement against the MySQL server. Use for SELECT, DML (INSERT/UPDATE/DELETE), SHOW, DESCRIBE, and ad-hoc queries. Supports cross-database queries using database.table notation. Single statements only — use fully qualified names instead of USE statements.Input schema{
"type": "object",
"properties": {
"query": {
"type": "string",
"description": "The SQL statement to execute. Single statements only."
}
},
"required": [
"query"
]
}Annotations{
"title": "Execute SQL",
"readOnlyHint": false,
"destructiveHint": true
} | — | WritesDestructive | — |
get_schema_infoGet column metadata for a table or all tables in the configured database: column names, data types, nullability, default values, and comments. Call this before querying an unfamiliar table. Omit table_name to see all tables at once. Accepts bare table names (uses MYSQL_DATABASE) or database.table for cross-database lookups.Input schema{
"type": "object",
"properties": {
"table_name": {
"type": "string",
"description": "Optional: bare table name, or database.table for a cross-database lookup."
}
}
}Annotations{
"title": "Get Schema Info",
"readOnlyHint": true,
"destructiveHint": false
} | — | Read onlyNon-destructive | — |
get_table_sampleFetch a small sample of rows from a table to understand its data format and content. Use alongside get_schema_info before writing complex queries. Accepts bare table names (uses MYSQL_DATABASE) or database.table for cross-database lookups.Input schema{
"type": "object",
"properties": {
"table_name": {
"type": "string",
"description": "Table to sample. Use database.table notation for cross-database queries."
},
"limit": {
"type": "integer",
"description": "Number of rows to return (default 5, max 20)."
}
},
"required": [
"table_name"
]
}Annotations{
"title": "Get Table Sample",
"readOnlyHint": true,
"destructiveHint": false
} | — | Read onlyNon-destructive | — |
analyze_tableDeep-dive into a specific table: retrieve its schema, sample its data, and suggest useful queries.
explore_databaseSystematically explore the database: discover available tables, inspect their schemas, sample the data, and summarize what's there.
| Endpoint | Transport | Authentication | Health | Observed |
|---|---|---|---|---|
| No verified remote endpoint is linked. | ||||
Install the selected package version with: python -m pip install 'mysql-mcp-server==0.4.4'
MySQL MCP Server exposed 3 tools during independent protocol observation, including execute_sql, get_schema_info, get_table_sample.
The selected current version does not yet have completed public verification. Unknown does not mean clean or vulnerable.
Curated product and capability guides containing this catalog record.