lucid-skill

AI-native data analysis skill. Connect Excel, CSV, MySQL, PostgreSQL — understand business semantics, query with SQL.

No API key required. No LLM inside — the AI agent is the brain; lucid-skill is the hands.

Features

• Multi-source: Excel (.xlsx/.xls), CSV, MySQL, PostgreSQL — all unified into SQL

• Semantic Layer: Define business meanings for tables and columns; persist as YAML, Git-friendly

• JOIN Discovery: Automatically find join paths between tables (direct + indirect)

• Domain Clustering: Auto-group tables into business domains

• Embedding Search: Optional multilingual vector search for table discovery

• Read-only Safety: Only SELECT allowed — mutating SQL is blocked at the engine level

Related MCP server: mcp-db-server

Install

pip install lucid-skill

# Or with uv (recommended for OpenClaw)
uv tool install lucid-skill

# Optional: database drivers
pip install "lucid-skill[db]"       # MySQL + PostgreSQL

# Optional: embedding search
pip install "lucid-skill[embedding]" # sentence-transformers

Quick Start

# Connect a data source
lucid-skill connect csv /path/to/sales.csv

# Explore schema and semantics
lucid-skill init-semantic

# Search tables by business meaning
lucid-skill search "销售额 客户"

# Query with SQL
lucid-skill query "SELECT product, SUM(amount) FROM sales GROUP BY product ORDER BY 2 DESC LIMIT 10"

Architecture

Agent ──→ lucid-skill CLI ──→ Connectors (Excel/CSV/MySQL/PG)
                │                      │
                ├── Catalog (DuckDB)   └── DuckDB (in-memory query engine)
                └── Semantic Store (YAML)

• No LLM inside — lucid-skill provides data access; the AI agent handles reasoning

• DuckDB unified — catalog storage + query engine, single dependency, no compilation needed

• Semantic persistence — YAML definitions survive restarts, shareable via Git

Supported Data Sources

Environment Variables

Security

• Read-only: Only SELECT / WITH statements are allowed; all mutating SQL is blocked

• No credentials stored: Database passwords are never written to disk

• Local only: All data stays on your machine

MCP Server Mode

lucid-skill also works as an MCP Server for platforms that support it:

lucid-skill serve

Development

git clone https://github.com/WiseriaAI/lucid-skill
cd lucid-skill
pip install -e ".[dev]"
pytest

License

MIT