Axoniq Conference 2025 Day 1 | Query Your Event Store in Seconds: Axoniq Insights Live Demo

Watch Marc Klefter and Stefan unveil Axoniq Insights, a revolutionary analytics platform that lets you query your event store using natural language and SQL—without building projections. See live demonstrations of AI-powered analysis, privacy-preserving queries, and millisecond response times on real event data.

🎯 Featured Speakers:

• Marc Klefter - Solutions Architect, Axoniq

• Stefan Dragisic - Software Engineer, Axoniq

🔥 What is Axoniq Insights?

A specialized analytics node for Axon Server that transforms your event store into a queryable data lake:

• Ad hoc queries without creating projections

• Natural language to SQL powered by AI

• Parquet format for optimized column-oriented storage

• DuckDB embedded SQL engine

• Privacy modes to control data exposure to LLMs

• Sub-second query performance on millions of events

💡 Key Features Demonstrated:

Analytics Capabilities:

• Query events across multiple Axon contexts

• Column-oriented storage for lightning-fast retrieval (11ms queries!)

• DuckDB SQL dialect with full query capabilities

• Event replication from primary cluster to analytics node

• Near real-time data synchronization

• Semantic layer for business context

AI-Powered Insights Agent:

• Two modes: Privacy (schema only) & Full Access (with data)

• Auto-complete with syntax highlighting

• Automatic query generation from natural language

• Self-debugging and error correction

• Multi-step analysis and summarization

• Extract JSON/XML data from events

• Statistical analysis and reporting

Enterprise Features:

• MCP (Model Context Protocol) server for custom agents

• Agent-to-agent communication support

• Row-based security (coming soon)

• Custom LLM provider configuration

• GDPR-compliant privacy controls

• Integration with PowerBI, Tableau, and BI tools

• JDBC/ODBC connectors (planned)

🎯 Real Demo Use Case: Bike Rental Analysis

• Live queries demonstrated:

• Which location has the most rentals?

• Which days are most popular for bike rentals?

• Analyze bike cancellations by city (10% cancellation rate found)

• Identify renters with multiple cancellations

• Customer journey analysis for potential fraud detection

⚡ Performance Highlights:

• 8-11 milliseconds for complex aggregations

• 100,000+ events queried in under 2 seconds

• 10x-100x faster than traditional projection approaches

• Near real-time replication from primary cluster

• Column-oriented storage only loads required fields

🔐 Privacy & Security:

Privacy Mode:

• ✅ LLM sees only schema (no actual data)

• ✅ GDPR-compliant operations

• ✅ Safe for sensitive information

• ✅ Query generation without data exposure

Full Access Mode:

• ✅ AI sees results for better analysis

• ✅ Multi-step reasoning

• ✅ Deeper insights and summaries

• ✅ Customer journey reconstruction

• 
  

🏗️ Architecture:

Primary Cluster (Your Apps)

    ↓ Event Replication

Analytics Node

    ↓

Parquet Storage (Columnar Format)

    ↓

DuckDB SQL Engine

    ↓

Semantic Layer + Ontology

    ↓

Insights Agent (AI) + MCP Server

    ↓

Your Queries / Custom Agents / BI Tools

🔗 Resources:

• Try Early Access: https://platform.axoniq.io (click “Analyze”)

• Documentation: https://docs.axoniq.io