HeliosDB User Documentation Index

HeliosDB User Documentation Index

Production-Ready Multi-Model Database

Version: v7.1.1 | Status: 99% Complete (182/183 features) | Protocols: 9 Production Last Updated: January 25, 2026

---

Quick Navigation

I Want To…	Go To
Get started quickly	Quick Start Guide
Deploy to production	Production Deployment
Migrate from PostgreSQL	PostgreSQL Migration
Migrate from MongoDB	MongoDB Migration
Migrate from Oracle	Oracle Migration
Use AI/ML features	AI Features
Optimize performance	Performance Tuning
Configure security	Security Reference
Scale the database	Scaling Operations Runbook

---

1. Getting Started

First Steps

• Quick Start Guide - 5-minute setup
• Getting Started - Comprehensive introduction
• Configuration Guide - System configuration
• Configuration Quick Reference
• Connecting to HeliosDB - Connection methods and clients
• Data Types Reference - Supported data types

Installation & Deployment

• Docker Deployment - Container setup
• Production Deployment - Full production guide
• Deployment Runbook - Operational procedures
• CI/CD Integration
• Beta Deployment Guide

Tutorials

• Complete Tutorial - Step-by-step learning
• CLI Usage Guide - Command-line interface
• psql Client Guide - PostgreSQL client usage
• Python Implementation Guide
• Java Quick Start

---

2. Protocols & Migration

Production SQL Protocols

• PostgreSQL 17 - 100% wire protocol compatible (Primary)
  • PostgreSQL Compatibility
  • Advisory Locks Guide
• MySQL - 90%+ wire protocol v10 compatible
  • MySQL Quick Reference
• Snowflake - SQL API with time travel and VARIANT types
• SQL Commands Reference

Production NoSQL Protocols

• MongoDB - Full wire protocol v6 (aggregation pipeline, change streams, GridFS)
• Redis - Full RESP3 protocol (streams, pub/sub, Lua scripting, geospatial)
• Cassandra CQL - Complete CQL v3/v4/v5 support with materialized views
  • Cassandra Quick Start
• ClickHouse - Native and HTTP protocols (columnar analytics, MergeTree engines)
  • ClickHouse Quick Start

API Protocols

• GraphQL - Full GraphQL with subscriptions and federation
  • GraphQL Quick Start
  • GraphQL Reference
• HTTP/REST - RESTful API with OpenAPI 3.0 spec
  • REST API Reference

Oracle Compatibility

• Oracle 23ai Compatibility Guide - 40-45% compatibility
• Oracle Quick Start
• PL/SQL, DBMS packages, hierarchical queries, PIVOT/UNPIVOT support

Migration Guides

Source Database	Migration Guide
PostgreSQL	Migration Guide
MongoDB	Migration Guide
Cassandra	Migration Guide
Oracle	Migration Guide
Redis	Migration Guide
MySQL	Migration Guide
SQL Server	Migration Guide
SQLite	Migration Guide

• Migration Toolkit Guide - Comprehensive migration tools
• Migration Overview
• Zero-Code Developer Guide - Zero-code protocol migration

---

3. Core Features

SQL & Transactions

• Transactions User Guide - Comprehensive transaction guide
• EXPLAIN Plan Guide - Query analysis and optimization
• DML Operations - INSERT, UPDATE, DELETE
• Statement Cache - Prepared statement optimization
• SQL Command Extensions
• Query Optimization

MVCC (Multi-Version Concurrency Control)

• MVCC Configuration Guide
• MVCC Quick Start
• Transaction Isolation Levels

Storage & Indexing

• Indexing Guide - Index creation and usage
• Index Types Comparison - B-Tree, LSM-Tree, hybrid indexes
• Index Maintenance & Online Rebuild
• HNSW Index Guide - Vector indexing
• IVF Index Guide - Inverted file indexing
• Compaction Strategy Guide
• LSM Tuning Guide

Time-Travel & Historical Queries

• Time-Travel Debugging Guide - Historical data queries
• Time-Travel Examples

---

4. Advanced Features

Time-Series Data

• Time-Series User Guide - Complete time-series documentation
• Time-Series Quick Start - Getting started with time-series
• Time-Series Performance Tuning
• Time-Series Compression

Vector Search & Embeddings

• Multimodal Vector Search - 8-modality support
• 8-Modality Quick Start
• Vector Search Guide
• Vector Quick Start
• Multimodal Search Architecture
• HNSW indexing with 99%+ recall

Materialized Views

• Materialized Views Implementation
• Materialized Views Runbook

Automated ETL

• Automated ETL User Guide

Graph & GraphRAG

• GraphRAG User Guide
• GraphRAG Quick Start
• Cypher Reference
• Neo4j Migration Guide

Full-Text Search

• Full-Text Search Tuning Guide
• Full-Text Search Package

Geospatial

• Geospatial Operations Guide
• Geospatial Quick Start
• Geospatial Package

Sharding & Multi-Region

• Sharding Strategy Decision Guide
• Sharding Guide
• Multi-Region Replication
• Multi-Cloud Federation Guide

Streaming & Real-Time Analytics

• Streaming & Real-Time Analytics Guide
• Online Aggregation Quick Start
• Streaming Package

Change Data Capture (CDC)

• CDC Package Overview
• CDC Quick Reference
• CDC Webhook Integration

---

5. AI/ML Features

Natural Language Queries

• Conversational BI Guide - Natural language analytics
• Conversational BI Quick Start
• Performance Optimization
• Production Deployment
• SQL-Native RAG - Retrieval-augmented generation
• NL2SQL User Guide

Machine Learning Integration

• Federated Learning Guide - Privacy-preserving ML
• Advanced ML Integration Guide
• AI Schema Architect - AI-powered schema design
• ML Package
• Tier 2/3 AI/ML User Guide - Neural planner, schema AI, RL cache, and more

Blockchain & CRDT

• Blockchain CRDT Guide - Distributed data structures
• Blockchain CRDT Examples

---

6. Operations & Administration

Operational Runbooks

Runbook	Description
Scaling Operations	Horizontal and vertical scaling procedures
Multi-Region Replication	Cross-region replication setup and management
Point-in-Time Recovery (PITR)	Backup and recovery procedures
Schema Evolution	Online schema changes and migrations
Backup & Restore	Backup and restore operations
Database Maintenance	Routine maintenance tasks
Incident Response	Incident handling procedures
Performance Troubleshooting	Performance issue diagnosis
GPU Operations	GPU resource management
Multi-Region Operations	Multi-region deployment operations

High Availability

• High Availability Operational Procedures
• Multi-Master Replication Operations
• Replication Operations Guide
• Replication Package
• Multi-region replication with automated failover (<30s RTO)
• Zero-Loss Failover: Transaction Replay integration preserves in-flight transactions
  • Session state migration across failover
  • Cursor position recovery
  • Automatic transaction replay on new primary

Backup & Recovery

• Backup & Recovery Guide
• Backup Quick Start
• PITR Runbook
• Backup Encryption Guide

Monitoring & Health

• Monitoring Guide
• Health Check Guide
• Incident Response
• Rollback Procedures

Multi-Tenancy

• Multi-Tenancy Package

Autonomous Operations

• Autonomous Database Operations Guide

---

7. Performance Tuning

Query Optimization

• Query Optimizer Tuning
• Query Optimization Troubleshooting
• EXPLAIN Enhancements
• Query Optimization Reference

Performance Guides

• Performance Tuning Guide - Comprehensive tuning
• Performance Tuning Guide V7 - Latest optimizations
• Performance Tuning Playbook
• GPU Acceleration Guide - CUDA/OpenCL acceleration
• Quantum Optimization Guide
• Performance SLA Targets

SIMD & Hardware Optimization

• SIMD Integration Quick Start
• SIMD Quick Reference
• Build Optimization

Caching & Connection Pooling

• Caching Configuration Guide
• Cache Pooling Quick Fix Guide
• Statement Cache Quick Reference
• Connection Pool Leak Prevention

Resource Management

• Workload Management Guide - Query scheduling and SLA enforcement
• Resource Limits Quick Start
• Resource Limits Reference
• Resource Leak Prevention
• Deadlock Prevention Operations Guide

Workload Management Components

• Admission Control
• Graceful Degradation
• Query Scheduler
• Resource Manager
• SLA Manager

---

8. Security

Security Configuration

• Security Quick Reference
• Security Hardening V7
• Security Quick Start
• Security Best Practices

Authentication & Authorization

• JWT Authentication Guide
• Key Management

SQL Injection Protection

• SQL Injection Quick Reference
• SQL Injection Protection
• SQL Injection Protection Implementation

Data Protection

• Data Masking & PII Quick Start
• Column-Level Encryption
• Column Encryption Quick Start
• Rate Limiting & DDoS Protection

Encryption

• TLS 1.3 in transit
• AES-256 at rest
• Homomorphic encryption (beta)
• Post-quantum cryptography ready
• FIPS Compliance

Compliance

• Backup Encryption Regulatory Compliance Matrix
• SOC 2 Type II ready
• GDPR compliant
• HIPAA compliant
• PCI-DSS ready

---

9. Integrations

Cloud & Data Catalogs

• Cloud Catalogs Quick Start
• Lakehouse Integration Guide
• AWS, GCP, Azure native integrations
• Apache Iceberg, Delta Lake support

Streaming & CDC

• Webhook Throughput
• Change Data Capture (CDC)
• Kafka, Pulsar integration

External Data

• Foreign Data Wrappers (FDW)
• Arrow Flight Quick Start
• Federation Quick Start

Client Libraries

• Python Client
• Java Client
• ODBC Driver

Storage Attribution

• Storage Cost Attribution

Edge Computing

• Edge Deployment Guide
• Edge Computing User Guide

---

10. Multi-Model Data

Document Store

• Document Store Guide
• Multi-Model Data Guide

Data Quality

• Data Quality Management Guide

---

11. Reference Documentation

Quick References by Category

• Quick Starts Index - All quick start guides
• Protocol Reference - Database protocols
• Performance Reference - Optimization guides
• Security Reference - Security configuration
• Features Reference - Feature quick starts

Architecture & Design

• Architecture Documentation - System design
• Feature Documentation - Detailed feature specs
• Complete Feature Index

FAQ & Troubleshooting

• Frequently Asked Questions

---

Feature Highlights

12 World-First Innovations

Innovation	Status
Quantum-Inspired Query Optimization	Production
Neuromorphic Pattern Recognition	Production
Cognitive Database Agents	Production
WASM Polyglot Procedures	Production
ML-Based Self-Healing	Production
Agentic NL2SQL	Production
Homomorphic Encryption	Production
Federated Learning	Production
GPU Query Engine	Production
Multi-Protocol Gateway	Production
Oracle 23ai Compatibility	Production
WASM Edge Computing	Production

Performance Benchmarks

• OLTP: 2.7x improvement vs baseline
• OLAP: 7.5x improvement vs baseline
• Vector Search: <10ms P99 latency
• Graph Traversal: <78ms P99 (6-degree)
• Availability: 99.99%+ uptime SLA

---

Support

Documentation

• Complete Documentation Index
• Developer Guide - Contributing and development

Feedback

• GitHub Issues: github.com/heliosdb/heliosdb/issues
• Documentation feedback: docs@heliosdb.com

---

HeliosDB - The World’s First AI-Autonomous Multi-Model Database

181/183 Features Production-Ready (99%) | 6 Data Models | 9 Protocols | 12 World-First Innovations