lucid-skill
Connect data → infer semantics → query with natural language → get answers.
All output is JSON unless noted. No API key needed.
Quick Start
lucid-skill connect csv /path/to/sales.csv # Connect data
lucid-skill overview # Check connected sources
lucid-skill search "月度销售额趋势" # Find relevant tables + suggested SQL
lucid-skill query "SELECT month, SUM(amount) FROM sales GROUP BY month" # Execute
Core Commands
| Command | Purpose |
|---|
| --------- | --------- |
overview | Show all connected sources, tables, semantic status |
connect csv/excel/mysql/postgres | Connect a data source |
tables | List all tables with row counts |
describe | Column details + sample data + semantics | profile | Deep stats: null rate, distinct, min/max, quartiles | init-semantic | Export schemas for semantic inference | `update-semantic | ->` | Save semantic definitions (JSON from file or stdin) | | search [--top-k N] | Natural language → relevant tables + JOIN hints + metric SQL | join-paths | Discover JOIN paths between two tables | domains | Auto-discovered business domains | | `query [--format json\ | md\ | csv]` | Execute read-only SQL | serve | Start MCP Server (stdio JSON-RPC) |
For full command reference with all parameters: read references/commands.md Smart Query Pattern (Recommended)When a user asks a data question: lucid-skill search "关键词" — find relevant tables, suggestedJoins, suggestedMetricSqls- If multi-table:
lucid-skill join-paths table_a table_b — get JOIN SQL - Compose SQL from the returned context
lucid-skill query "SELECT ..." — execute and present results
Semantic Layer SetupFirst-time setup to enable intelligent search: lucid-skill init-semantic # Export schemas
# Analyze output → infer business meanings for each column
echo '{"tables":[...]}' | lucid-skill update-semantic - # Save semantics
For JSON schema details: read references/json-schema.md Key Tips- Auto-restore: Previous connections survive restarts. Always
overview first to check existing state. - Read-only: Only SELECT allowed. INSERT/UPDATE/DELETE/DROP are blocked.
- Semantic files: Stored in
~/.lucid-skill/semantic_store/ (YAML, human-readable). - Data directory:
~/.lucid-skill/ (override with LUCID_DATA_DIR env var). - Embedding: Set
LUCID_EMBEDDING_ENABLED=true for better multilingual search (downloads ~460 MB model on first use). - No credentials stored: Database passwords are never written to disk.
- MCP mode:
lucid-skill serve starts stdio JSON-RPC server for MCP integrations.
Detailed References
版本历史
共 1 个版本
-
v2.0.0
当前
2026-05-02 07:00 安全 安全
安全检测
腾讯云安全 (Sanbu)
安全，无风险
查看报告
🔗 相关推荐
ai-intelligence
pskoett 捕获经验教训、错误和纠正，以实现持续改进。使用时机：（1）命令或操作意外失败；（2）用户纠正……
★ 4,058
📥 797,530
developer-tools
steipete 使用 `gh` CLI 与 GitHub 交互，通过 `gh issue`、`gh pr`、`gh run` 和 `gh api` 管理议题、PR、CI 运行及高级查询。
★ 668
📥 323,946
security-compliance
spclaudehome AI智能体技能安全预审工具。安装ClawdHub、GitHub等来源技能前，检查风险信号、权限范围及可疑模式。
★ 1,212
📥 266,328
|
|