lookerctl
全面的CLI,用于大规模管理和优化LookML
快速链接
📚 完整的文件 -从这里开始查看完整文档
快速开始
# 1. Setup environment
source .env
# 2. Test connection
lookerctl test
# 3. Export LookML
lookerctl export all --output-dir ./lookml
# 4. Perform static analysis and validation (fast!)
lookerctl validate static ./lookml
# 5. Analyze usage
lookerctl analyze usage主要特点
- ⚡ 验证速度提高66倍 -使用API对大型查找器实例进行600毫秒与40秒的本地验证
- 🔄 完成本地开发 -出口→ Edit → 验证→ 推送工作流
- 📊 使用分析 -了解用户实际使用的字段
- 🧪 科学测试 -AB测试和黄金信心测试,补充了Looker的内置数据测试
- 🔍 依赖关系映射 -在做出更改之前了解影响
- 🤖 AI就绪 -所有输出均为JSON格式,供AI使用
- 🔌 MCP服务器 -通过模型上下文协议为AI代理提供20个工具
文档
入门指南
参考
示例
- 示例目录 -实际工作示例和模板
示例工作流
地方发展
# Sync with local git branch
lookerctl session sync my-project
# Export to local
lookerctl export project my-project -o ./local
# Make changes
vim ./local/views/users.view.lkml
# Validate (600ms!)
lookerctl validate static ./local
# Push to Looker
lookerctl export push my-project ./localAB测试优化
# Create baseline BEFORE changes
lookerctl query-test baseline create model.explore \
-q query.json -o before.json
# Make optimization changes
# ... optimize SQL, add indexes ...
# Compare AFTER changes
lookerctl query-test baseline compare model.explore \
-b before.json
# Result: ✓ 39% faster with no data changes!使用分析
# Analyze what's being used
lookerctl analyze usage -o usage.json
# Find unused explores
lookerctl analyze unused
# Build dependency graph
lookerctl deps build ./lookml -o deps.json用于AI代理的MCP服务器
# Start MCP server (for Claude Desktop)
lookerctl mcp
# Add to Claude Desktop config:
# {
# "mcpServers": {
# "looker": {
# "command": "/path/tlookerctl",
# "args": ["mcp"],
# "env": { ... }
# }
# }
# }
# Then ask Claude:
# "List all Looker projects"
# "Find unused explores"
# "Analyze dependencies in ./lookml"安装
# 1. Install dependencies
uv pip install -r requirements.txt
# 2. Configure credentials (.env file)
export LOOKERSDK_BASE_URL=https://your-instance.looker.com:443
export LOOKERSDK_CLIENT_ID=your_client_id
export LOOKERSDK_CLIENT_SECRET=your_client_secret
# 3. Test connection
lookerctl test演出
| 操作 | API方法 | 局部图 | 加速 |
|---|---|---|---|
| 验证项目 | 40s | 600ms | 快66倍 |
| 现场发现 | 2s | 100ms | 快20倍 |
| 依赖性检查 | 5s | 50ms | 快100倍 |
建筑
TODO: populate architecture diagram关键命令
# Session management
lookerctl session sync
lookerctl session workspace dev
# Export/Push
lookerctl export all -o ./lookml
lookerctl export push my-project ./lookml
# Validation
lookerctl validate static ./lookml # 600ms
lookerctl validate local my-project ./lookml # 40s, accurate
# Analysis
lookerctl analyze usage
lookerctl deps build ./lookml
# Testing
lookerctl query-test baseline create model.explore -q query.json
lookerctl query-test baseline compare model.explore -b baseline.json
lookerctl query-test golden run用例
对于开发者
- 本地开发工作流程,如Looker控制台
- 迭代过程中的快速验证
- 使用基线进行安全重构
- 变更前的影响分析
对于AI系统
- 配备20个AI代理工具的MCP服务器
- 导出所有LookML进行分析
- 程序化现场发现
- 自动优化和验证
- 改进的科学测试
对于团队
- 对用户创建内容的可见性
- CI/CD与黄金测试的集成
- 随时间推移的性能跟踪
- 自动化优化管道
支持
状态
✅ 生产就绪
- 所有功能均经过端到端测试
- 已验证完整的AB测试工作流程
- 本地验证速度提高66倍
- 全面的文件
- 完全错误处理
______________________________________________________________________
版本: 0.1.0 最后更新: 2025-10-11
有关完整文档,请参阅: docs/README.md
