FastMCP MySQL Server
by jinto
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MYSQL_DB | No | Database name (optional) | |
| MYSQL_HOST | No | Database host | 127.0.0.1 |
| MYSQL_PORT | No | Database port | 3306 |
| MYSQL_USER | Yes | Database username | |
| MYSQL_PASSWORD | Yes | Database password | |
| MYSQL_CACHE_TTL | No | Cache TTL (ms) | 60000 |
| MYSQL_LOG_LEVEL | No | Log level (DEBUG, INFO, WARNING, ERROR) | INFO |
| MYSQL_POOL_SIZE | No | Connection pool size | 10 |
| MYSQL_FILTER_MODE | No | Filter mode (blacklist/whitelist/combined) | blacklist |
| MYSQL_ALLOW_DELETE | No | Enable DELETE queries | false |
| MYSQL_ALLOW_INSERT | No | Enable INSERT queries | false |
| MYSQL_ALLOW_UPDATE | No | Enable UPDATE queries | false |
| MYSQL_CACHE_ENABLED | No | Enable query result caching | true |
| MYSQL_QUERY_TIMEOUT | No | Query timeout (ms) | 30000 |
| MYSQL_CACHE_MAX_SIZE | No | Maximum cache entries | 1000 |
| MYSQL_RATE_LIMIT_RPM | No | Rate limit requests per minute | 60 |
| MYSQL_ENABLE_SECURITY | No | Enable all security features | true |
| MYSQL_MAX_QUERY_LENGTH | No | Maximum query length in characters | 10000 |
| MYSQL_RATE_LIMIT_BURST | No | Burst size for rate limiting | 10 |
| MYSQL_AUDIT_ALL_QUERIES | No | Audit all queries (performance impact) | false |
| MYSQL_LOG_SECURITY_EVENTS | No | Log security violations | true |
| MYSQL_PAGINATION_MAX_SIZE | No | Maximum page size | 1000 |
| MYSQL_ENABLE_RATE_LIMITING | No | Enable rate limiting | true |
| MYSQL_LOG_REJECTED_QUERIES | No | Log rejected queries | true |
| MYSQL_MAX_PARAMETER_LENGTH | No | Maximum parameter length | 1000 |
| MYSQL_RATE_LIMIT_ALGORITHM | No | Rate limiting algorithm (token_bucket/sliding_window/fixed_window) | token_bucket |
| MYSQL_STREAMING_CHUNK_SIZE | No | Streaming query chunk size | 1000 |
| MYSQL_CACHE_EVICTION_POLICY | No | Cache eviction policy (lru/ttl/fifo) | lru |
| MYSQL_CACHE_CLEANUP_INTERVAL | No | Cache cleanup interval (seconds) | 60.0 |
| MYSQL_CACHE_INVALIDATION_MODE | No | Cache invalidation strategy | aggressive |
| MYSQL_PAGINATION_DEFAULT_SIZE | No | Default page size | 10 |
| MYSQL_ENABLE_INJECTION_DETECTION | No | Enable SQL injection detection | true |
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/jinto/fastmcp-mysql'
If you have feedback or need assistance with the MCP directory API, please join our Discord server