Impact at a Glance

• Client: VTS (Commercial Real Estate Platform)
• Launch: September 22, 2025 (Limited Availability)
• Key Result: Reduced market analysis time from hours to <10 seconds
• Performance: First-time queries processed in under 10 seconds; instant results for cached queries
• Tech Stack: Snowflake Cortex (Text-to-SQL), n8n (Orchestration), Auth0 (Security), AWS Bedrock
• Outcome: Democratized data access for non-technical users, eliminating the need for SQL expertise

The Client: A Leader in Commercial Real Estate Tech

VTS is the leading technology platform for commercial real estate (CRE), managing billions of square feet of assets globally. As they continue to innovate, VTS focuses on eliminating friction in the deal-making process through intelligent automation, enabling landlords and brokers to make faster, data-driven decisions.

The Challenge: The Data Bottleneck in CRE

Commercial real estate professionals faced significant barriers to accessing critical market intelligence. The process was time-intensive, often requiring hours of manual analysis across fragmented sources. Furthermore, a technical expertise gap meant that extracting deep insights required SQL knowledge, effectively locking non-technical users out of data-driven decision-making. This led to delayed responses to market opportunities and a lack of contextual intelligence for asset benchmarking.

The Solution: VTS Analyst – AI-Powered Market Intelligence

Collaborating with Ajackus, VTS built VTS Analyst, an AI-powered conversational interface embedded directly into the VTS Core Monolith (VCM).

1. 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. This allows users to ask questions like “What are the rent trends in Midtown Manhattan?” and receive data-driven answers instantly, without writing a single line of code.

2. Intelligent Orchestration via n8n

Ajackus implemented n8n to orchestrate the complex workflow. This includes:

• Request Validation: Enriching prompts with page-level context.
• Response Humanization: Using AWS Bedrock/LiteLLM to transform raw SQL data into clear, natural language summaries.
• Error Handling: A robust fallback system to manage API limits or query failures gracefully.

3. Enterprise-Grade Security

Security was paramount. We implemented a multi-layer architecture using Auth0 for JWT-based authentication. The system ensures no direct client-to-n8n communication occurs, with strict role-based access control (RBAC) enforced at the Snowflake database level.

Key Results & Business Impact

The launch of VTS Analyst has fundamentally changed how VTS users interact with data:

• From Hours to Seconds: Complex market analysis that previously took hours is now completed in under 10 seconds.
• Democratized Access: Non-technical users can now access deep market insights independently, reducing dependency on data teams.
• High Fidelity: The system delivers high accuracy in both SQL generation and natural language summarization, validated by a rigorous QA scoring system.