OneStream Code Utility
Stop wasting 8+ hours per week switching between tools. Debug, query, and deploy OneStream applications without leaving VS Code.
500+ OneStream developers trust this extension. Join them today.
🤖 NEW: AI-Powered Workflows with Claude Code
Use natural language to interact with OneStream:
"Check error logs for any issues in the last hour"
"Pull all Finance rules modified this week"
"Show me all users who logged in today"
"Generate documentation for my business rules"
The OneStream MCP Server enables AI assistants like Claude Code to execute SQL queries, manage business rules, check error logs, and more—all through natural language.
Setup Guide → | Full API Reference →
💰 The Real Cost of Context Switching
If you're a OneStream developer making $75/hour, every week you lose:
- 2 hours switching between Business Rule Editor, error logs, SQL tools
- 3 hours waiting for exports, imports, and deployments
- 2 hours debugging production issues across multiple interfaces
- 1 hour managing file versions and Git conflicts
That's $600/week in lost productivity = $31,200/year.
OneStream Code Utility recovers that time for $4.95/month.
🎯 Real Developer, Real Results
"I used to spend 30 minutes every morning checking production error logs, then another hour when issues came up. Now I see errors in real-time in VS Code. Saved me 6 hours last week alone."
— Senior OneStream Developer at Fortune 500 Financial Services Firm
"The SQL Query Editor with schema explorer is a game-changer. I can test data transformations instantly without opening SQL Management Studio."
— OneStream Consultant, Big 4 Accounting Firm
⚡ See the Difference
❌ Before OneStream Code Utility
Scenario: User reports a calculation error in a Finance Rule
- Open OneStream web interface (load time: 30s)
- Navigate to error logs (4 clicks, 20s)
- Find relevant error (scroll, search: 2 min)
- Copy stack trace
- Open SQL Management Studio (30s)
- Write diagnostic query (2 min)
- Find the issue
- Switch to Business Rule Editor (30s)
- Export rule to XML (1 min)
- Open in text editor (30s)
- Make changes
- Import back to OneStream (1 min)
- Test and verify
Total time: 12-15 minutes per issue
✅ After OneStream Code Utility (Premium)
Same scenario with OneStream Code Utility:
- See real-time error notification in VS Code status bar
- Click error → view full stack trace (2 seconds)
Cmd+Shift+Q → SQL Query Editor opens with schema IntelliSense- Run diagnostic query (30 seconds)
- Edit rule directly in VS Code with C# IntelliSense (2 min)
- Generate XML deployment package (10 seconds)
- Deploy and verify
Total time: 3-4 minutes per issue
You just saved 10 minutes. Do this 10x per day = 100 minutes saved daily.
🚀 Premium Features That Pay for Themselves in 10 Minutes
1. Real-Time Error Monitoring
- Errors appear in VS Code the moment they happen in OneStream
- Full stack traces with one click
- Filter by user, application, or time period
- No more logging into web interface just to check logs
Time saved: 5-10 minutes per error investigation
2. SQL Query Editor with Schema Explorer
- Full database schema IntelliSense (tables, columns, stored procedures)
- Run queries against Framework, Application, or external databases
- Query history with search and re-run capability
- Results exported to CSV instantly
- Safety checks prevent accidental data deletion
Time saved: 15-20 minutes per day testing queries
3. Rule Synchronization
- Pull any rule from OneStream database to your local workspace
- Check sync status before deploying (avoid overwriting changes)
- Team collaboration without conflicts
- Complete Git integration for version control
Time saved: 10-15 minutes per deployment cycle
4. C# IntelliSense for OneStream APIs ⭐ NEW
- Full autocomplete for
BRApi, SessionInfo, api, si
- All OneStream types and methods
- Version-specific IntelliSense (7.4, 8.0, 9.0+)
- No more switching to OneStream docs
- Catch errors before deployment
Time saved: 20-30 minutes per day (fewer runtime errors, faster coding)
5. AI Assistant Integration (Beta)
- Auto-generates CLAUDE.md documentation for AI pair programming
- Your AI assistant understands OneStream context
- Faster onboarding for new developers
Time saved: Variable, but huge for complex troubleshooting
📊 Feature Comparison
| Feature |
Free |
Premium |
| Import/Export Business Rules |
✅ |
✅ |
| XML Generation |
✅ |
✅ |
| Smart File Organization |
✅ |
✅ |
| Git Integration |
✅ |
✅ |
| Real-Time Error Logs |
❌ |
✅ |
| SQL Query Editor |
❌ |
✅ |
| Database Schema IntelliSense |
❌ |
✅ |
| Rule Sync (Pull from Database) |
❌ |
✅ |
| Multi-Environment Support |
❌ |
✅ |
| C# IntelliSense (BRApi, etc.) |
❌ |
✅ |
| Query History |
❌ |
✅ |
| AI Assistant CLAUDE.md |
❌ |
✅ |
| Priority Support |
❌ |
✅ |
💡 Who This Is For
Perfect for:
- Senior OneStream Developers who debug production issues daily
- Consultants managing multiple client environments
- Development Teams who need version control and collaboration
- Solo Developers tired of juggling 5+ tools simultaneously
- Anyone who values their time at more than $4.95/month
You'll Love This If:
- ✅ You open SQL Management Studio multiple times per day
- ✅ You've ever lost work because someone overwrote your rule
- ✅ You debug OneStream errors more than once a week
- ✅ You wish BRApi had autocomplete
- ✅ You use Git for everything else (why not OneStream?)
🎁 Start Your 14-Day Free Trial
Full premium access. Cancel anytime during trial - no charge if you cancel.
Get Started in 2 Minutes:
Install the Extension
Start Free Trial
- Click the OneStream icon in sidebar
- Click "Start Free Trial" button
- Enter your email → Instant activation
Connect to OneStream
- Click connection status in bottom bar
- Enter OneStream URL and credentials
- Select application → You're ready
Try Premium Features
Cmd+Shift+Q (Mac) or Ctrl+Shift+Q (Windows) → SQL Query Editor- Click error icon in status bar → Real-time error logs
- Right-click any rule → Pull from Database
After 14 days, you'll only be charged if you haven't cancelled. Try it risk-free.
Start Your Free Trial Now →
🛠️ Installation
VS Code
- Open VS Code
- Press
Ctrl+Shift+X (Windows/Linux) or Cmd+Shift+X (Mac)
- Search "OneStream Code Utility"
- Click Install
- Click the OneStream icon in the sidebar
Cursor IDE
- Open Cursor
- Press
Ctrl+Shift+X
- Search "OneStream Code Utility"
- Click Install
- Works exactly like VS Code
📖 Quick Start Guide
Free Features (No Trial Needed)
Import OneStream Rules:
- Click OneStream icon in sidebar
- Click "Import Files" button
- Select XML or ZIP file from OneStream export
- Files automatically organized by rule type
Export to XML:
- Select rules in OneStream explorer
- Right-click → "Generate XML from Selected Files"
- XML files created in
./GeneratedXML folder
Setup Git:
- Command Palette → "OneStream: Setup Folder Structure"
- Creates OneStream-friendly folder layout
- Command Palette → "OneStream: Check .gitignore Recommendations"
- Adds recommended Git ignore patterns
Premium Features (14-Day Free Trial)
View Error Logs:
- Connect to OneStream environment
- Click error log icon in status bar (or
Cmd+Shift+E)
- Filter by user, app, time
- Click any error to see full stack trace
Run SQL Queries:
- Press
Cmd+Shift+Q (Mac) or Ctrl+Shift+Q (Windows)
- Select connection (Framework, Application, etc.)
- Type query (schema IntelliSense appears automatically)
- Press
Run Query or Cmd+Enter
- Export results to CSV if needed
Pull Rules from Database:
- Right-click any rule → "Pull Rule from Database"
- Or click "Pull All Unencrypted Rules" button
- Compares local vs server versions
- Updates local file with server version
Enable C# IntelliSense:
- Command Palette → "OneStream: Setup C# IntelliSense"
- Select OneStream version (7.4, 8.0, etc.)
- Point to OneStream DLL directory
- Start typing
api. or BRApi. → See autocomplete magic
💼 Pricing & Plans
Free Forever
$0/month
Perfect for occasional OneStream work:
- Import/export business rules
- XML generation and packaging
- File organization by rule type
- Git integration setup
- Community support (Discord)
Premium
$4.95/month (billed monthly, cancel anytime)
Everything in Free, plus:
- ⚡ Real-time error log monitoring
- 🗃️ SQL Query Editor with schema IntelliSense
- 🔄 Rule synchronization (pull from database)
- 🌍 Multi-environment support (dev, test, prod)
- 💻 C# IntelliSense (BRApi, SessionInfo, all OneStream APIs)
- 📜 Query history with search
- 🤖 AI Assistant integration (CLAUDE.md)
- 🎟️ Priority email support
- 🚀 Early access to new features
ROI Calculator:
- If you save just 20 minutes per week = 1.4 hours/month
- At $75/hour = $105/month value
- Premium costs $4.95/month = 21x return on investment
Enterprise
Custom pricing for teams
Contact us for:
- Team licenses (volume discounts)
- Custom integrations
- Dedicated support
- Training sessions
- On-premise license server
View Pricing Details →
🔒 Security & Privacy
We take security seriously:
- ✅ All data stays on your machine - No code or rules sent to external servers
- ✅ Encrypted HTTPS connections - All OneStream connections use TLS
- ✅ Token-based authentication - No passwords stored locally
- ✅ No telemetry or tracking - We don't collect usage data
- ✅ Open source friendly - Inspect the code yourself
- ✅ License validation only - Only your email and license key are sent to our server
Your OneStream data never leaves your network.
📚 Documentation & Support
Free Resources
Premium Support
- 📧 Priority email support (response within 24 hours)
- 🎯 Feature requests prioritized
- 🚀 Early access to beta features
❓ FAQ
Q: Does the free version expire?
A: No! Free features are free forever. No trial, no expiration.
Q: What happens after the 14-day trial?
A: If you don't cancel, you'll be charged $4.95/month. Cancel anytime during the trial to avoid charges. Free features always work regardless.
Q: Can I cancel anytime?
A: Yes! Cancel through the license portal anytime. No questions asked.
Q: Do you support team/enterprise licenses?
A: Yes! Contact us for volume pricing. Teams of 5+ get discounts.
Q: Does this work with Cursor IDE?
A: Yes! Cursor uses VS Code engine. Full compatibility.
Q: Which OneStream versions are supported?
A: OneStream 7.0+ is supported. IntelliSense works with 7.4, 8.0, and 9.0+.
Q: Can I use this offline?
A: Free features work offline. Premium features require network access to OneStream environment.
Q: Will this slow down VS Code?
A: No. The extension is highly optimized and uses minimal resources.
Q: Can multiple developers share one license?
A: No. Each developer needs their own license. We offer team discounts for 5+ licenses.
Q: What if I have a problem during the trial?
A: Join our Discord or email us. We respond quickly to trial users.
🎯 Common Use Cases
Use Case 1: Emergency Production Debugging
Scenario: CFO reports incorrect consolidation numbers. Deadline: 2 hours.
Without Premium:
- Log into OneStream web interface
- Navigate to error logs
- Search through hundreds of errors
- Copy stack traces to text file
- Open SQL Management Studio
- Write queries to investigate data
- Export business rule
- Debug in text editor
- Re-import, test, repeat
- Total time: 1.5-2 hours (if you're lucky)
With Premium:
- See error notification in VS Code immediately
- Click to view full stack trace (5 seconds)
Cmd+Shift+Q → Run SQL diagnostic queries with schema IntelliSense (2 min)- Edit rule directly in VS Code with C# IntelliSense (5 min)
- Generate XML deployment package (10 seconds)
- Test and deploy
- Total time: 15-20 minutes
Time saved: 1+ hour when you need it most
Use Case 2: Daily Development Workflow
Scenario: Building new Finance Rule with complex SQL logic
Without Premium:
- Write code in Business Rule Editor (no IntelliSense)
- Guess at BRApi method names (or search docs)
- Save rule, log out
- Open SQL Management Studio
- Test query logic
- Switch back to Business Rule Editor
- Make changes, save
- Repeat 10-20 times per day
- Wasted time: 2-3 hours daily
With Premium:
- Write code in VS Code with full C# IntelliSense
api. → See all available methods instantlyCmd+Shift+Q → Test SQL queries without leaving VS Code- Schema IntelliSense shows table/column names
- Edit, test, refine in one interface
- Wasted time: 20-30 minutes daily
Time saved: 1.5-2 hours per day = 7-10 hours per week
Use Case 3: Team Collaboration
Scenario: 3 developers working on the same application
Without Premium:
- Developer A edits Finance Rule, exports XML
- Developer B edits same rule (doesn't know A changed it)
- Developer B deploys, overwrites A's work
- A's changes are lost
- Conflict resolution takes hours
- No version history, no audit trail
With Premium + Git:
- All developers pull rules from OneStream database
- Each works in their own Git branch
- Check sync status before deploying
- Merge changes using Git workflows
- Complete audit trail of who changed what
- No more lost work, no more conflicts
Time saved: Countless hours of frustration + rework
🚀 What's Next?
Roadmap (Coming Soon)
- ✅ C# IntelliSense (Shipped in v5.2!)
- 🔄 Push rules to database (temporarily disabled, returning Q2 2025)
- 📊 Performance profiling for Finance Rules
- 🧪 Automated testing framework integration
- 📱 Mobile app for error monitoring
- 🔗 Slack/Teams integration for error notifications
- 🎨 Custom themes and layouts
- 📈 Analytics dashboard (rule complexity, execution time)
Premium subscribers get early access to all new features.
Join 500+ OneStream developers:
📦 System Requirements
- VS Code: Version 1.60.0 or higher
- Cursor IDE: Any version
- OneStream: Version 7.0 or higher (for premium features)
- Network: Access to OneStream environment (for premium features)
- OS: Windows, macOS, or Linux
📄 License & Legal
- Extension: MIT License
- Premium features: Subscription required
- No affiliation with OneStream Software LLC
- OneStream® is a registered trademark of OneStream Software LLC
Independent tool not affiliated with OneStream Software LLC. OneStream® is a registered trademark of OneStream Software LLC.
