tokenlite-mysql-mcp

{
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "name": "io.github.andezdev/tokenlite-mysql-mcp",
  "description": "A secure, efficient, and intelligent MySQL server for the Model Context Protocol",
  "repository": {
    "url": "https://github.com/andezdev/tokenlite-mysql-mcp",
    "source": "github"
  },
  "version": "4.1.0",
  "packages": [
    {
      "registryType": "npm",
      "identifier": "@andezdev/tokenlite-mysql-mcp",
      "version": "4.1.0",
      "transport": {
        "type": "stdio"
      },
      "environmentVariables": [
        {
          "description": "MySQL Host address (defaults to localhost)",
          "format": "string",
          "name": "DB_HOST"
        },
        {
          "description": "MySQL Port (defaults to 3306)",
          "format": "string",
          "name": "DB_PORT"
        },
        {
          "description": "MySQL Username (defaults to root)",
          "format": "string",
          "name": "DB_USER"
        },
        {
          "description": "MySQL Password (defaults to empty string)",
          "format": "string",
          "isSecret": true,
          "name": "DB_PASSWORD"
        },
        {
          "description": "MySQL Database name",
          "isRequired": true,
          "format": "string",
          "name": "DB_NAME"
        },
        {
          "description": "EXPLAIN guardrail: max estimated rows for unindexed full table scans before blocking (defaults to 1000). MCP_SAFE_QUERY_MAX_ROWS is a deprecated alias.",
          "format": "string",
          "name": "MCP_EXPLAIN_MAX_SCAN_ROWS"
        },
        {
          "description": "Max rows returned per SELECT; injected as LIMIT at the AST level (defaults to 500)",
          "format": "string",
          "name": "MCP_QUERY_ROW_LIMIT"
        },
        {
          "description": "Deprecated alias for MCP_EXPLAIN_MAX_SCAN_ROWS",
          "format": "string",
          "name": "MCP_SAFE_QUERY_MAX_ROWS"
        },
        {
          "description": "Enable or disable the EXPLAIN guardrail (defaults to true)",
          "format": "string",
          "name": "MCP_SAFE_QUERY_ENABLE_BLOCKING"
        },
        {
          "description": "Absolute path to your custom metadata.json dictionary",
          "format": "string",
          "name": "MCP_METADATA_PATH"
        },
        {
          "description": "Absolute path to your custom templates.json pre-approved queries",
          "format": "string",
          "name": "MCP_TEMPLATES_PATH"
        },
        {
          "description": "Prefix for tool names, e.g., to run multiple instances (defaults to DB_NAME, e.g. mydb_). Only set to override.",
          "format": "string",
          "name": "TOOL_PREFIX"
        },
        {
          "description": "Max tool invocations per minute, sliding window (defaults to 60). Set to 0 to disable.",
          "format": "string",
          "name": "MCP_RATE_LIMIT_RPM"
        },
        {
          "description": "Max execution time for a query in milliseconds to protect against DoS (defaults to 15000)",
          "format": "string",
          "name": "MYSQL_QUERY_TIMEOUT"
        },
        {
          "description": "Max concurrent pool connections (defaults to 10)",
          "format": "string",
          "name": "MYSQL_CONNECTION_LIMIT"
        },
        {
          "description": "Max time to wait for a connection socket to establish in milliseconds (defaults to 10000)",
          "format": "string",
          "name": "MYSQL_CONNECT_TIMEOUT"
        },
        {
          "description": "Max retries on transient connection errors (defaults to 3)",
          "format": "string",
          "name": "MYSQL_RETRY_ATTEMPTS"
        },
        {
          "description": "Base delay in milliseconds for exponential backoff between retries (defaults to 1000)",
          "format": "string",
          "name": "MYSQL_RETRY_DELAY_MS"
        },
        {
          "description": "Max queued requests when all pool connections are busy to prevent memory leak (defaults to 50)",
          "format": "string",
          "name": "MYSQL_QUEUE_LIMIT"
        },
        {
          "description": "Time-to-live in seconds for cached DDL statements (defaults to 60)",
          "format": "string",
          "name": "MCP_DDL_CACHE_TTL"
        },
        {
          "description": "Minimum severity level for MCP log notifications (defaults to info). Levels: debug, info, notice, warning, error, critical, alert, emergency",
          "format": "string",
          "name": "MCP_LOG_LEVEL"
        },
        {
          "description": "Enable INSERT and REPLACE queries (defaults to false)",
          "format": "string",
          "name": "ALLOW_INSERT_OPERATION"
        },
        {
          "description": "Enable UPDATE queries (defaults to false)",
          "format": "string",
          "name": "ALLOW_UPDATE_OPERATION"
        },
        {
          "description": "Enable DELETE and TRUNCATE queries (defaults to false)",
          "format": "string",
          "name": "ALLOW_DELETE_OPERATION"
        },
        {
          "description": "Enable Data Definition Language queries like CREATE, ALTER, DROP, RENAME (defaults to false)",
          "format": "string",
          "name": "ALLOW_DDL_OPERATION"
        },
        {
          "description": "Enable TLS for the MySQL connection (defaults to false)",
          "format": "string",
          "name": "DB_SSL"
        },
        {
          "description": "Reject self-signed or untrusted TLS certificates when DB_SSL is true (defaults to true)",
          "format": "string",
          "name": "DB_SSL_REJECT_UNAUTHORIZED"
        }
      ]
    }
  ]
}