Sodiac Insight
Sodiac Insight puts the power of a data analyst in every team member's hands. Ask questions in plain English, get charts and summaries back instantly. Predictive analytics surfaces trends before they become problems. Auto-generated executive summaries turn hours of report-writing into seconds. And with embeddable dashboards, you can put real-time business intelligence exactly where decisions get made — in Slack, Notion, Salesforce, or your own app.
Technical Architecture
How Sodiac Insight works in production
Engineered with deterministic safety boundaries, zero-data-leakage protocols, and seamless human-in-the-loop oversight.
Semantic Schema Mapping
Maps your database schemas, business KPIs, and metric definitions into a natural language semantic layer.
Text-to-SQL Generation
Translates plain English business questions into performant, sanitized SQL queries against your data warehouse.
Validation & Sanity Guardrails
Validates query syntax, checks for cartesian joins, applies row limits, and enforces tenant isolation.
Visual Rendering & Embed Delivery
Generates interactive charts, tables, and executive summary narratives embeddable directly in Slack, Teams, or your web apps.
Core Capabilities
What's included in Sodiac Insight
- Natural language text-to-SQL query interface
- Automated semantic mapping of business KPIs & metrics
- Predictive trend forecasting & operational anomaly alerts
- Auto-generated narrative executive summaries
- Embeddable charts and dashboards for web and SaaS apps
- Strict read-only execution with zero write permissions
Real-World Impact
Where Sodiac Insight delivers immediate value
Enterprise Connectivity
Native integrations & connectors
Connects seamlessly to the tools, databases, and communication channels your team already relies on every day.
Enterprise Security Moat
Built for regulated, high-stakes environments
We ensure your enterprise data remains completely confidential, isolated, and governable under strict compliance controls.
Zero Data Training
Your documents, customer conversations, and internal databases are never used to train or fine-tune public models.
TLS 1.3 & AES-256 Encryption
All data is encrypted in transit and at rest with optional customer-managed keys (CMEK) and cryptographic hashing.
Granular RBAC & Telemetry
Role-based access controls and immutable telemetry logs for every prompt, retrieval chunk, and model inference.
Private VPC & On-Premise
Deployable directly inside your private AWS, GCP, or Azure VPC, or on-premise infrastructure behind your firewall.
Frequently asked questions
Everything you need to know about deploying Sodiac Insight. Talk to our engineering leads →
Insight uses a domain-specific semantic layer that maps your business terminology (such as "MRR", "Churned Accounts", or "CAC") to exact database tables and formulas. The generated SQL is validated against an execution AST (Abstract Syntax Tree) with strict read-only constraints before running.
No. Sodiac Insight operates exclusively through read-only database credentials. It has zero permissions to execute UPDATE, DELETE, DROP, or INSERT commands, preventing accidental data modifications.
Yes. Sodiac Insight provides lightweight React components, iframe embeds, and secure signed URLs, allowing you to deliver AI-powered customer-facing analytics inside your own SaaS application.
During initial setup, we map your database foreign keys and dimensional relationships into Insight’s semantic model. When an ad-hoc query requires joining customer orders with inventory and payment logs, Insight determines the optimal join path without duplicate aggregations.
Ready to see Sodiac Insight in action?
Book a personalized walkthrough with one of our AI engineers and see how it fits your technical stack.