Skip to main content
Explore practical, high‑impact ways to use SyneHQ. These patterns combine natural‑language querying, federated analytics, dashboards, and secure collaboration to accelerate decisions—without ETL.

​
Patterns

SyneHQ connects to databases and analytics tools so you can analyze everything in one place.
Key benefit: Consolidate disparate data into a single analysis surface—no pipelines required.
  • Blend CRM + product analytics + billing
  • Join operational DBs with CSV/JSON/Parquet on the fly
  • Use Tangent Lake for cross‑engine joins

Data Sources

Supported connectors and connection methods

Federated Analytics

Query across Postgres, MySQL, files, and more
Build dashboards that refresh automatically and set up notifications for threshold breaches.
Key benefit: Always know when key metrics move—no manual checks.
  • Team dashboards for daily/weekly reviews
  • Slack/email alerts on KPI deviations
  • Drill‑downs from cards to source queries

Visualization

Create charts and dashboards from queries
Use natural language to get SQL, iterate quickly, and learn from the generated queries.
Key benefit: Answer follow‑ups in seconds; share the exact SQL behind each insight.
  • Ask: “Show revenue by month for premium plans”
  • Refine: “Filter to last 90 days and include churn rate”
  • Compare: “Month‑over‑month change vs previous quarter”

AI Features

Tips for better NLQ and optimization
Share queries, dashboards, and Tangents with precise permissions.
Key benefit: Empower teams while protecting sensitive data with RBAC and audit trails.
  • Role‑based access to sources and folders
  • Share read‑only dashboards to stakeholders
  • Version and reuse query building blocks

Architecture & Security

How RBAC, encryption, and auditing fit in
Concrete ways different teams apply SyneHQ.
Key benefit: Ready‑to‑run ideas to prove value fast.
  • Finance: anomaly detection, revenue reconciliation, risk metrics
  • Product & Marketing: funnel analysis, cohort retention, attribution
  • Logistics & Manufacturing: inventory turns, on‑time delivery, scrap rate
  • E‑commerce: LTV by segment, cart abandonment cohorts, promo ROI

Examples

Copy‑paste SQL for cross‑source insights
Keep data in your environment (self‑hosted) or use SaaS with zero data footprint.
Key benefit: Meet SOC2/GDPR requirements without slowing teams down.
  • Local/private access via secure tunnel (Rabbit CLI)
  • No ETL copies; query sources live
  • Auditable access and query history

Local Connections

Secure tunnels for on‑prem and local data

Deployment

SaaS, enterprise self‑hosted, or hybrid

​
Summary table

PatternPrimary benefit
Connect multiple sourcesUnified analysis without pipelines
Real‑time KPI monitoringImmediate awareness of changes
Interactive exploration (NLQ)Faster answers with transparent SQL
Collaboration with RBACSecure sharing and reuse
Industry playbooksProven ideas to ship value fast
Security & compliancePrivate by default, auditable access

​
Next steps

Quick Start

Connect a source and run your first query

Tangent Lake

The federated query lake powering cross‑engine joins

Data Sources

Explore supported connectors
⌘I