Analytixus

Analytixus is a platform for metadata-driven development, built around DnAML (Data and Analytics Markup Language) — a domain-specific, JSON-like format for describing data sources, structures, and transformations. Capture metadata from your sources, model it once in DnAML, and generate SQL, pipelines, transformations, and documentation from it — instead of hand-writing and maintaining them separately.

This extension brings the full Analytixus solution workflow to VS Code, as a companion to the existing Windows desktop application, on Windows, macOS, and Linux.

What the extension provides

DnAML language support — syntax highlighting, diagnostics, autocompletion, go-to-definition, and find-references for .dnaml files, as you type.

Solution Explorer — manage a solution's folder structure: create, rename, delete, and clone formulas (XSLTX/PythonX); connect, edit, and synchronize data sources (SQL Server, PostgreSQL, Oracle, Databricks, SAP SuccessFactors, CSV) with the model.

DnAML-Model-Explorer — browse the model assembled from the repository, add or delete objects and sources directly in it.

Build & Clean — generate code from XSLTX/PythonX formulas, with a preview of build candidates and error reporting; clean up build output that's no longer needed.

Best Practice Analyzer — see known issues in the model in a dedicated view, instead of finding them only at runtime.

Metadata import — connect, test, and pull discovered objects directly into the model from SQL Server, PostgreSQL, Oracle, Databricks, SAP SuccessFactors, and CSV files.

Exceptions — override generated code or imported metadata by hand for individual cases, without losing automatic regeneration for everything else.

Preview & documentation — inspect the merged (supervised) metadata and the monolithic DnAML model at any time, generate Metadata.xml/Metadata.json, and generate documentation.

Screenshots

Solution Explorer — adding a source

DnAML-Model-Explorer

XSLTX formula editor

Build

Generating documentation

Generated documentation — overview

Generated documentation — ER diagram

Generated documentation — lineage

Getting started

1. Open a folder in VS Code that isn't yet an Analytixus solution — the Solution Explorer offers to create one there automatically.
2. Connect a source (Add Source...) via the Solution Explorer, or bring an existing .consql/.conpostgresql/… connection file with you.
3. Create formulas (.xsltx/.pyx) via a folder's context menu, build them there, and see the result directly in the DnAML-Model-Explorer.

An existing solution created with the desktop application works unchanged — both frontends operate on the same folder structure.

Requirements

None — the extension ships its own self-contained runtime; nothing else needs to be installed.

For development, packaging, and versioning notes for this extension, see DEVELOPMENT.md in the same folder (not a clickable link here — vsce flags relative Markdown links as potentially broken whenever it can't auto-detect a GitHub/GitLab repository, even when the target ships in the package).