DS InsightCitizen Logo

DS InsightCitizen

Empower anyone to become a builder with secure, governed, and compliant self-service analytics.

Natural Query
Visual Insights

DS InsightCitizen is the ultimate democratization layer for your enterprise data. It bridges the gap between complex data architectures and business decision-making.

By leveraging agentic intelligence, it allows users to interact with data using natural language, providing secure and governed access to insights without the need for technical intermediaries. From conversational BI to a full data marketplace, it transforms data into a true strategic asset.

DS InsightCitizen Functional Architecture

End-to-End Pipeline
DataMaps DAG JSON
Ontology Generation
OSI Context Model
Text-to-SQL Engine
Business Insights
Four-Layer Architecture
L4

Intelligence & Delivery

Natural language to governed SQL

Business users ask questions in plain English — the context model grounds every answer, preventing hallucination.

Text-to-SQLNL InterfaceAgentic AIMCPGraphRAGBI Connectors
L3

Context & Interchange

OSI-compliant context model persisted in PostgreSQL

Portable metric definitions, business rules, and KPI governance - one truth across all consumers.

OSI Context ModelPostgreSQL StoreMetric DefinitionsBusiness RulesKPI Governance
L2

Semantic Modeling

Transforms metadata into taxonomy and knowledge graphs

Entities, attributes, and relationships formalized as W3C open models (RDFS/OWL).

TaxonomyOntology (RDFS/OWL)Knowledge GraphApache AGEW3C SKOS
L1

Data Foundation

Ingestion and cataloging via PostgreSQL and open connectors

DataMaps DAG JSON captures full lineage from warehouses, lakehouses, APIs, and streams.

PostgreSQLDataMaps DAGMetadata CatalogIcebergDelta LakeKafka
Governance
PostgreSQL

PostgreSQL at the Core

JSONB context model store with versioning
Foreign Data Wrappers for federation
Any cloud: RDS, Aurora, AlloyDB
Apache AGE for graph queries
pgvector for semantic matching
Zero vendor lock-in, full portability

Open Standards Ecosystem

Portable metric definitions
RDFS, OWL, SKOS, PROV-O
Agent-to-tool connectivity
Iceberg REST catalog

Why DS InsightCitizen?

✓DAG-first — no months-long ontology projects
✓PostgreSQL-native — open, extensible core
✓Self-service NL — ask in plain English
✓OSI native — define once, use everywhere
✓Agent-ready — MCP + governed retrieval
✓Zero lock-in — open standards at every layer

Text-to-SQL

Convert complex natural language questions into precise SQL queries automatically.

Conversational BI

Interact with your data through a chat interface that understands context and business logic.

Data Marketplace

Browse, request, and utilize vetted data assets across the entire organization.

Governed Access

Ensure every insight is compliant with enterprise security and data privacy standards.

Empowering the entire enterprise with predictive intelligence and secure self-service analytics.

Accelerates decision-making by removing the data-to-insight bottleneck.

Reduces the workload on specialized data teams for ad-hoc requests.

Guarantees that insights are grounded in governed and vetted data.

Enables non-technical users to build their own dashboards and reports.

Promotes data literacy and a culture of informed experimentation.

Syncs with SwitchIE Code for polyglot code generation behind the scenes.

Frequently Asked Questions

DS InsightCitizen is the ultimate enterprise data democratization layer. Driven by agentic intelligence, it bridges the operational gap between complex technical data architectures and business decision-making by allowing non-technical users to securely interact with data using standard natural language text.
The end-to-end processing pipeline transforms complex datasets into business intelligence across five chronological stages: DataMaps DAG JSON ingestion, automated Ontology Generation, building the Open Semantic Interface (OSI) Context Model, execution via the Text-to-SQL Engine, and rendering terminal Business Insights.
The platform architecture consists of four native vertical layers: Layer 1 (L1) Data Foundation, Layer 2 (L2) Semantic Modeling, Layer 3 (L3) Context & Interchange, and Layer 4 (L4) Intelligence & Delivery. Centralized Governance loops cross-examine all layers, persisting relational arrays directly inside a core PostgreSQL stack.
At Layer 4 (L4) Intelligence & Delivery, business users write queries in plain English. The underlying platform instantly checks this text against an OSI-compliant context model grounded in GraphRAG, Model Context Protocol (MCP), and BI Connectors. This translates natural language into secure, governed SQL statements with zero hallucination.
DS InsightCitizen operates an open standards ecosystem at its core. It normalizes entities and relationships as W3C open models using RDFS, OWL, SKOS, and PROV-O schemas. It manages underlying graph queries via Apache AGE, stores context models using PostgreSQL JSONB with versioning, and provides semantic matching utilizing pgvector.
By combining Conversational BI with a fully governed Data Marketplace, users can browse, request, and utilize vetted data assets across the entire organization. The platform integrates seamlessly with SwitchIE Code for polyglot code generation behind the scenes, ensuring that all self-service dashboards and custom metrics strictly map to enterprise privacy standards.

Proof of Impact

Real results with DS InsightCitizen

Explore how enterprises have leveraged DS InsightCitizen to accelerate their data modernization journey.

SAP HANA to Snowflake Migration: Achieving 93% Automation in Medical Technology
Medical Technology
SAP HANASnowflake

SAP HANA to Snowflake Migration: Achieving 93% Automation in Medical Technology

700+
Scripts
93%
Automation
95% Automated Hive to BigQuery Migration: A US Healthcare Case Study
Healthcare
HiveBigQuery

95% Automated Hive to BigQuery Migration: A US Healthcare Case Study

1000+
Scripts
95%
Automation
DataStage to Databricks Automotive Migration: Achieving 75% Automation with DataSwitch
Automotive
DataStageDatabricks

DataStage to Databricks Automotive Migration: Achieving 75% Automation with DataSwitch

1500+
Assets
75%
Automation
Accelerating Media Insights: Reducing Data Processing Times by 85% with Redshift to Databricks
Media & Entertainment
RedshiftDatabricks

Accelerating Media Insights: Reducing Data Processing Times by 85% with Redshift to Databricks

100+
Assets
80%
Automation

Ready to see how DataSwitch can transform your data management?

Request a personalized demo today and experience the difference firsthand!