Ajackus collaborated with VTS to build VTS Analyst, an AI-powered conversational interface that translates natural language questions into instant market insights—eliminating the need for SQL expertise and democratising data access for commercial real estate professionals.
Engagement Model
Team Augmentation
Your team, supercharged — every Ajackus engineer comes AI-native, shipping 40–60% faster from day one
Managed Delivery
Tell us the problem. We handle everything — discovery, architecture, build, testing, deployment — at AI speed
BOT Model
We build your offshore engineering center with AI-trained teams, operate it to maturity, then transfer ownership to you
Expertise
AI Development
Custom AI agents, LLM integrations, RAG pipelines, and AI enablement — from strategy to production
Web Development
Enterprise web applications built with AI-augmented engineering for 40-60% faster delivery
Mobile Development
Native and cross-platform mobile apps built at AI pace with rigorous automated quality
DevOps
Infrastructure that scales automatically, deploys safely, and costs less
Low-Code/No-Code
Airtable, Glide, Shopify, and WordPress solutions with AI automation layers — built in days
Data Analytics
Turn raw data into decisions that drive revenue — 80% faster with AI-assisted analytics
UI/UX Design
User-centered interfaces designed with AI-powered speed — 3x faster iteration, sharper insights
How VTS Transformed Market Analysis from Hours to Under 10 Seconds with AI-Powered Intelligence
Services
Generative and Agentic AI Development
Web Development
Data Analytics
Technologies
<10s
Query Response Time
Hours→0
Analysis Time Reduction
Zero SQL
Required for Deep Insights
Overview
Executive Summary
Client Overview
The Challenge
Project Goals
Our Approach
Results and Impact
Frequently Asked Questions
Executive Summary
The Problem
Commercial real estate professionals needed hours of manual analysis to extract market insights, and accessing deep data required SQL expertise—effectively locking non-technical users out of data-driven decision-making. Delayed responses to market opportunities and a lack of contextual intelligence for asset benchmarking were direct consequences.
The Solution
Ajackus collaborated with VTS to build VTS Analyst, an AI-powered conversational interface embedded in the VTS platform. The system uses Snowflake Cortex for natural-language-to-SQL translation, n8n for intelligent workflow orchestration, AWS Bedrock for response humanisation, and Auth0 for enterprise-grade multi-layer security.
The Result
Complex market analysis that previously took hours is now completed in under 10 seconds. Non-technical users can access deep market insights independently, the system delivers high-accuracy SQL generation validated by a rigorous QA scoring system, and the tool launched in limited availability in September 2025.
Client Overview
VTS is the leading technology platform for commercial real estate, managing billions of square feet of assets globally. The platform centralises critical data and workflows, enabling landlords and brokers to make faster, data-driven decisions about their portfolios.
As VTS continues to innovate, the company focuses on eliminating friction in the deal-making process through intelligent automation. VTS Analyst represents the next frontier: bringing AI-powered market intelligence directly into the hands of every CRE professional, regardless of their technical background.
| Industry | Commercial Real Estate (PropTech) |
| Platform Scale | Billions of sq. ft. under management |
| Product | VTS Analyst (AI Market Intelligence) |
| Launch | September 2025 (Limited Availability) |
| Partnership | Long-term collaboration with Ajackus |
The Challenge
THE BOTTOM LINE
CRE professionals needed instant, natural-language access to deep market intelligence—but getting it required hours of manual analysis and SQL expertise that most users didn’t have.
Commercial real estate professionals faced significant barriers to accessing the critical market intelligence they needed to make timely, informed decisions.
Core Pain Points
- Time-intensive manual analysis: Extracting meaningful market insights required hours of work across fragmented data sources, delaying responses to market opportunities.
- Technical expertise gap: Deep data analysis required SQL knowledge, effectively locking non-technical users—brokers, landlords, asset managers—out of data-driven decision-making.
- Lack of contextual intelligence: Professionals couldn’t easily benchmark assets against market trends or get contextual answers about their specific portfolio without involving data teams.
- Dependency on data teams: Every analytical question required a request to a data analyst, creating bottlenecks and delays that slowed deal velocity across the organisation.
Project Goals
The project aimed to build an AI-powered conversational intelligence layer that could democratise access to VTS’s market data—making deep analysis available to every user in seconds, not hours.
| Goal | Success Criteria |
|---|---|
| Eliminate the SQL barrier | Natural language queries translated to accurate SQL automatically |
| Sub-10-second response time | First-time queries processed in under 10 seconds; instant for cached queries |
| Democratise data access | Non-technical users access deep insights independently |
| Enterprise-grade security | Multi-layer authentication with role-based data access controls |
| High-fidelity outputs | Accurate SQL generation with humanised natural language summaries |
| Seamless platform integration | Embedded directly into VTS Core Monolith (VCM) |
Our Approach
Ajackus collaborated with VTS to architect and build VTS Analyst as an AI-powered conversational interface embedded directly into the VTS platform. The solution comprised three core technical workstreams.
Natural Language to SQL with Snowflake Cortex
The core of the solution leverages Snowflake Cortex Analyst to translate natural language user queries directly into accurate SQL. Users can ask questions like “What are the rent trends in Midtown Manhattan?” and receive data-driven answers instantly, without writing a single line of code. Cortex Analyst integrates natively with VTS’s semantic data models, delivering low-latency Text-to-SQL generation that maintains high accuracy across complex market intelligence queries.
Intelligent Orchestration via n8n
Ajackus implemented n8n as the workflow orchestration layer, managing the complex pipeline from user query to final response. This includes request validation that enriches prompts with page-level context, response humanisation using AWS Bedrock and LiteLLM to transform raw SQL results into clear natural language summaries, and a robust error-handling system with graceful fallbacks for API limits or query failures.
Enterprise-Grade Security Architecture
Security was paramount for an enterprise CRE platform handling sensitive market data. The team implemented a multi-layer security architecture using Auth0 for JWT-based authentication with strict 10–15 minute token expiration. The system ensures no direct client-to-n8n communication occurs, with role-based access control (RBAC) enforced at the Snowflake database level—ensuring users can only access data they’re authorised to see.
Results and Impact
The launch of VTS Analyst fundamentally changed how VTS users interact with market data, removing both the time and expertise barriers that had limited data-driven decision-making.
<10s
First-Time Query Response
Instant
Cached Query Response
Zero
SQL Knowledge Required
Performance and Efficiency
- Complex market analysis that previously took hours of manual work is now completed in under 10 seconds.
- Cached queries return results instantly, enabling rapid follow-up analysis and iterative exploration of market data.
- The natural-language-to-SQL pipeline delivers high-accuracy results validated by a rigorous QA scoring system.
User Empowerment
- Non-technical users—brokers, landlords, asset managers—can now access deep market insights independently, without SQL expertise.
- Dependency on data teams for routine analytical queries has been significantly reduced, freeing analysts for higher-value work.
- Contextual intelligence for asset benchmarking and market trend analysis is now available on demand.
Technical Excellence
- Snowflake Cortex Analyst delivers low-latency Text-to-SQL generation integrated natively with VTS’s semantic data models.
- n8n orchestration handles the full pipeline—validation, SQL generation, humanisation, and error handling—as a robust, maintainable workflow.
- Multi-layer Auth0 security with JWT authentication and Snowflake-level RBAC ensures enterprise-grade data protection.
Why It Worked
AI Meets Domain Data
Snowflake Cortex’s native integration with VTS’s semantic models meant the AI understood CRE-specific data structures from day one—no custom training required.
Humanise, Don’t Just Query
Using AWS Bedrock to transform raw SQL results into natural language summaries made the tool genuinely useful for non-technical users, not just faster for analysts.
Security as Architecture
Building multi-layer auth with RBAC at the database level—not as an afterthought—ensured enterprise clients could trust the tool with sensitive market data.
Frequently Asked Questions
How does VTS Analyst ensure data security?
VTS Analyst implements multi-layer security with JWT-based authentication via Auth0, role-based access control enforced at the Snowflake database level, and encrypted communication channels. Authentication tokens have a strict 10–15 minute expiration, and no direct client-to-n8n communication occurs.
How fast are the AI-powered responses?
Cached queries return results instantly. First-time queries, which involve complex Text-to-SQL generation and response humanisation, typically complete in under 10 seconds end-to-end.
What technology powers the natural-language-to-SQL translation?
The system uses Snowflake Cortex Analyst, which is purpose-built for SQL generation and integrates natively with VTS’s semantic data models for low-latency, high-accuracy performance across complex market intelligence queries.
Can non-technical users really get deep market insights without SQL?
Yes. VTS Analyst translates natural language questions into accurate SQL queries automatically. Users can ask questions like “What are the rent trends in Midtown Manhattan?” and receive clear, humanised summaries powered by AWS Bedrock—no technical knowledge required.
Let’s Build your Project Together
