fastmcp-mysql


Namefastmcp-mysql JSON
Version 0.1.2 PyPI version JSON
download
home_pageNone
SummaryFastMCP server for MySQL database operations
upload_time2025-07-09 05:02:51
maintainerNone
docs_urlNone
authorNone
requires_python>=3.10
licenseNone
keywords ai database fastmcp llm mcp mysql
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            # FastMCP MySQL Server

A FastMCP server implementation for MySQL database operations, providing secure and efficient access to MySQL databases for LLM applications.

## Features

- πŸ”’ **Secure by Default**: Read-only access with optional write permissions
- ⚑ **High Performance**: Connection pooling and async operations
- πŸ›‘οΈ **SQL Injection Protection**: Built-in query validation and prepared statements
- πŸ“Š **Comprehensive Monitoring**: Structured JSON logging
- πŸ”§ **Flexible Configuration**: Environment variable based configuration
- πŸš€ **Easy Deployment**: Install and run with `uvx`

## Installation

### Using uvx (Recommended)

```bash
# Run directly with uvx
uvx fastmcp-mysql

# With environment variables
MYSQL_HOST=localhost MYSQL_USER=myuser MYSQL_PASSWORD=mypass MYSQL_DB=mydb uvx fastmcp-mysql
```

### Using pip

```bash
pip install fastmcp-mysql
```

### From source

```bash
git clone https://github.com/jinto/fastmcp-mysql
cd fastmcp-mysql
uv sync --all-extras
```

## Configuration

Configure the server using environment variables:

### Required Variables

| Variable         | Description       | Default |
| ---------------- | ----------------- | ------- |
| `MYSQL_USER`     | Database username | -       |
| `MYSQL_PASSWORD` | Database password | -       |

### Optional Variables

| Variable                        | Description                             | Default     |
| ------------------------------- | --------------------------------------- | ----------- |
| `MYSQL_HOST`                    | Database host                           | "127.0.0.1" |
| `MYSQL_PORT`                    | Database port                           | "3306"      |
| `MYSQL_DB`                      | Database name (optional)                | None        |
| `MYSQL_ALLOW_INSERT`            | Enable INSERT queries                   | false       |
| `MYSQL_ALLOW_UPDATE`            | Enable UPDATE queries                   | false       |
| `MYSQL_ALLOW_DELETE`            | Enable DELETE queries                   | false       |
| `MYSQL_POOL_SIZE`               | Connection pool size                    | 10          |
| `MYSQL_QUERY_TIMEOUT`           | Query timeout (ms)                      | 30000       |
| `MYSQL_LOG_LEVEL`               | Log level (DEBUG, INFO, WARNING, ERROR) | INFO        |
| `MYSQL_CACHE_ENABLED`           | Enable query result caching             | true        |
| `MYSQL_CACHE_MAX_SIZE`          | Maximum cache entries                   | 1000        |
| `MYSQL_CACHE_TTL`               | Cache TTL (ms)                          | 60000       |
| `MYSQL_CACHE_EVICTION_POLICY`   | Cache eviction policy (lru/ttl/fifo)    | lru         |
| `MYSQL_CACHE_CLEANUP_INTERVAL`  | Cache cleanup interval (seconds)        | 60.0        |
| `MYSQL_CACHE_INVALIDATION_MODE` | Cache invalidation strategy             | aggressive  |
| `MYSQL_STREAMING_CHUNK_SIZE`    | Streaming query chunk size              | 1000        |
| `MYSQL_PAGINATION_DEFAULT_SIZE` | Default page size                       | 10          |
| `MYSQL_PAGINATION_MAX_SIZE`     | Maximum page size                       | 1000        |

## Usage

### Claude Desktop Configuration

#### Using Claude MCP CLI (Recommended)

```bash
# Install from PyPI (when published)
claude mcp add fastmcp-mysql \
  -e MYSQL_HOST="127.0.0.1" \
  -e MYSQL_PORT="3306" \
  -e MYSQL_USER="your_username" \
  -e MYSQL_PASSWORD="your_password" \
  -e MYSQL_DB="your_database" \
  -- uvx fastmcp-mysql

# Without specifying a database (use USE command)
claude mcp add fastmcp-mysql \
  -e MYSQL_HOST="127.0.0.1" \
  -e MYSQL_USER="your_username" \
  -e MYSQL_PASSWORD="your_password" \
  -- uvx fastmcp-mysql

# For local development
claude mcp add fastmcp-mysql \
  -e MYSQL_HOST="127.0.0.1" \
  -e MYSQL_PORT="3306" \
  -e MYSQL_USER="your_username" \
  -e MYSQL_PASSWORD="your_password" \
  -e MYSQL_DB="your_database" \
  -- uv run --project /path/to/fastmcp-mysql fastmcp-mysql
```

#### Manual Configuration

Add to your Claude Desktop configuration file:

```json
{
  "mcpServers": {
    "mysql": {
      "command": "uvx",
      "args": ["fastmcp-mysql"],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your_username",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DB": "your_database",
        "MYSQL_ENABLE_SECURITY": "true",
        "MYSQL_RATE_LIMIT_RPM": "60",
        "MYSQL_RATE_LIMIT_BURST": "10"
      }
    }
  }
}
```

### Available Tools

#### mysql_query

Execute SQL queries against the configured MySQL database.

**Parameters:**

- `query` (string, required): The SQL query to execute
- `params` (array, optional): Query parameters for prepared statements
- `database` (string, optional): Target database (for multi-db mode)

**Example:**

```python
# Simple query
result = await mysql_query("SELECT * FROM users WHERE active = 1")

# With parameters (SQL injection safe)
result = await mysql_query(
    "SELECT * FROM users WHERE age > %s AND city = %s",
    params=[18, "New York"]
)

# When no database is specified initially
result = await mysql_query("USE mydb")
result = await mysql_query("SHOW TABLES")
result = await mysql_query("SHOW DATABASES")
```

## Security

### Default Security Features

FastMCP MySQL includes comprehensive security features:

- **Read-only by default**: Write operations must be explicitly enabled
- **SQL injection prevention**:
  - Advanced pattern detection for SQL injection attempts
  - Parameter validation for all queries
  - Detection of encoded injection attempts (URL, Unicode, Hex)
- **Query filtering**:
  - Blacklist mode: Blocks dangerous operations (DDL, system tables, file operations)
  - Whitelist mode: Only allows explicitly approved query patterns
  - Customizable filtering rules
- **Rate limiting**:
  - Per-user request throttling
  - Configurable algorithms (Token Bucket, Sliding Window, Fixed Window)
  - Burst protection

### Security Configuration

Configure security features via environment variables:

| Variable                           | Description                                                        | Default      |
| ---------------------------------- | ------------------------------------------------------------------ | ------------ |
| `MYSQL_ENABLE_SECURITY`            | Enable all security features                                       | true         |
| `MYSQL_ENABLE_INJECTION_DETECTION` | Enable SQL injection detection                                     | true         |
| `MYSQL_ENABLE_RATE_LIMITING`       | Enable rate limiting                                               | true         |
| `MYSQL_FILTER_MODE`                | Filter mode (blacklist/whitelist/combined)                         | blacklist    |
| `MYSQL_RATE_LIMIT_RPM`             | Rate limit requests per minute                                     | 60           |
| `MYSQL_RATE_LIMIT_BURST`           | Burst size for rate limiting                                       | 10           |
| `MYSQL_RATE_LIMIT_ALGORITHM`       | Rate limiting algorithm (token_bucket/sliding_window/fixed_window) | token_bucket |
| `MYSQL_MAX_QUERY_LENGTH`           | Maximum query length in characters                                 | 10000        |
| `MYSQL_MAX_PARAMETER_LENGTH`       | Maximum parameter length                                           | 1000         |
| `MYSQL_LOG_SECURITY_EVENTS`        | Log security violations                                            | true         |
| `MYSQL_LOG_REJECTED_QUERIES`       | Log rejected queries                                               | true         |
| `MYSQL_AUDIT_ALL_QUERIES`          | Audit all queries (performance impact)                             | false        |

### Enabling Write Operations

Write operations are disabled by default. Enable them with caution:

```bash
# Enable specific write operations
MYSQL_ALLOW_INSERT=true \
MYSQL_ALLOW_UPDATE=true \
MYSQL_ALLOW_DELETE=true \
uvx fastmcp-mysql
```

### Security Best Practices

1. **Use Prepared Statements**: Always use parameters instead of string concatenation
2. **Principle of Least Privilege**: Only enable write operations when necessary
3. **Monitor Security Events**: Check logs for security violations
4. **Rate Limiting**: Adjust limits based on your application needs
5. **Whitelist Mode**: Use whitelist mode for production environments when possible

## Development

### Setup Development Environment

```bash
# Clone the repository
git clone https://github.com/jinto/fastmcp-mysql
cd fastmcp-mysql

# Create virtual environment with uv
uv venv
source .venv/bin/activate  # On Windows: .venv\Scripts\activate

# Install dependencies
uv sync --all-extras

# Install pre-commit hooks
pre-commit install
```

### Running Tests

```bash
# Run all tests
uv run pytest tests/

# Run with coverage
uv run pytest tests/ --cov=fastmcp_mysql

# Run specific test file
uv run pytest tests/unit/test_query.py

# Run integration tests only
uv run pytest tests/integration/
```

### Code Quality

```bash
# Format code
uv run black src tests

# Lint code
uv run ruff check src tests

# Type checking
uv run mypy src
```

## Architecture

The server follows Clean Architecture principles:

```
src/fastmcp_mysql/
β”œβ”€β”€ __init__.py                 # Package initialization
β”œβ”€β”€ __main__.py                 # Entry point for uvx
β”œβ”€β”€ config.py                   # Configuration management
β”œβ”€β”€ server.py                   # FastMCP server setup
β”œβ”€β”€ connection.py               # Database connection management
β”œβ”€β”€ security/                   # Security module (Clean Architecture)
β”‚   β”œβ”€β”€ __init__.py
β”‚   β”œβ”€β”€ manager.py              # Security orchestration
β”‚   β”œβ”€β”€ config.py               # Security configuration
β”‚   β”œβ”€β”€ exceptions.py           # Security exceptions
β”‚   β”œβ”€β”€ interfaces/             # Abstract interfaces
β”‚   β”‚   β”œβ”€β”€ injection_detector.py
β”‚   β”‚   β”œβ”€β”€ query_filter.py
β”‚   β”‚   └── rate_limiter.py
β”‚   β”œβ”€β”€ injection/              # SQL injection detection
β”‚   β”‚   β”œβ”€β”€ detector.py
β”‚   β”‚   └── patterns.py
β”‚   β”œβ”€β”€ filtering/              # Query filtering
β”‚   β”‚   β”œβ”€β”€ blacklist.py
β”‚   β”‚   β”œβ”€β”€ whitelist.py
β”‚   β”‚   └── combined.py
β”‚   └── rate_limiting/          # Rate limiting
β”‚       β”œβ”€β”€ token_bucket.py
β”‚       β”œβ”€β”€ sliding_window.py
β”‚       β”œβ”€β”€ fixed_window.py
β”‚       └── factory.py
└── tools/                      # MCP tools
    β”œβ”€β”€ __init__.py
    └── query.py                # Query execution tool
```

## Contributing

1. Fork the repository
2. Create a feature branch (`git checkout -b feature/amazing-feature`)
3. Commit your changes (`git commit -m 'Add amazing feature'`)
4. Push to the branch (`git push origin feature/amazing-feature`)
5. Open a Pull Request

Please ensure:

- All tests pass
- Code is formatted with black
- Type hints are added
- Documentation is updated

## License

This project is licensed under the MIT License - see the [LICENSE](LICENSE) file for details.

## Acknowledgments

- Based on the [MCP Server MySQL](https://github.com/benborla/mcp-server-mysql) Node.js implementation
- Built with [FastMCP](https://github.com/jlowin/fastmcp) framework
- MySQL connectivity via [aiomysql](https://github.com/aio-libs/aiomysql)

## Support

- πŸ“– [Documentation](https://github.com/jinto/fastmcp-mysql/wiki)
- πŸ› [Issue Tracker](https://github.com/jinto/fastmcp-mysql/issues)
- πŸ’¬ [Discussions](https://github.com/jinto/fastmcp-mysql/discussions)

            

Raw data

            {
    "_id": null,
    "home_page": null,
    "name": "fastmcp-mysql",
    "maintainer": null,
    "docs_url": null,
    "requires_python": ">=3.10",
    "maintainer_email": null,
    "keywords": "ai, database, fastmcp, llm, mcp, mysql",
    "author": null,
    "author_email": "\"\ubc15\uc81c\uad8c(Jae Kwon Park)\" <jaypark@gmail.com>",
    "download_url": "https://files.pythonhosted.org/packages/20/f8/2e60f4af3ceaf41dab7c61417e84a51218fa512c6cf54746f6eda2973065/fastmcp_mysql-0.1.2.tar.gz",
    "platform": null,
    "description": "# FastMCP MySQL Server\n\nA FastMCP server implementation for MySQL database operations, providing secure and efficient access to MySQL databases for LLM applications.\n\n## Features\n\n- \ud83d\udd12 **Secure by Default**: Read-only access with optional write permissions\n- \u26a1 **High Performance**: Connection pooling and async operations\n- \ud83d\udee1\ufe0f **SQL Injection Protection**: Built-in query validation and prepared statements\n- \ud83d\udcca **Comprehensive Monitoring**: Structured JSON logging\n- \ud83d\udd27 **Flexible Configuration**: Environment variable based configuration\n- \ud83d\ude80 **Easy Deployment**: Install and run with `uvx`\n\n## Installation\n\n### Using uvx (Recommended)\n\n```bash\n# Run directly with uvx\nuvx fastmcp-mysql\n\n# With environment variables\nMYSQL_HOST=localhost MYSQL_USER=myuser MYSQL_PASSWORD=mypass MYSQL_DB=mydb uvx fastmcp-mysql\n```\n\n### Using pip\n\n```bash\npip install fastmcp-mysql\n```\n\n### From source\n\n```bash\ngit clone https://github.com/jinto/fastmcp-mysql\ncd fastmcp-mysql\nuv sync --all-extras\n```\n\n## Configuration\n\nConfigure the server using environment variables:\n\n### Required Variables\n\n| Variable         | Description       | Default |\n| ---------------- | ----------------- | ------- |\n| `MYSQL_USER`     | Database username | -       |\n| `MYSQL_PASSWORD` | Database password | -       |\n\n### Optional Variables\n\n| Variable                        | Description                             | Default     |\n| ------------------------------- | --------------------------------------- | ----------- |\n| `MYSQL_HOST`                    | Database host                           | \"127.0.0.1\" |\n| `MYSQL_PORT`                    | Database port                           | \"3306\"      |\n| `MYSQL_DB`                      | Database name (optional)                | None        |\n| `MYSQL_ALLOW_INSERT`            | Enable INSERT queries                   | false       |\n| `MYSQL_ALLOW_UPDATE`            | Enable UPDATE queries                   | false       |\n| `MYSQL_ALLOW_DELETE`            | Enable DELETE queries                   | false       |\n| `MYSQL_POOL_SIZE`               | Connection pool size                    | 10          |\n| `MYSQL_QUERY_TIMEOUT`           | Query timeout (ms)                      | 30000       |\n| `MYSQL_LOG_LEVEL`               | Log level (DEBUG, INFO, WARNING, ERROR) | INFO        |\n| `MYSQL_CACHE_ENABLED`           | Enable query result caching             | true        |\n| `MYSQL_CACHE_MAX_SIZE`          | Maximum cache entries                   | 1000        |\n| `MYSQL_CACHE_TTL`               | Cache TTL (ms)                          | 60000       |\n| `MYSQL_CACHE_EVICTION_POLICY`   | Cache eviction policy (lru/ttl/fifo)    | lru         |\n| `MYSQL_CACHE_CLEANUP_INTERVAL`  | Cache cleanup interval (seconds)        | 60.0        |\n| `MYSQL_CACHE_INVALIDATION_MODE` | Cache invalidation strategy             | aggressive  |\n| `MYSQL_STREAMING_CHUNK_SIZE`    | Streaming query chunk size              | 1000        |\n| `MYSQL_PAGINATION_DEFAULT_SIZE` | Default page size                       | 10          |\n| `MYSQL_PAGINATION_MAX_SIZE`     | Maximum page size                       | 1000        |\n\n## Usage\n\n### Claude Desktop Configuration\n\n#### Using Claude MCP CLI (Recommended)\n\n```bash\n# Install from PyPI (when published)\nclaude mcp add fastmcp-mysql \\\n  -e MYSQL_HOST=\"127.0.0.1\" \\\n  -e MYSQL_PORT=\"3306\" \\\n  -e MYSQL_USER=\"your_username\" \\\n  -e MYSQL_PASSWORD=\"your_password\" \\\n  -e MYSQL_DB=\"your_database\" \\\n  -- uvx fastmcp-mysql\n\n# Without specifying a database (use USE command)\nclaude mcp add fastmcp-mysql \\\n  -e MYSQL_HOST=\"127.0.0.1\" \\\n  -e MYSQL_USER=\"your_username\" \\\n  -e MYSQL_PASSWORD=\"your_password\" \\\n  -- uvx fastmcp-mysql\n\n# For local development\nclaude mcp add fastmcp-mysql \\\n  -e MYSQL_HOST=\"127.0.0.1\" \\\n  -e MYSQL_PORT=\"3306\" \\\n  -e MYSQL_USER=\"your_username\" \\\n  -e MYSQL_PASSWORD=\"your_password\" \\\n  -e MYSQL_DB=\"your_database\" \\\n  -- uv run --project /path/to/fastmcp-mysql fastmcp-mysql\n```\n\n#### Manual Configuration\n\nAdd to your Claude Desktop configuration file:\n\n```json\n{\n  \"mcpServers\": {\n    \"mysql\": {\n      \"command\": \"uvx\",\n      \"args\": [\"fastmcp-mysql\"],\n      \"env\": {\n        \"MYSQL_HOST\": \"localhost\",\n        \"MYSQL_PORT\": \"3306\",\n        \"MYSQL_USER\": \"your_username\",\n        \"MYSQL_PASSWORD\": \"your_password\",\n        \"MYSQL_DB\": \"your_database\",\n        \"MYSQL_ENABLE_SECURITY\": \"true\",\n        \"MYSQL_RATE_LIMIT_RPM\": \"60\",\n        \"MYSQL_RATE_LIMIT_BURST\": \"10\"\n      }\n    }\n  }\n}\n```\n\n### Available Tools\n\n#### mysql_query\n\nExecute SQL queries against the configured MySQL database.\n\n**Parameters:**\n\n- `query` (string, required): The SQL query to execute\n- `params` (array, optional): Query parameters for prepared statements\n- `database` (string, optional): Target database (for multi-db mode)\n\n**Example:**\n\n```python\n# Simple query\nresult = await mysql_query(\"SELECT * FROM users WHERE active = 1\")\n\n# With parameters (SQL injection safe)\nresult = await mysql_query(\n    \"SELECT * FROM users WHERE age > %s AND city = %s\",\n    params=[18, \"New York\"]\n)\n\n# When no database is specified initially\nresult = await mysql_query(\"USE mydb\")\nresult = await mysql_query(\"SHOW TABLES\")\nresult = await mysql_query(\"SHOW DATABASES\")\n```\n\n## Security\n\n### Default Security Features\n\nFastMCP MySQL includes comprehensive security features:\n\n- **Read-only by default**: Write operations must be explicitly enabled\n- **SQL injection prevention**:\n  - Advanced pattern detection for SQL injection attempts\n  - Parameter validation for all queries\n  - Detection of encoded injection attempts (URL, Unicode, Hex)\n- **Query filtering**:\n  - Blacklist mode: Blocks dangerous operations (DDL, system tables, file operations)\n  - Whitelist mode: Only allows explicitly approved query patterns\n  - Customizable filtering rules\n- **Rate limiting**:\n  - Per-user request throttling\n  - Configurable algorithms (Token Bucket, Sliding Window, Fixed Window)\n  - Burst protection\n\n### Security Configuration\n\nConfigure security features via environment variables:\n\n| Variable                           | Description                                                        | Default      |\n| ---------------------------------- | ------------------------------------------------------------------ | ------------ |\n| `MYSQL_ENABLE_SECURITY`            | Enable all security features                                       | true         |\n| `MYSQL_ENABLE_INJECTION_DETECTION` | Enable SQL injection detection                                     | true         |\n| `MYSQL_ENABLE_RATE_LIMITING`       | Enable rate limiting                                               | true         |\n| `MYSQL_FILTER_MODE`                | Filter mode (blacklist/whitelist/combined)                         | blacklist    |\n| `MYSQL_RATE_LIMIT_RPM`             | Rate limit requests per minute                                     | 60           |\n| `MYSQL_RATE_LIMIT_BURST`           | Burst size for rate limiting                                       | 10           |\n| `MYSQL_RATE_LIMIT_ALGORITHM`       | Rate limiting algorithm (token_bucket/sliding_window/fixed_window) | token_bucket |\n| `MYSQL_MAX_QUERY_LENGTH`           | Maximum query length in characters                                 | 10000        |\n| `MYSQL_MAX_PARAMETER_LENGTH`       | Maximum parameter length                                           | 1000         |\n| `MYSQL_LOG_SECURITY_EVENTS`        | Log security violations                                            | true         |\n| `MYSQL_LOG_REJECTED_QUERIES`       | Log rejected queries                                               | true         |\n| `MYSQL_AUDIT_ALL_QUERIES`          | Audit all queries (performance impact)                             | false        |\n\n### Enabling Write Operations\n\nWrite operations are disabled by default. Enable them with caution:\n\n```bash\n# Enable specific write operations\nMYSQL_ALLOW_INSERT=true \\\nMYSQL_ALLOW_UPDATE=true \\\nMYSQL_ALLOW_DELETE=true \\\nuvx fastmcp-mysql\n```\n\n### Security Best Practices\n\n1. **Use Prepared Statements**: Always use parameters instead of string concatenation\n2. **Principle of Least Privilege**: Only enable write operations when necessary\n3. **Monitor Security Events**: Check logs for security violations\n4. **Rate Limiting**: Adjust limits based on your application needs\n5. **Whitelist Mode**: Use whitelist mode for production environments when possible\n\n## Development\n\n### Setup Development Environment\n\n```bash\n# Clone the repository\ngit clone https://github.com/jinto/fastmcp-mysql\ncd fastmcp-mysql\n\n# Create virtual environment with uv\nuv venv\nsource .venv/bin/activate  # On Windows: .venv\\Scripts\\activate\n\n# Install dependencies\nuv sync --all-extras\n\n# Install pre-commit hooks\npre-commit install\n```\n\n### Running Tests\n\n```bash\n# Run all tests\nuv run pytest tests/\n\n# Run with coverage\nuv run pytest tests/ --cov=fastmcp_mysql\n\n# Run specific test file\nuv run pytest tests/unit/test_query.py\n\n# Run integration tests only\nuv run pytest tests/integration/\n```\n\n### Code Quality\n\n```bash\n# Format code\nuv run black src tests\n\n# Lint code\nuv run ruff check src tests\n\n# Type checking\nuv run mypy src\n```\n\n## Architecture\n\nThe server follows Clean Architecture principles:\n\n```\nsrc/fastmcp_mysql/\n\u251c\u2500\u2500 __init__.py                 # Package initialization\n\u251c\u2500\u2500 __main__.py                 # Entry point for uvx\n\u251c\u2500\u2500 config.py                   # Configuration management\n\u251c\u2500\u2500 server.py                   # FastMCP server setup\n\u251c\u2500\u2500 connection.py               # Database connection management\n\u251c\u2500\u2500 security/                   # Security module (Clean Architecture)\n\u2502   \u251c\u2500\u2500 __init__.py\n\u2502   \u251c\u2500\u2500 manager.py              # Security orchestration\n\u2502   \u251c\u2500\u2500 config.py               # Security configuration\n\u2502   \u251c\u2500\u2500 exceptions.py           # Security exceptions\n\u2502   \u251c\u2500\u2500 interfaces/             # Abstract interfaces\n\u2502   \u2502   \u251c\u2500\u2500 injection_detector.py\n\u2502   \u2502   \u251c\u2500\u2500 query_filter.py\n\u2502   \u2502   \u2514\u2500\u2500 rate_limiter.py\n\u2502   \u251c\u2500\u2500 injection/              # SQL injection detection\n\u2502   \u2502   \u251c\u2500\u2500 detector.py\n\u2502   \u2502   \u2514\u2500\u2500 patterns.py\n\u2502   \u251c\u2500\u2500 filtering/              # Query filtering\n\u2502   \u2502   \u251c\u2500\u2500 blacklist.py\n\u2502   \u2502   \u251c\u2500\u2500 whitelist.py\n\u2502   \u2502   \u2514\u2500\u2500 combined.py\n\u2502   \u2514\u2500\u2500 rate_limiting/          # Rate limiting\n\u2502       \u251c\u2500\u2500 token_bucket.py\n\u2502       \u251c\u2500\u2500 sliding_window.py\n\u2502       \u251c\u2500\u2500 fixed_window.py\n\u2502       \u2514\u2500\u2500 factory.py\n\u2514\u2500\u2500 tools/                      # MCP tools\n    \u251c\u2500\u2500 __init__.py\n    \u2514\u2500\u2500 query.py                # Query execution tool\n```\n\n## Contributing\n\n1. Fork the repository\n2. Create a feature branch (`git checkout -b feature/amazing-feature`)\n3. Commit your changes (`git commit -m 'Add amazing feature'`)\n4. Push to the branch (`git push origin feature/amazing-feature`)\n5. Open a Pull Request\n\nPlease ensure:\n\n- All tests pass\n- Code is formatted with black\n- Type hints are added\n- Documentation is updated\n\n## License\n\nThis project is licensed under the MIT License - see the [LICENSE](LICENSE) file for details.\n\n## Acknowledgments\n\n- Based on the [MCP Server MySQL](https://github.com/benborla/mcp-server-mysql) Node.js implementation\n- Built with [FastMCP](https://github.com/jlowin/fastmcp) framework\n- MySQL connectivity via [aiomysql](https://github.com/aio-libs/aiomysql)\n\n## Support\n\n- \ud83d\udcd6 [Documentation](https://github.com/jinto/fastmcp-mysql/wiki)\n- \ud83d\udc1b [Issue Tracker](https://github.com/jinto/fastmcp-mysql/issues)\n- \ud83d\udcac [Discussions](https://github.com/jinto/fastmcp-mysql/discussions)\n",
    "bugtrack_url": null,
    "license": null,
    "summary": "FastMCP server for MySQL database operations",
    "version": "0.1.2",
    "project_urls": {
        "Bug Reports": "https://github.com/jinto/fastmcp-mysql/issues",
        "Homepage": "https://github.com/jinto/fastmcp-mysql",
        "Source": "https://github.com/jinto/fastmcp-mysql"
    },
    "split_keywords": [
        "ai",
        " database",
        " fastmcp",
        " llm",
        " mcp",
        " mysql"
    ],
    "urls": [
        {
            "comment_text": null,
            "digests": {
                "blake2b_256": "5377e9902357338382eba3b6f27070595841cf2040d65b30576f9d60f8055dc3",
                "md5": "3d364ad2aae9d6d83379b10d6250af30",
                "sha256": "a9abff01542928a072469e40b7800b00aafae02d9cf9e9c759d87bcd47412ccf"
            },
            "downloads": -1,
            "filename": "fastmcp_mysql-0.1.2-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "3d364ad2aae9d6d83379b10d6250af30",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3.10",
            "size": 66490,
            "upload_time": "2025-07-09T05:02:50",
            "upload_time_iso_8601": "2025-07-09T05:02:50.163146Z",
            "url": "https://files.pythonhosted.org/packages/53/77/e9902357338382eba3b6f27070595841cf2040d65b30576f9d60f8055dc3/fastmcp_mysql-0.1.2-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": null,
            "digests": {
                "blake2b_256": "20f82e60f4af3ceaf41dab7c61417e84a51218fa512c6cf54746f6eda2973065",
                "md5": "a59c90fa7961b409dd45b38e2ead700b",
                "sha256": "88e55804770d37e49cd6de67a44aeb10ad427bbe40590353c5154cab7ca71ddf"
            },
            "downloads": -1,
            "filename": "fastmcp_mysql-0.1.2.tar.gz",
            "has_sig": false,
            "md5_digest": "a59c90fa7961b409dd45b38e2ead700b",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.10",
            "size": 203589,
            "upload_time": "2025-07-09T05:02:51",
            "upload_time_iso_8601": "2025-07-09T05:02:51.488511Z",
            "url": "https://files.pythonhosted.org/packages/20/f8/2e60f4af3ceaf41dab7c61417e84a51218fa512c6cf54746f6eda2973065/fastmcp_mysql-0.1.2.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2025-07-09 05:02:51",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "jinto",
    "github_project": "fastmcp-mysql",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": true,
    "lcname": "fastmcp-mysql"
}
        
Elapsed time: 1.91313s