
Better OneStream code — static analysis, health grades, and AI-driven development, inside VS Code.
Disclaimer: This extension is an individual contribution to help OneStream consultants based on personal experience with code optimization. It has no affiliation with OneStream Software LLC.
Built for AI agents — MCP & CLI
Almost every feature is reachable from an AI assistant or the command line, not just from a panel. An agent can analyze business rules, generate a documentation pack, compare and import workspace projects, read your error log and profiler sessions, query custom tables, size App Server memory, strip security from an export, and write a complete Excel report.
- Offline by default — no OneStream connection and no credentials required
- Connected tools are opt-in and read-only — credentials stay in the editor and never reach the agent
- GitHub Copilot registers automatically on VS Code 1.111+; Claude Code, Claude Desktop, Codex, Cursor, Windsurf, Cline, Roo Code and Continue connect with a one-time prompt
- Headless too — the same surface runs from the
devtools CLI in any terminal or pipeline, with no VS Code
Code Quality Studio
A static analyzer purpose-built for OneStream business rules, member formulas, confirmation rules, and assemblies.
- 155 checks across SQL, the OneStream platform, and .NET — performance, security, and code quality, plus positive patterns that reward good code
- A+ to E health grades with a breakdown per rule and category
- Analyze XML/ZIP exports, workspace folders, or a connected OneStream application
- Run it anywhere — sidebar Quick Check with one-click AI Fix,
devtools analyze in CI with SARIF output and --baseline gating, or an AI agent applying the same catalog as it writes
Everything else
| Tool |
What it does |
| Business Rules Editor |
Edit rules as XML in Monaco, or as a full .NET project with Git — round-trips to OneStream XML |
| VB.NET IntelliSense |
Completion, hover, go-to-definition, rename and diagnostics — VS Code has no native VB.NET support |
| Workspace Studio |
Workspace objects as Git-friendly projects, round-tripping to import XML |
| Diagnostic Studio |
Data Management sequences, task activity, error logs, profiler |
| Custom Table Studio |
Browse and query custom tables, plus a database health check |
| Documentation Generator |
Turn an application export into a readable Markdown documentation pack |
| Dimension Builder |
Visual dimension metadata editor with CSV import/export |
| Memory Sizing |
Estimate App Server memory from a connection, export, or manual model |
| Other Tools |
Standalone export utilities, including Remove App Security |
Requirements
- VS Code 1.105.1+ or Cursor 3.0.12+
- .NET 10 Runtime (download) — for Code Quality Studio and VB.NET IntelliSense
- Node.js 22+ on your PATH — for the AI agent tools and CLI. The copy inside VS Code is not used.
Learn More
Open the built-in Development Guides in Code Quality Studio for the full documentation set — agent setup, CI integration, and API references. Found a bug? Use Report it in the footer of any tool panel.
Author: Marcio Pataca
License: MIT
| |