| Name | mysql-mcp-zag JSON |
| Version |
1.2.0
JSON |
| download |
| home_page | None |
| Summary | A modern MySQL Model Context Protocol (MCP) server built with FastMCP |
| upload_time | 2025-08-26 21:37:16 |
| maintainer | None |
| docs_url | None |
| author | None |
| requires_python | >=3.13 |
| license | MIT |
| keywords |
ai
database
llm
mcp
mysql
|
| VCS |
 |
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
# MySQL MCP Server
A modern MySQL Model Context Protocol (MCP) server built with FastMCP.
## Features
- Execute SQL queries via MCP tools
- Browse database tables and structure via MCP resources
- SSL certificate support
- Connection pooling and error handling
## Configuration
### Command Line Arguments
#### Required Arguments
| Argument | Description | Default |
|----------|-------------|---------|
| `--user` | MySQL username | **(required)** |
| `--password` | MySQL password | **(required)** |
| `--database` | MySQL database name | **(required)** |
#### Database Connection (Optional)
| Argument | Description | Default |
|----------|-------------|---------|
| `--host` | MySQL server host | `localhost` |
| `--port` | MySQL server port | `3306` |
#### SSL Configuration (Optional)
| Argument | Description | Default |
|----------|-------------|---------|
| `--ssl-ca` | Path to SSL CA certificate file | *(none - SSL auto-negotiated)* |
| `--ssl-cert` | Path to SSL client certificate file | *(none)* |
| `--ssl-key` | Path to SSL client private key file | *(none)* |
| `--ssl-disabled` | Disable SSL connection entirely | `false` |
**Note:** If `--ssl-cert` is provided, `--ssl-key` must also be provided, and vice versa.
#### Advanced Options (Optional)
| Argument | Description | Default |
|----------|-------------|---------|
| `--charset` | Character set for the connection | `utf8mb4` |
| `--collation` | Collation for the connection | `utf8mb4_unicode_ci` |
| `--sql-mode` | MySQL SQL mode | `TRADITIONAL` |
## Usage
#### Simple Configuration
```json
{
"mcpServers": {
"mysql": {
"command": "uvx",
"args": [
"mysql-mcp-zag",
"--host", "localhost",
"--port", "3306",
"--user", "your_user",
"--password", "your_password",
"--database", "your_database"
]
}
}
}
```
#### Complex Configuration
```json
{
"mcpServers": {
"mysql": {
"command": "uvx",
"args": [
"mysql-mcp-zag",
"--host", "your-remote-host.com",
"--port", "25060",
"--user", "your_user",
"--password", "your_password",
"--database", "your_database",
"--ssl-ca", "/path/to/ca-certificate.pem"
]
}
}
}
```
## Available Tools
- `execute_sql`: Execute SQL queries
## Available Resources
- `mysql://tables`: List all tables
- `mysql://tables/{table}`: Describe table structure
## Requirements
- Python 3.13+
- MySQL server
- uvx (for installation and usage)
---
Created by Michael Zag, Michael@MichaelZag.com
Raw data
{
"_id": null,
"home_page": null,
"name": "mysql-mcp-zag",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.13",
"maintainer_email": null,
"keywords": "ai, database, llm, mcp, mysql",
"author": null,
"author_email": "Michael Zag <Michael@MichaelZag.com>",
"download_url": "https://files.pythonhosted.org/packages/d9/46/2c1f448cf1ab55faafb1d0a62170f7bbe1d8ecd0c62452bfc8b03c7ebfd6/mysql_mcp_zag-1.2.0.tar.gz",
"platform": null,
"description": "# MySQL MCP Server\n\nA modern MySQL Model Context Protocol (MCP) server built with FastMCP.\n\n## Features\n\n- Execute SQL queries via MCP tools\n- Browse database tables and structure via MCP resources\n- SSL certificate support\n- Connection pooling and error handling\n\n## Configuration\n\n### Command Line Arguments\n\n#### Required Arguments\n| Argument | Description | Default |\n|----------|-------------|---------|\n| `--user` | MySQL username | **(required)** |\n| `--password` | MySQL password | **(required)** |\n| `--database` | MySQL database name | **(required)** |\n\n#### Database Connection (Optional)\n| Argument | Description | Default |\n|----------|-------------|---------|\n| `--host` | MySQL server host | `localhost` |\n| `--port` | MySQL server port | `3306` |\n\n#### SSL Configuration (Optional)\n| Argument | Description | Default |\n|----------|-------------|---------|\n| `--ssl-ca` | Path to SSL CA certificate file | *(none - SSL auto-negotiated)* |\n| `--ssl-cert` | Path to SSL client certificate file | *(none)* |\n| `--ssl-key` | Path to SSL client private key file | *(none)* |\n| `--ssl-disabled` | Disable SSL connection entirely | `false` |\n\n**Note:** If `--ssl-cert` is provided, `--ssl-key` must also be provided, and vice versa.\n\n#### Advanced Options (Optional)\n| Argument | Description | Default |\n|----------|-------------|---------|\n| `--charset` | Character set for the connection | `utf8mb4` |\n| `--collation` | Collation for the connection | `utf8mb4_unicode_ci` |\n| `--sql-mode` | MySQL SQL mode | `TRADITIONAL` |\n\n## Usage\n\n#### Simple Configuration\n\n```json\n{\n \"mcpServers\": {\n \"mysql\": {\n \"command\": \"uvx\",\n \"args\": [\n \"mysql-mcp-zag\",\n \"--host\", \"localhost\",\n \"--port\", \"3306\",\n \"--user\", \"your_user\",\n \"--password\", \"your_password\",\n \"--database\", \"your_database\"\n ]\n }\n }\n}\n```\n\n#### Complex Configuration\n\n```json\n{\n \"mcpServers\": {\n \"mysql\": {\n \"command\": \"uvx\",\n \"args\": [\n \"mysql-mcp-zag\",\n \"--host\", \"your-remote-host.com\",\n \"--port\", \"25060\",\n \"--user\", \"your_user\",\n \"--password\", \"your_password\",\n \"--database\", \"your_database\",\n \"--ssl-ca\", \"/path/to/ca-certificate.pem\"\n ]\n }\n }\n}\n```\n\n## Available Tools\n\n- `execute_sql`: Execute SQL queries\n\n## Available Resources\n\n- `mysql://tables`: List all tables\n- `mysql://tables/{table}`: Describe table structure\n\n\n## Requirements\n\n- Python 3.13+\n- MySQL server\n- uvx (for installation and usage)\n\n---\n\nCreated by Michael Zag, Michael@MichaelZag.com",
"bugtrack_url": null,
"license": "MIT",
"summary": "A modern MySQL Model Context Protocol (MCP) server built with FastMCP",
"version": "1.2.0",
"project_urls": {
"Documentation": "https://github.com/Michaelzag/mysql-mcp-zag#readme",
"Homepage": "https://github.com/Michaelzag/mysql-mcp-zag",
"Issues": "https://github.com/Michaelzag/mysql-mcp-zag/issues",
"Repository": "https://github.com/Michaelzag/mysql-mcp-zag"
},
"split_keywords": [
"ai",
" database",
" llm",
" mcp",
" mysql"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "085e11370578026f4123ea6f855564a293c2459fd68e189b79acdb3478da3a03",
"md5": "eed260d9ba49fec0af78c65a6b7bc3b2",
"sha256": "d4566049ab1a2076b284dc1d0ac73bfbb52cd7e0cdd6a4f3d30ced4b59b4d393"
},
"downloads": -1,
"filename": "mysql_mcp_zag-1.2.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "eed260d9ba49fec0af78c65a6b7bc3b2",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.13",
"size": 6659,
"upload_time": "2025-08-26T21:37:15",
"upload_time_iso_8601": "2025-08-26T21:37:15.041457Z",
"url": "https://files.pythonhosted.org/packages/08/5e/11370578026f4123ea6f855564a293c2459fd68e189b79acdb3478da3a03/mysql_mcp_zag-1.2.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "d9462c1f448cf1ab55faafb1d0a62170f7bbe1d8ecd0c62452bfc8b03c7ebfd6",
"md5": "6379bff7422019d09b23657fe39f8752",
"sha256": "a5d587ef1255de0a4f59f360b2de36989bf2e9e3e969de06a2519f369d471aaa"
},
"downloads": -1,
"filename": "mysql_mcp_zag-1.2.0.tar.gz",
"has_sig": false,
"md5_digest": "6379bff7422019d09b23657fe39f8752",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.13",
"size": 50733,
"upload_time": "2025-08-26T21:37:16",
"upload_time_iso_8601": "2025-08-26T21:37:16.166310Z",
"url": "https://files.pythonhosted.org/packages/d9/46/2c1f448cf1ab55faafb1d0a62170f7bbe1d8ecd0c62452bfc8b03c7ebfd6/mysql_mcp_zag-1.2.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-08-26 21:37:16",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "Michaelzag",
"github_project": "mysql-mcp-zag#readme",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "mysql-mcp-zag"
}
