Skip to content

Overview

Orbix is a text-to-SQL AI agent that lets business teams query a CRM data warehouse in natural language. It routes each question to the right database, computes revenue analytics and produces ready-to-share PDF reports — without writing SQL.

Key capabilities

  • Text-to-SQL over a SQL Server CRM data warehouse
  • Dual-database routing between CRM data and PostgreSQL satellite datasheets
  • Revenue analytics with monthly normalisation and year-over-year growth
  • Automated PDF report generation
  • Modular agent architecture built on Django
  • Customer behaviour analysis that surfaces hidden patterns, trends and new business opportunities

Benefits

  • Sales and marketing optimisation
  • Data-driven decision support for managers
  • Better customer engagement
  • Improved operational efficiency

The challenge

Commercial data at Arabsat lives in a SQL Server CRM data warehouse, while satellite technical datasheets sit in a separate PostgreSQL database. Getting a revenue figure or a cross-database answer required SQL expertise and manual reporting.

Our solution

We built Orbix, a modular Django-based agent that translates questions into SQL, routes them to the CRM or the satellite datasheets as needed, normalises revenue month by month, computes year-over-year growth and exports the answer as a PDF report. It was delivered to the client through a hands-on proof-of-concept deployment workshop.

Results

  • Proof of concept deployed and demonstrated in a workshop with the client's teams
  • Natural-language access to CRM and satellite data from a single interface
  • Revenue reports generated automatically as PDF