Enterprise Data Platform

One query language.
Every data source.

UQL unifies your databases, APIs, and enterprise systems behind a single query interface — with built-in automation, AI assistance, and enterprise-grade security.

uql-query
> READ "revenue" FROM "netsuite"
   WHERE year = 2025
// Compiling query plan...
✓ 12,847 rows returned in 340ms
Platform

Four components. One unified experience.

UQL is a complete enterprise data platform, not just a query tool. Every component is purpose-built to work together.

Desktop App

Native desktop client built with Tauri. Full query builder, pipeline management, AI chat, and bridge configuration in a fast, local application.

Tauri v2 · Rust · JavaScript

Excel Add-in

Query any connected system directly from Excel. Custom functions like =UQL.QUERY() and =UQL.REPORT() bring live enterprise data into your spreadsheets.

Office.js · React · TypeScript

Brain API

The execution engine. Compiles UQL queries into optimized plans, manages secrets, enforces security policies, and orchestrates pipeline workflows.

FastAPI · Python · Azure Container Apps

Control Plane

Serverless management layer for template distribution, tenant provisioning, and centralized configuration across deployments.

AWS Lambda · DynamoDB · S3
Features

Everything you need to unify your data.

Universal Query Engine

Write one query, hit any system. UQL compiles your requests into optimized execution plans — whether the backend is SQL Server, NetSuite, Salesforce, or a REST API. Schema discovery is automatic: connect a system and UQL enumerates every available collection, field, and data type.

  • Template-driven — add new systems without code changes
  • Automatic schema discovery across all connected sources
  • Plan-based compilation for optimized execution
  • Normalized output regardless of source system
query-plan.json 
"plan": [
  { "op": "secret.load",  "ref": "netsuite.prod" },
  { "op": "http.request", "method": "GET" },
  { "op": "collection.parse" },
  { "op": "result.return" }
]

Pipeline Automation

Build automated data workflows with YAML-based pipelines. Chain HTTP requests, SQL operations, AI decision points, and human approval gates into scheduled, repeatable processes.

  • Conditional branching and error handling
  • AI agent decision steps powered by LLMs
  • Human approval gates for sensitive operations
  • Built-in rate limiting to protect external systems
  • Background scheduling with cron-like triggers
sync-pipeline.yaml 
steps:
  - id: fetch_records
    op: http.request
    save_as: artifact:records

  - id: ai_review
    op: ai.agent
    args:
      prompt: "Flag anomalies"

  - id: sync_approved
    op: db.query
    if: $ref: artifact:ai_review.ok

AI-Powered Assistant

An integrated AI chat that understands your data. Ask questions in natural language, and the assistant can discover schemas, execute queries, and build pipeline definitions — all within the conversation.

  • Natural language to UQL query translation
  • Schema-aware — knows your connected systems
  • Can execute queries and return results inline
  • Pipeline generation from plain English descriptions
Show me all revenue over $50k from NetSuite for Q4 2025
Discovering NetSuite schema... Executing query: revenue > 50000, period = Q4 2025 Found 847 records totaling $12.4M

Native Excel Integration

Bring enterprise data directly into the tool your team already uses. UQL's Excel add-in provides custom spreadsheet functions, a query builder in the taskpane, and live report execution — no exports, no CSVs, no copy-paste.

  • =UQL.QUERY() — live data in any cell
  • =UQL.REPORT() — execute saved reports
  • Taskpane UI with full query builder and AI chat
  • Pipeline inputs from selected Excel ranges
B2 =UQL.REPORT("monthly_revenue", {{"year","2025"}})
ABCD
1 MonthRevenueGrowth
2 Jan$2.1M+12%
3 Feb$2.4M+14%
4 Mar$2.8M+17%

Reports & Aggregations

Save parameterized queries as named reports that anyone on the team can execute. Reports support aggregations, transforms, and consistent output schemas — accessible from the desktop app, Excel, or the API directly.

  • Parameterized — same report, different inputs
  • Built-in aggregations (sum, average, count, etc.)
  • Accessible from desktop, Excel, and API
  • Consistent, normalized output across all systems
monthly_revenue NetSuite · Parameterized
Live
customer_churn Salesforce · Aggregated
Live
inventory_snapshot MSSQL · Scheduled
Daily
compliance_audit PostgreSQL · Parameterized
On-demand
Architecture

Built for enterprise. Deployed on Azure.

Tenant-isolated infrastructure with secrets managed in Azure Key Vault, identity through Azure Entra ID, and compute on Azure Container Apps.

Clients
Desktop App
Excel Add-in
OAuth2 + HMAC
Execution
Brain API
Data Sources
MSSQL
NetSuite
Salesforce
REST APIs
Azure Key Vault
Azure Entra ID
Azure Container Apps
PostgreSQL
AWS Lambda
AI Foundry
How It Works

Connect. Query. Automate.

01

Connect a Bridge

Point UQL at any supported system — SQL databases, REST APIs, NetSuite, Salesforce, and more. Credentials are stored in Azure Key Vault, never in the application.

02

Discover Your Schema

UQL automatically enumerates every available collection, field, and data type across your connected systems. One unified catalog, zero manual mapping.

03

Query & Report

Execute queries from the desktop app, Excel, or the API. Save parameterized reports that your whole team can run with different inputs.

04

Automate with Pipelines

Build YAML-based workflows that chain operations, branch on conditions, invoke AI agents, and run on schedules — with full audit trails and approval gates.

Security

Enterprise security by default.

Every layer of UQL is built with security as a core requirement, not an afterthought.

Azure Entra ID

All users authenticate via Azure AD with OAuth2 PKCE. Short-lived tokens, enforced MFA, role-based access control.

Key Vault Secrets

Credentials never touch the application database. All secrets stored in and fetched from Azure Key Vault at request time.

Role-Based Access

Reader and Admin roles enforced at every endpoint. Write operations require Admin. Collection-level read-only overrides for sensitive data.

Tenant Isolation

Infrastructure is isolated per tenant. No cross-tenant access paths. Private networking and least-privilege access enforced.

Request Signing

HMAC-SHA256 request signing with timestamp enforcement and replay protection via nonce tracking.

Full Audit Trail

All authentication, authorization, key usage, and execution events are logged with append-only retention for compliance.

Integrations

Connect the systems you already use.

Template-driven architecture means new integrations are added declaratively — no code changes required.

Microsoft SQL Server
PostgreSQL
MySQL
NetSuite
Salesforce
REST APIs
+ extensible via templates
Team

Built by Lafferty.

Liam Lafferty LL

Liam Lafferty

Co-Founder

Aidan Lafferty AL

Aidan Lafferty

Co-Founder