Datalion

DataLion

Use this skill for DataLion project, project-settings, data-import, codebook, chart-table, report, report-tab, dashboard, and export workflows.

In DataLion, "tab" and "dashboard" are used interchangeably for the report subpages managed under a report.

Default Strategy

1. Verify the datalion MCP server is enabled and inspect which datalion__* tools are actually available in the current session.
2. Use MCP first for supported actions.
3. Do not invent Datalion MCP tools. If a matching tool is missing, switch to a REST or browser/UI path from references/setup-and-capabilities.md.
4. Read first, write second. Restate the exact target object and proposed mutation before calling a write path.

Setup

• Run HybridClaw in host sandbox mode for this local Node-based MCP server.
• Install the bridge dependencies before first use: npm --prefix <path-to-your-datalion-repo>/mcp install
• Keep DATALION_API_TOKEN inside MCP server config env, never in tracked files or chat.
• Use the MCP server name datalion so tools appear as datalion__....
• For hybridclaw gateway mcp add ..., pass the JSON config as one quoted shell argument. In zsh, unquoted {...} and [...] will be expanded before HybridClaw sees them.
• See references/setup-and-capabilities.md for ready-to-paste CLI and TUI examples, dependency notes, and ability requirements.

Working Rules

• Always state whether you are using MCP, REST API, or browser/UI automation.
• Resolve the exact project, report, dashboard, export, or chart before mutating anything.
• The current bridge directly supports project listing, project reads, project creation, project settings updates, data source listing, CSV upload, full Excel/CSV import, report list/create and tab CRUD, chart-table reads, and codebook list, download, generation, deletion, and upload.
• The bridge also exposes 4 browser URL helpers for project/report/dashboard opening and widget insertion.
• The current bridge tool surface has 22 tools total: 18 backend MCP actions and 4 browser URL helpers.
• Prefer datalion__list_projects and datalion__read_project before writes when the exact target project is not already pinned down.
• Treat datalion__upload_data as a data-import tool, not a generic project-update tool.
• Treat datalion__edit_project as a defsettings merge tool. It updates only the keys you pass and keeps the existing settings for all other keys.
• Use datalion__list_data_sources to inspect what is already loaded into a project before uploading or troubleshooting data.
• Prefer datalion__import_excel_data when the source is an .xlsx workbook or when you want Datalion's full import pipeline, including optional codebook generation during import.
• Use datalion__list_codebook when the user needs a question-level inventory; use datalion__download_codebook for the tree structure.
• For workbook imports, prefer an absolute localPath so the bridge can read the file directly.
• For uploads, confirm filename, header and delimiter assumptions, data source name if relevant, and whether existing rows should be truncated.
• For import_excel_data, confirm projectId, file path or base64 file content, filename if you are not using localPath, whether you want the default main data source (useDefaultDataSource=true) or a named data source, and whether replaceData, runCalculations, convertComma, skipLines, comment, and createCodebook should be enabled.
• For project settings edits, confirm the target projectId and the exact defsettings keys and values before calling.
• For chart-table reads, confirm projectId, chartId, and any filter string before calling.
• For codebook uploads, confirm projectId, CSV filename, import mode, and whether any explicit column mapping is needed. The current backend expects columnMapping as an array aligned to the CSV header order.
• For reports, prefer direct MCP coverage first.
• For dashboard and export tasks without direct MCP coverage, inspect the local Datalion repo and its OpenAPI or route definitions before choosing a fallback path.
• Keep tokens, auth headers, and exported files out of logs unless the user explicitly asks for them.

Current MCP Coverage

The current datalion bridge exposes these direct tools:

• datalion__list_projects
• datalion__read_project
• datalion__create_project
• datalion__edit_project
• datalion__list_data_sources
• datalion__upload_data
• datalion__import_excel_data
• datalion__list_reports
• datalion__create_report
• datalion__create_report_tab
• datalion__edit_report_tab
• datalion__delete_report_tab
• datalion__open_project_browser
• datalion__open_report_browser
• datalion__open_dashboard_browser
• datalion__open_add_widget_browser
• datalion__get_chart_table
• datalion__list_codebook
• datalion__download_codebook
• datalion__generate_codebook
• datalion__delete_codebook
• datalion__upload_codebook

That means:

• project discovery and project detail reads are supported directly
• project creation is supported directly
• project settings updates through defsettings merges are supported directly
• project data sources can be listed directly
• CSV-style data import into an existing project is supported directly
• workbook and full-pipeline Excel/CSV import are supported directly
• the full-pipeline import path uses DataLion's datasource service rather than the raw CSV upload path, so it handles type detection, replace/append mode, optional codebook generation, and optional calculations
• report listing and report creation are supported directly
• chart tables can be read directly
• codebooks can be listed, downloaded, generated, deleted, and uploaded directly
• report editing beyond report-tab CRUD, dashboard editing, and export generation require fallback API or UI paths until the bridge grows more tools

Common Workflows

For explicit TUI testing, prefer /skill datalion ....

• /skill datalion create a project named "MCP Smoke Test"
• plain natural-language prompts that mention DataLion also work
• /datalion ... may still be routed as a normal message, but it is not a built-in slash-menu command, so do not use slash-menu visibility as the test for whether the skill is installed

Create a Project

1. Confirm the project name and any optional identcode or defsettings.
2. Call datalion__create_project.
3. Return the new project ID and recommend the next step, usually data import or report/dashboard setup.