AB.CD数据库服务平台

GET /health // 响应 { "success": true, "data": { "status": "healthy", "latency_ms": 2.35, "connections": { "total_connections": 5, "available": 3, "in_use": 2, "wait_queue": 0, "max_connections": 20 }, "timestamp": "2026-01-23 10:30:00" } }

GET /stats // 响应 { "success": true, "data": { "system": { "php_version": "8.1.13", "memory_usage": "2.5MB", "peak_memory": "3.2MB", "load_time_ms": 15.23 }, "database": { "total_connections": 5, "available": 3, "in_use": 2, "wait_queue": 0, "max_connections": 10 }, "cache": { "enabled": true, "hits": 156, "misses": 23, "hit_rate": "87.2%" } } }

POST /cache/clear // 响应 { "success": true, "data": { "message": "缓存已清空" } }

GET /tables/users?page=1&limit=20&status=active&order_by=id DESC // 响应 { "success": true, "data": { "data": [...], "pagination": { "page": 1, "limit": 20, "total": 156, "pages": 8 } } }

// 单条插入（支持幂等性保护） POST /tables/users Header: X-Idempotency-Key: unique-request-id { "name": "张三", "email": "zhangsan@example.com", "status": "active" } // 批量插入（不支持幂等性） POST /tables/users [ {"name": "张三", "email": "zhangsan@example.com"}, {"name": "李四", "email": "lisi@example.com"} ] // 响应 { "success": true, "data": { "id": 123, "affected_rows": 1 } }

POST /tables/users/update { "data": { "status": "inactive", "updated_at": "2026-01-23 10:30:00" }, "conditions": { "id": 123 } }

POST /tables/users/delete { "id": 123 } // 或使用IN条件 POST /tables/users/delete { "id": [123, 124, 125] }

POST /schemas/users { "columns": [ { "name": "id", "type": "INT", "attributes": ["AUTO_INCREMENT", "PRIMARY KEY"] }, { "name": "name", "type": "VARCHAR(100)", "attributes": ["NOT NULL"] }, { "name": "email", "type": "VARCHAR(255)", "attributes": ["NOT NULL", "UNIQUE"] }, { "name": "status", "type": "ENUM('active','inactive')", "attributes": ["DEFAULT 'active'"] } ] }

POST /schemas/users/delete // 响应 { "success": true, "data": { "message": "数据表删除成功" } }

POST /query { "sql": "SELECT * FROM users WHERE status = ? LIMIT ?", "params": ["active", 10], "types": "si" }