git clone https://github.com/liyq0307/MySQLMCP.git
cd MySQLMCP

npm install

cp .env.example .env

MYSQL_HOST=localhost
MYSQL_PORT=3306
MYSQL_USER=your_username
MYSQL_PASSWORD=your_password
MYSQL_DATABASE=your_database

# 编译 TypeScript 代码
npm run build

# 启动服务器
npm start

# 使用 ts-node 直接运行进行开发
npm run dev

{
  "scope": "full",
  "includeDetails": true
}

{
  "mcpServers": {
    "mysql-mcp-ts": {
      "command": "node",
      "args": ["/path/to/your/MySQLMCP_TS/dist/index.js"], // 编译后的JS文件绝对路径
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_USER": "your_username",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database"
      }
    }
  }
}

{
  "mcpServers": {
    "mysql-prod": {
      "command": "node",
      "args": ["/path/to/your/MySQLMCP_TS/dist/index.js"],
      "env": {
        "NODE_ENV": "production",
        "MYSQL_HOST": "prod-db-host",
        "MYSQL_USER": "app_user",
        "MYSQL_PASSWORD": "secure_password",
        "MYSQL_DATABASE": "production_db",
        "MYSQL_CONNECTION_LIMIT": "50",
        "RATE_LIMIT_MAX": "1000",
        "SCHEMA_CACHE_SIZE": "256",
        "CACHE_TTL": "600",
        "MYSQL_SSL": "true"
      }
    }
  }
}

{
  "query": "SELECT * FROM users LIMIT 10",
}

{
  "query": "SELECT * FROM users WHERE id = ? AND status = ?",
  "params": [123, "active"]
}

{}

{
  "table_name": "users"
}

{
  "table_name": "products",
}

{
  "table_name": "users",
  "columns": ["id", "name", "email"],
  "where_clause": "status = 'active'",
  "limit": 50,
  "order_by": "price DESC"
}

{
  "table_name": "orders",
  "columns": ["order_id", "customer_id", "total_amount"],
  "where_clause": "created_at >= '2024-01-01' AND status IN ('pending', 'processing')",
  "limit": 100
}

{
  "table_name": "users",
  "data": {
    "name": "John Doe",
    "email": "john@example.com",
    "status": "active"
  }
}

{
  "table_name": "users",
  "data": { "status": "inactive", "updated_at": "2024-01-01" },
  "where_clause": "id = ?",
  "params": [123]
}

{
  "table_name": "users",
  "where_clause": "id = ?",
  "params": [123]
}

{
  "queries": [
    {"sql": "INSERT INTO users (name, email) VALUES (?, ?)", "params": ["John", "john@example.com"]},
    {"sql": "UPDATE profiles SET user_id = ? WHERE email = ?", "params": [1, "john@example.com"]},
    {"sql": "INSERT INTO user_logs (user_id, action) VALUES (LAST_INSERT_ID(), ?)", "params": ["user_created"]}
  ]
}

{
  "queries": [
    { "sql": "INSERT INTO new_users SELECT * FROM temp_users WHERE processed = 0" },
    { "sql": "UPDATE temp_users SET processed = 1 WHERE processed = 0" },
    { "sql": "DELETE FROM temp_users WHERE created_at < DATE_SUB(NOW(), INTERVAL 7 DAY)" }
  ]
}

{
  "table_name": "products",
  "data": [
    {"name": "Product A", "price": 29.99, "category": "Electronics"},
    {"name": "Product B", "price": 49.99, "category": "Books"},
    {"name": "Product C", "price": 19.99, "category": "Home"}
  ]
}

{
  "table_name": "users",
  "columns": [
    { "name": "id", "type": "INT", "primary_key": true, "auto_increment": true },
    { "name": "username", "type": "VARCHAR(50)", "nullable": false },
    { "name": "email", "type": "VARCHAR(100)", "nullable": false },
    { "name": "created_at", "type": "TIMESTAMP", "default": "CURRENT_TIMESTAMP" }
  ]
}

{
  "table_name": "users",
  "columns": [
    {"name": "id", "type": "INT", "primary_key": true, "auto_increment": true},
    {"name": "name", "type": "VARCHAR(255)", "nullable": false},
    {"name": "email", "type": "VARCHAR(255)", "nullable": false, "unique": true},
    {"name": "created_at", "type": "TIMESTAMP", "default": "CURRENT_TIMESTAMP"}
  ],
  "indexes": [
    {"name": "idx_email", "columns": ["email"], "type": "UNIQUE"},
    {"name": "idx_created_at", "columns": ["created_at"], "type": "INDEX"}
  ]
}

{
  "table_name": "temp_table",
}

{
  "table_name": "temp_table",
  "if_exists": true
}

{}

{
  "table_name": "users"
}

{
  "table_name": "orders"
}

{
  "table_name": "users",
  "alterations": [
    { "type": "ADD_COLUMN", "column": { "name": "age", "type": "INT", "nullable": true } }
  ]
}

// 启用慢查询日志
{
  "action": "enable_slow_query_log",
  "longQueryTime": 2,
  "logQueriesNotUsingIndexes": true
}

// 分析慢查询
{
  "action": "analyze_slow_queries",
  "limit": 10,
  "include_details": true
}

// 生成综合性能报告
{
  "action": "suggest_indexes",
  "time_range": "1 week"
}

// 对特定查询进行性能剖析
{
  "action": "query_profiling",
  "query": "SELECT * FROM users WHERE email = ? AND status = ?",
  "params": ["user@example.com", "active"],
  "include_details": true
}

{
  "outputDir": "/backup",
  "compress": true,
  "includeData": true,
  "includeStructure": true,
  "filePrefix": "daily_backup"
}

{
  "includeData": false,
  "includeStructure": true,
  "tables": ["users", "products", "orders"],
  "filePrefix": "schema_only"
}

{
  "backupType": "incremental",
  "incrementalMode": "timestamp",
  "lastBackupTime": "2024-01-15T00:00:00Z",
  "trackingTable": "backup_history",
  "filePrefix": "incremental_backup"
}

{
  "backupType": "large-file",
  "chunkSize": 128,
  "maxMemoryUsage": 1024,
  "compressionLevel": 9,
  "diskThreshold": 500,
  "filePrefix": "large_dataset_backup"
}

{
  "withProgress": true,
  "priority": 5,
  "useQueue": true,
  "filePrefix": "progress_tracked_backup"
}

{
  "withRecovery": true,
  "retryCount": 3,
  "compress": true,
  "maxFileSize": 200,
  "filePrefix": "reliable_backup"
}

{
  "backupFilePath": "/backup/mysql_backup_2024.sql"
}

{
  "backupFilePath": "/backup/mysql_backup_2024.sql",
  "deepValidation": true,
  "validateStructure": true,
  "validateData": true,
  "checkCorruption": true,
  "maxSampleSize": 5000 
}

{
  "backupFilePath": "/backup/schema_only_backup.sql",
  "deepValidation": false,
  "validateStructure": true,
  "validateData": false,
  "generateReport": true,
  "outputFormat": "text"
}

{
  "backupFilePath": "/backup/production_backup.sql",
  "deepValidation": true,
  "validateStructure": true,
  "validateData": true,
  "checkCorruption": true,
  "maxSampleSize": 10000,
  "generateReport": true,
  "outputFormat": "json" 
}

{
  "backupFilePath": "/backup/large_backup.sql",
  "deepValidation": false,
  "validateStructure": true,
  "validateData": false,
  "checkCorruption": true,
  "maxSampleSize": 1000,
  "generateReport": false 
}

{
  "query": "SELECT id, name, email, created_at FROM users WHERE status = ?",
  "params": ["active"]
}

{
  "query": "SELECT * FROM orders WHERE order_date >= ?",
  "params": ["2024-01-01"],
  "format": "csv",
  "maxRows": 500000,
  "fileName": "orders_2024"
}

{
  "query": "SELECT product_id, name, price, inventory FROM products",
  "format": "json",
  "includeHeaders": false,
  "outputDir": "/api/data"
}

{
  "query": "SELECT * FROM large_dataset",
  "withProgress": true,
  "enableCancellation": true,
  "maxRows": 1000000
}

{
  "query": "SELECT * FROM analytics_data",
  "useQueue": true,
  "priority": 5,
  "immediateReturn": true,
  "fileName": "analytics_report"
}

{
 "query": "SELECT * FROM critical_data",
 "withRecovery": true,
 "retryCount": 3,
 "exponentialBackoff": true,
 "fallbackFormat": "csv",
 "reducedBatchSize": 5000
}

{
 "query": "SELECT customer_id, order_total, order_date FROM customer_orders",
 "format": "excel",
 "sheetName": "CustomerOrders",
 "includeHeaders": true,
 "fileName": "customer_analysis_Q1"
}

{
  "query": "SELECT * FROM enterprise_logs WHERE timestamp >= ? AND timestamp <= ?",
  "params": ["2024-01-01 00:00:00", "2024-01-31 23:59:59"],
  "format": "csv",
  "maxRows": 5000000,
  "withRecovery": true,
  "withProgress": true,
  "useQueue": true,
  "priority": 10,
  "fileName": "enterprise_logs_january"
}

{
  "table_name": "users",
  "file_path": "/data/users.csv",
  "format": "csv",
  "has_headers": true,
  "field_mapping": {
    "姓名": "name",
    "邮箱": "email",
    "年龄": "age"
  },
  "batch_size": 500,
  "use_transaction": true,
  "validate_data": true,
  "skip_duplicates": false,
  "conflict_strategy": "error"
}

{
  "table_name": "products",
  "file_path": "/data/products.json",
  "format": "json",
  "field_mapping": {
    "productName": "name",
    "productPrice": "price",
    "inventory": "stock"
  },
  "batch_size": 1000,
  "use_transaction": false,
  "with_progress": true,
  "validate_data": true
}

{
  "table_name": "orders",
  "file_path": "/data/orders.xlsx",
  "format": "excel",
  "sheet_name": "Sheet1",
  "has_headers": true,
  "field_mapping": {
    "订单号": "order_id",
    "金额": "amount",
    "日期": "created_at"
  },
  "use_transaction": true,
  "with_recovery": true,
  "validate_data": true
}

{
  "table_name": "backup_data",
  "file_path": "/data/backup.sql",
  "format": "sql",
  "use_transaction": true,  // SQL语句批量执行在一个事务中
  "with_recovery": true
}

{
  "title": "月度销售报表",
  "queries": [
    {
      "name": "销售总览",
      "query": "SELECT SUM(amount) FROM sales WHERE month = ?",
      "params": ["2023-12"]
    }
  ],
  "includeHeaders": true,
  "fileName": "monthly_sales_report"
}

{
  "scope": "full",
  "includeDetails": true
}

{
  "scope": "connection",
  "includeDetails": false
}

{
  "scope": "export",
  "includeDetails": true
}

{
  "scope": "queue",
  "includeDetails": true
}

{
  "scope": "memory",
  "includeDetails": true
}

{
  "scope": "full",
  "includeDetails": false
}

{
  "scope": "full",
  "includeDetails": true
}

{
  "scope": "connection",
  "includeDetails": true
}

{
 "error_message": "Access denied for user 'root'@'localhost' (using password: YES)",
 "operation": "connection"
}

{
 "error_message": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELEC * FROM users' at line 1",
 "operation": "query"
}

{
 "error_message": "Cannot delete or update a parent row: a foreign key constraint fails (`shop`.`orders`, CONSTRAINT `fk_orders_customer` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`))",
 "operation": "dml"
}

{
 "error_message": "Table 'database.users' doesn't exist",
 "operation": "query"
}

{
 "error_message": "Duplicate entry 'john@example.com' for key 'email'",
 "operation": "dml"
}

{
 "error_message": "SELECT command denied to user 'readonly'@'localhost' for table 'sensitive_data'",
 "operation": "security"
}

{
 "error_message": "Query execution was interrupted, maximum statement execution time exceeded",
 "operation": "query"
}

{
 "error_message": "Lock wait timeout exceeded; try restarting transaction",
 "operation": "dml"
}

{
 "error_message": "Incorrect integer value: 'abc' for column 'user_id' at row 1",
 "operation": "dml"
}

{}

{
  "action": "list"
}

{
  "action": "list",
  "operationType": "backup",
  "detailLevel": "detailed"
}

{
  "action": "get",
  "trackerId": "backup_123456"
}

{
  "action": "cancel",
  "trackerId": "export_789012"
}

{
  "action": "summary"
}

{
  "action": "list",
  "includeCompleted": true,
  "detailLevel": "detailed"
}

{
  "action": "list",
  "operationType": "export",
  "detailLevel": "detailed"
}

{
  "action": "summary"
}

{
  "action": "list",
  "detailLevel": "detailed"
}

{
 "action": "status"
}

{
 "action": "cleanup"
}

{
 "action": "optimize",
 "forceGC": true
}

{
 "action": "configure",
 "enableMonitoring": true,
"maxConcurrency": 3
}

{
 "action": "report",
 "includeHistory": true
}

{
 "action": "gc"
}

{
 "action": "optimize",
 "forceGC": false
}

{
 "action": "status"
}

{
 "action": "cleanup"
}

{
 "action": "report",
 "includeHistory": true
}

{
  "action": "status",
  "showDetails": true
}

{
  "action": "status",
  "showDetails": true
}

{
  "action": "status",
  "filterType": "backup",
  "showDetails": true
}

{
  "action": "pause"
}

{
  "action": "resume"
}

{
  "action": "clear"
}

{
  "action": "set_concurrency",
  "maxConcurrency": 5
}

{
  "action": "cancel",
  "taskId": "backup_123456"
}

{
  "action": "diagnostics"
}

{
  "action": "get_task",
  "taskId": "export_789012"
}

{
  "action": "status",
  "showDetails": true
}

{
  "action": "pause"
}

{
  "action": "clear"
}

{
  "action": "set_concurrency",
  "maxConcurrency": 3
}

{
  "action": "diagnostics"
}

// 创建普通索引
{
  "action": "create",
  "table_name": "users",
  "index_name": "idx_users_email",
  "columns": ["email"]
}

// 创建复合索引
{
  "action": "create",
  "table_name": "orders",
  "index_name": "idx_orders_user_date",
  "columns": ["user_id", "created_at"]
  }

// 创建唯一索引
{
  "action": "create",
  "table_name": "products",
  "index_name": "idx_products_sku",
  "index_type": "UNIQUE",
  "columns": ["sku"]
}

// 删除索引
{
  "action": "drop",
  "table_name": "users",
  "index_name": "idx_users_email",
  "if_exists": true
}

// 分析索引使用情况
{
  "action": "analyze",
  "table_name": "users"
}

// 优化索引结构
{
  "action": "optimize",
  "table_name": "users"
}

// 列出表的所有索引
{
  "action": "list",
  "table_name": "users"
}

// 列出数据库中所有表的索引
{
  "action": "list"
}

// 创建新用户
{
  "action": "create",
  "username": "newuser",
  "password": "secure_password",
  "host": "localhost"
}
 
// 删除用户
{
  "action": "delete",
  "username": "olduser",
  "if_exists": true
}

// 授予权限
{
  "action": "grant",
  "username": "appuser",
  "privileges": ["SELECT", "INSERT", "UPDATE"],
  "database": "myapp",
  "table": "users"
}
 
// 撤销权限
{
  "action": "revoke",
  "username": "appuser",
  "privileges": ["DELETE"],
  "database": "myapp"
}
 
// 列出所有用户
{
  "action": "list"
}

// 显示用户权限
{
  "action": "show_grants",
  "username": "appuser"
}

// 查看复制状态概览
{
  "action": "status"
}

// 检测复制延迟
{
  "action": "delay"
}

# 连接到 Claude Desktop 并使用以下示例：

# 查询用户数据
{
  "query": "SELECT id, name, email, created_at FROM users WHERE status = 'active' ORDER BY created_at DESC LIMIT 10",
  "params": []
}

# 获取表结构
{
  "table_name": "orders"
}

# 带参数的复杂连接查询
{
  "query": "SELECT u.name, COUNT(o.id) as order_count, SUM(o.total) as total_spent FROM users u LEFT JOIN orders o ON u.id = o.user_id WHERE u.created_at > ? GROUP BY u.id HAVING order_count > 0 ORDER BY total_spent DESC",
  "params": ["2023-01-01"]
}

# 插入新用户
{
  "table_name": "users",
  "data": {
    "name": "Alice Johnson",
    "email": "alice@example.com",
    "status": "active"
  }
}

# 更新用户状态
{
  "table_name": "users",
  "data": {
    "status": "inactive"
  },
  "where_clause": "email = 'john@example.com'"
}

# 删除用户
{
  "table_name": "users",
  "where_clause": "id = 123"
}

# 批量事务示例
{
  "queries": [
    {"sql": "INSERT INTO users (name, email) VALUES (?, ?)", "params": ["Alice Johnson", "alice@example.com"]},
    {"sql": "INSERT INTO profiles (user_id, bio) VALUES (LAST_INSERT_ID(), ?)", "params": ["Software Engineer"]},
    {"sql": "UPDATE user_stats SET total_users = total_users + 1"}
  ]
}

# 批量插入示例
{
  "table_name": "products",
  "data": [
    {"name": "Laptop Pro", "price": 1299.99, "category": "Electronics", "stock": 50},
    {"name": "Wireless Mouse", "price": 29.99, "category": "Electronics", "stock": 200},
    {"name": "Office Chair", "price": 199.99, "category": "Furniture", "stock": 25}
  ]
}

# 获取全面的系统状态
{
  "scope": "full",
  "includeDetails": true
}

# 内存优化和分析
{
  "action": "optimize",
  "forceGC": true,
  "includeHistory": true
}

# 队列管理
{
  "action": "status",
  "showDetails": true,
  "filterType": "all"
}

# 进度跟踪
{
  "action": "summary"
}

# 安全审计
{} # 无需参数

MySQLManager (中央引擎) - mysqlManager.ts
├── 配置管理层 - config.ts
│   ├── ConfigurationManager             # 中央配置管理
│   ├── DatabaseConfig                   # 数据库连接配置
│   ├── SecurityConfig                   # 安全配置管理
│   └── CacheConfig                      # 缓存配置管理
├── 数据访问层
│   ├── ConnectionPool                   # 增强连接池管理 - connection.ts
│   │   ├── preCreateConnections()       # 预创建连接
│   │   ├── performHealthCheck()         # 健康检查
│   │   └── adjustPoolSize()             # 动态调整池大小
│   └── SmartCache                       # 三级LRU缓存系统 - cache.ts
│       ├── SchemaCache                  # 表结构缓存 (128条目)
│       ├── TableExistsCache             # 表存在性缓存 (64条目)
│       └── IndexCache                   # 索引信息缓存 (64条目)
├── 安全防护层
│   ├── SecurityValidator                # 安全验证器 - security.ts
│   │   ├── validateInputComprehensive() # 全面输入验证
│   │   └── analyzeSecurityThreats()     # 威胁分析
│   ├── RBACManager                      # 权限管理 - rbac.ts
│   │   ├── checkPermission()            # 权限检查
│   │   └── assignRoleToUser()           # 角色分配
│   ├── AdaptiveRateLimiter              # 自适应速率限制 - rateLimit.ts
│   │   └── checkRateLimit()             # 令牌桶算法限流
│   └── SecurityAuditor                  # 安全审计员 - security.ts
├── 监控分析层
│   ├── PerformanceManager               # 性能管理器 - performanceManager.ts
│   │   ├── SlowQueryAnalysis            # 慢查询分析
│   │   ├── IndexOptimization            # 索引优化建议
│   │   └── QueryProfiling               # 查询性能剖析
│   ├── MetricsManager                   # 指标管理器 - metrics.ts
│   │   ├── TimeSeriesMetrics            # 时间序列指标
│   │   ├── PerformanceMetrics           # 性能指标
│   │   └── recordQueryTime()            # 查询时间记录
│   ├── MemoryMonitor                    # 内存监控 - monitor.ts
│   │   ├── getMemoryStats()             # 内存使用统计
│   │   └── optimizeMemory()             # 内存优化
│   ├── SystemMonitor                    # 系统监控 - monitor.ts
│   │   ├── collectSystemResources()     # 系统资源收集
│   │   └── checkAlerts()                # 告警检查
│   ├── ErrorHandler                     # 错误处理器 - errorHandler.ts
│   │   ├── safeError()                  # 安全错误处理
│   │   └── analyzeError()               # 错误分析
│   └── SmartRetryStrategy               # 智能重试策略 - retryStrategy.ts
├── 备份管理层
│   ├── MySQLBackupTool                  # 备份工具 - mysqlBackupTool.ts
│   │   ├── createBackup()               # 多模式备份
│   │   └── createIncrementalBackup()    # 增量备份
│   ├── MySQLImportTool                  # 导入工具 - mysqlImportTool.ts
│   │   ├── importData()                 # 多格式导入
│   │   └── validateImport()             # 导入验证
│   └── DataExporter                     # 数据导出器 - mysqlBackupTool.ts
├── 系统管理工具 (index.ts中的工具)
│   ├── mysql_system_status              # 系统状态检查
│   ├── mysql_analyze_error              # 错误智能分析
│   ├── mysql_security_audit             # 安全审计
│   ├── mysql_manage_indexes             # 索引管理
│   ├── mysql_manage_users               # 用户管理
│   ├── mysql_replication_status         # 复制状态监控
│   ├── mysql_progress_tracker           # 进度跟踪器
│   └── mysql_optimize_memory            # 内存优化
└── 日志与工具层
    ├── StructuredLogger                 # 结构化日志器
    ├── Constants                        # 常量定义 - constants.ts
    ├── Types                            # 类型定义 - types.ts
    ├── CommonUtils                      # 通用工具 - utils/common.ts
    └── CacheInvalidator                 # 缓存失效器 - utils/cacheInvalidator.ts

{
  "performance_metrics": {
    "performance": {
      "queryCount": 50,
      "totalQueryTime": 2.5,
      "errorCount": 1,
      "slowQueryCount": 3,
      "avg_query_time": 0.05,
      "cache_hit_rate": 0.8
    },
    "cache_stats": {
      "schema_cache": {
        "size": 10,
        "max_size": 100,
        "hit_count": 40,
        "miss_count": 10,
        "hit_rate": 0.8,
        "ttl": 300
      }
    }
  },
  "connection_pool_status": {
    "status": "Healthy",
    "totalConnections": 10,
    "idleConnections": 8,
    "waitingConnections": 0
  }
}

// 配置L2缓存
configureL2Cache(
  enabled: boolean,
  config?: {
    l1Size: number;    // L1缓存大小
    l1TTL: number;     // L1缓存TTL
    l2Size: number;    // L2缓存大小
    l2TTL: number;     // L2缓存TTL
  }
): void

// 基于内存压力调整缓存大小
adjustForMemoryPressure(pressureLevel: number): void {
  const scaleFactor = Math.max(0.1, 1 - pressureLevel);
  this.dynamic_max_size = Math.max(1, Math.floor(this.max_size * scaleFactor));

  while (this.cache.size > this.dynamic_max_size) {
    this.evictLRU();
  }
}

{
  "cache_performance": {
    "global_hit_rate": 0.923,
    "tier_efficiency": {
      "l1_hit_rate": 0.945,
      "l2_hit_rate": 0.678,
      "promotion_rate": 0.234
    },
    "memory_usage": {
      "l1_size": "8.2 MB",
      "l2_size": "4.1 MB",
      "total_memory": "12.3 MB",
      "compression_ratio": 0.85
    },
    "advanced_metrics": {
      "prefetch_accuracy": 0.789,
      "ttl_adjustment_rate": 0.156,
      "weakmap_protection": 0.923,
      "eviction_efficiency": 0.867
    }
  },
  "region_stats": {
    "SCHEMA": {
      "entries_count": 45,
      "max_entries": 128,
      "hit_rate": 0.956,
      "memory_usage": "2.3 MB",
      "avg_access_time": "0.03ms",
      "prefetch_count": 23,
      "ttl_extensions": 156
    },
    "TABLE_EXISTS": {
      "entries_count": 78,
      "max_entries": 64,
      "hit_rate": 0.912,
      "avg_lookup_time": "0.05ms",
      "weakmap_protected": true
    },
    "INDEX": {
      "entries_count": 23,
      "max_entries": 64,
      "hit_rate": 0.885,
      "last_refresh": "2025-09-03T08:26:00Z",
      "warm_up_time": "45ms"
    }
  }
}

// 获取详细缓存分析
const analysis = cache.getDetailedAnalysis();

// 分析访问模式
const patterns = cache.analyzeAccessPatterns();

// 获取优化建议
const recommendations = cache.getOptimizationRecommendations();

// 执行智能清理
const cleanupResult = cache.performIntelligentCleanup();

// 订阅内存压力变化
memoryPressureManager.subscribe((pressure: number) => {
  cache.adjustForMemoryPressure(pressure);
});

// 获取缓存健康状态
const health = cache.getHealthStatus();
console.log(`缓存健康度: ${health.score}/100`);

# 高性能环境的环境变量配置
SMART_CACHE_L1_SIZE=256
SMART_CACHE_L2_SIZE=128
CACHE_TTL_BASE=600
CACHE_TTL_MAX=3600
PREFETCH_ENABLED=true
PREFETCH_THRESHOLD=0.7
TTL_DYNAMIC_ADJUSTMENT=true
WEAKMAP_PROTECTION=true

# 内存受限环境的环境变量配置
SMART_CACHE_L1_SIZE=64
SMART_CACHE_L2_SIZE=32
CACHE_TTL_BASE=300
CACHE_COMPRESSION=true
COMPRESSION_LEVEL=6
AGGRESSIVE_EVICTION=true
WEAKMAP_PROTECTION=true

{
  "security_analysis": {
    "threat_level": "LOW",
    "detected_patterns": [],
    "risk_score": 0.1,
    "recommendations": [
      "输入验证通过了所有安全检查"
    ],
    "blocked_attempts": 0,
    "validation_time": "0.8ms"
  }
}

{
  "memory_analysis": {
    "current_stats": {
      "heap_used": "45.2 MB",
      "heap_total": "64.0 MB",
      "rss": "85.7 MB",
      "external": "2.1 MB",
      "peak_heap": "52.1 MB",
      "average_heap": "42.8 MB",
      "trend": "stable"
    },
    "optimization": {
      "canOptimize": true,
      "potentialSavings": "3.2 MB",
      "lastOptimization": 1623456789000,
      "recommendedAction": "内存使用稳定，无需立即操作"
    },
    "gc_stats": {
      "triggered": 5,
      "last_gc": "2023-06-15T10:30:45.123Z",
      "total_freed": "12.5 MB",
      "last_gc_freed": "2.3 MB"
    },
    "pressure_level": 0.42,
    "leak_suspicions": 0,
    "historical_data_points": 100
  }
}

# 安装所有依赖
npm install

# 复制环境模板并配置
cp .env.example .env

# 编译和运行服务器
npm run build
npm start

# 或者使用 ts-node 直接运行进行开发
npm run dev

# 代码格式化和检查
npm run lint
npm run lint:fix

# 类型检查
npx tsc --noEmit

# 测试
npm test
npm run test:unit
npm run test:integration
npm run test:watch
npm run test:coverage

# 可选的性能依赖
# 启用垃圾回收监控 (使用 --expose-gc 标志运行)
node --expose-gc dist/index.js

# 用于增强调试的开发模式
npm run dev -- --expose-gc

# 替代方案: 设置环境变量用于内存监控
export NODE_OPTIONS="--expose-gc"

# 在 .env 文件或环境中设置
LOG_LEVEL=DEBUG

# 在一个终端中运行服务器
npm run dev

# 在另一个终端中，如果记录到文件
# (注意: TypeScript 版本可能默认不记录到文件)