HeliosDB Cloud

Administration Panel

Powered by HeliosDB-Nano v3.7.0 | Cloud v3.5.10 | Copyright
FREE

Dashboard

Databases

0

Organization

-

Plan

Free

Isolation

Shared

Quick Actions

Databases

    SQL Console

    🕒

    Time-Travel Explorer

    Query your data at any point in time. Use AS OF TIMESTAMP to view historical states, compare data across time ranges, and recover from accidental changes.

    Point-in-Time Queries

    SELECT * FROM table AS OF TIMESTAMP '2026-01-01'

    Version History

    VERSIONS BETWEEN two timestamps to see all changes

    Transaction Replay

    View state after any specific transaction ID

    Time-Travel Explorer

    Point-in-Time Query

    Query your data as it existed at any point in time using AS OF TIMESTAMP.

    Version History

    View all versions of data between two timestamps.

    Custom Time-Travel SQL

    Write any AS OF TIMESTAMP or VERSIONS BETWEEN query directly.

    Time-Travel Console
    Enter time-travel queries. Examples: SELECT * FROM users AS OF TIMESTAMP '2026-01-01 12:00:00'; SELECT * FROM orders VERSIONS BETWEEN TIMESTAMP '2026-01-01' AND '2026-02-01';
    ⎇

    Database Branching

    Git-like branching for your database. Create instant copy-on-write branches for development, testing, or experimentation without duplicating data.

    Instant Branches

    Copy-on-write branching - zero data duplication

    Branch Management

    Create, switch, merge, and drop branches via SQL

    Branch Diff

    Compare data between branches before merging

    Database Branching

    Branch Management

    Branch Console

    Execute branching commands directly.

    Branch Console
    Branching commands: CREATE DATABASE BRANCH branch_name AS OF NOW; USE BRANCH branch_name; SHOW BRANCHES; MERGE BRANCH branch_name INTO main; DROP DATABASE BRANCH branch_name;
    ♺

    Backup Manager

    Create, schedule, and restore database backups. Supports compressed backups with zstd, lz4, and gzip compression.

    Manual Backups

    Create on-demand backups with compression

    Restore

    Restore any backup to any database

    Backup Manager

    Create Backup

    Backup History

    Select a database to view backups.

    ⛷

    Team Management

    Invite team members, assign roles (Admin, Member, Viewer), and manage access permissions across your organization.

    Role-Based Access

    Owner, Admin, Member, Viewer, Guest roles

    Invite Members

    Add users to your organization by email

    Team Management

    Add Team Member

    Team Members

    Loading team members...

    ❖

    Vector Search Playground

    Built-in HNSW vector index for AI/ML embeddings. Store, search, and manage vector data with similarity search, product quantization, and SIMD-accelerated distance functions.

    HNSW Index

    High-performance approximate nearest neighbor search

    Similarity Search

    Cosine, Euclidean, and dot product distance

    Product Quantization

    Compress vectors for memory-efficient storage

    Vector Search Playground

    Quick Setup

    Create a vector-enabled table and HNSW index.

    Similarity Search

    Search for similar vectors using cosine, euclidean, or dot product distance.

    Vector Console

    Vector SQL Console
    Vector SQL examples: CREATE TABLE docs (id INTEGER PRIMARY KEY, title TEXT, embedding VECTOR(1536)); INSERT INTO docs VALUES (1, 'Hello World', '[0.1, 0.2, ...]'); SELECT title, COSINE_SIMILARITY(embedding, '[0.1, ...]') as score FROM docs ORDER BY score DESC LIMIT 5; CREATE INDEX docs_idx ON docs(embedding) USING hnsw;
    ✨

    AI Query Assistant

    Natural language to SQL conversion powered by LLMs. Ask questions in plain English and get SQL queries, explanations, and schema-aware suggestions.

    NL-to-SQL

    Ask "Show me top customers" and get SQL

    Multi-Provider

    OpenAI, Claude, Gemini, Ollama support

    RAG Integration

    Retrieval-augmented generation for context

    AI Query Assistant

    Natural Language to SQL

    Ask questions in plain English and get executable SQL. Powered by HeliosDB's built-in NL query engine.

    Example Questions

    Show me all tables and their row counts
    What are the column types in each table?
    Find duplicate records across tables
    Show recent data modifications
    ⚙

    Visual EXPLAIN Analyzer

    Interactive query plan visualization with performance bottleneck detection, index recommendations, and regression analysis.

    Visual Plans

    Interactive tree view of query execution

    Index Advisor

    Automatic index recommendations

    Regression Detection

    Detect query performance regressions

    Visual EXPLAIN Analyzer

    Query Plan Analysis

    Enter a SELECT query to see its execution plan with performance insights.

    🔐

    Encryption Dashboard

    Transparent Data Encryption (TDE) with AES-256-GCM, Zero-Knowledge Encryption (ZKE), key rotation management, and FIPS 140-3 compliance options.

    TDE (AES-256-GCM)

    Encrypt data at rest transparently

    Key Rotation

    Manage and rotate encryption keys

    FIPS 140-3

    AWS-LC FIPS Certificate #4816

    Encryption Dashboard

    Encryption

    Checking...

    Algorithm

    AES-256-GCM

    Compliance

    FIPS 140-3

    Key Status

    Active

    Encryption Management

    Manage Transparent Data Encryption (TDE) and key rotation for your databases.

    Encryption Console

    Encryption SQL
    Encryption SQL commands: SHOW ENCRYPTION STATUS; SHOW ENCRYPTION KEYS; ALTER DATABASE ROTATE ENCRYPTION KEY; ALTER TABLE users ENABLE ENCRYPTION; ALTER TABLE users DISABLE ENCRYPTION;
    □

    Materialized Views Manager

    Create, refresh, and monitor materialized views. Supports auto-refresh scheduling, incremental refresh with delta tracking, and system views for monitoring.

    Auto-Refresh

    Schedule automatic refresh intervals

    Incremental

    Delta-based refresh for efficiency

    Materialized Views Manager

    Materialized Views

    Create Materialized View

    Materialized View Console

    MV Console
    Materialized view commands: CREATE MATERIALIZED VIEW mv_name AS SELECT ...; REFRESH MATERIALIZED VIEW mv_name; REFRESH MATERIALIZED VIEW CONCURRENTLY mv_name; DROP MATERIALIZED VIEW mv_name; SELECT * FROM heliosdb_materialized_views;
    ▤

    Performance Analytics

    Real-time query performance monitoring, storage statistics, query regression detection, and table/column analytics.

    Query Stats

    Execution times, row counts, cache hits

    Storage Insights

    Table sizes, compression ratios

    Performance Analytics

    Table Statistics

    Select a database and click Load Analytics.

    Analytics Console

    Analytics SQL
    Analytics queries: SELECT * FROM heliosdb_table_stats; SELECT * FROM heliosdb_query_stats; SELECT * FROM heliosdb_index_stats; SELECT * FROM heliosdb_storage_stats; EXPLAIN ANALYZE SELECT ...;
    ⇄

    Replication Dashboard

    WAL streaming replication, logical replication, multi-primary clusters, automatic failover, and split-brain prevention. Full HA topology management.

    WAL Streaming

    Real-time replication with failover

    Multi-Primary

    Active-active clusters with conflict resolution

    Sharding

    Consistent hash ring data distribution

    Replication Dashboard

    Mode

    Checking...

    Replicas

    -

    WAL Lag

    -

    Status

    -

    Topology

    Replication Console

    Replication SQL
    Replication commands: SHOW REPLICATION STATUS; SHOW WAL STATUS; ALTER SYSTEM SET replication_mode = 'streaming'; CREATE REPLICATION SLOT slot_name; SHOW REPLICATION SLOTS; SELECT * FROM heliosdb_replication_stats;
    ☧

    Git Integration

    Link your database schema to Git repositories. Track DDL changes, view schema diffs, configure webhooks, and manage commit-tracked migrations.

    DDL Versioning

    Automatic schema change tracking

    Webhooks

    Git event triggers for DB operations

    Git Integration

    DDL Version History

    Git Console

    Git SQL
    Git integration commands: SHOW DDL HISTORY; SHOW DDL HISTORY FOR TABLE table_name; SHOW SCHEMA DIFF; SHOW SCHEMA DIFF BETWEEN commit1 AND commit2; CREATE WEBHOOK 'url' ON DDL_CHANGE; SHOW WEBHOOKS;
    ✎

    Audit Log Viewer

    Tamper-proof audit logging with SHA-256 checksums. SOC2, HIPAA, and GDPR compliance ready with configurable retention policies.

    Compliance Ready

    SOC2, HIPAA, GDPR presets

    Tamper-Proof

    SHA-256 checksum verification

    Audit Log Viewer

    Audit Logs

    Click Load Logs to view audit trail.

    ⚖

    A/B Testing Console

    Branch-based experiment routing. Create experiments, assign variants, route traffic, and measure statistical significance across database branches.

    Experiments

    Define variants with branch routing

    Metrics

    Latency, throughput, significance

    A/B Testing Console

    Create Experiment

    Active Experiments

    A/B Testing Console

    Experiment SQL
    A/B Testing commands: CREATE EXPERIMENT exp_name WITH VARIANTS (control ON BRANCH main, variant ON BRANCH feature) SPLIT 50; SHOW EXPERIMENTS; SHOW EXPERIMENT exp_name METRICS; ROUTE REQUEST TO EXPERIMENT exp_name; DROP EXPERIMENT exp_name;
    { }

    SDK Setup Wizard

    Guided setup for Python, TypeScript, Go, and Rust SDKs with org-specific connection strings and code examples.

    Python SDK

    pip install heliosdb + SQLite compat

    TypeScript SDK

    npm install heliosdb

    Go & Rust

    Native drivers with connection pooling

    SDK Setup Wizard

    Choose Your SDK

    Python SDK

    pip install heliosdb

    Subscription

    Current Plan

    Current Tier

    -

    Isolation Mode

    -

    Request Status

    No pending request

    Available Plans

    Free
    $0/mo
    • ✓ Up to 5 databases
    • ✓ 100 MB storage
    • ✓ Shared resources
    • ✓ Community support
    Starter
    $19/mo
    • ✓ Up to 10 databases
    • ✓ 500 MB storage
    • ✓ Time-Travel Queries
    • ✓ Email support
    Pro
    $49/mo
    • ✓ Unlimited databases
    • ✓ 10 GB storage
    • ✓ Dedicated DB file
    • ✓ Priority support
    Enterprise
    $199/mo
    • ✓ Unlimited everything
    • ✓ Dedicated server
    • ✓ 24/7 support + SLA
    • ✓ Custom configuration

    Reference

    API Token (click to copy)

    Base URL: https://cloud.heliosdb.com/api/v1
    Org ID:

    DDL (Data Definition)

    ▼
    CREATE TABLE
    Creates a new table with columns and constraints.
    CREATE TABLE users ( id INTEGER PRIMARY KEY, name VARCHAR(100) NOT NULL, email VARCHAR(200), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
    Execute via SQL endpoint:
    CREATE INDEX
    Creates an index for faster queries.
    CREATE INDEX idx_users_email ON users(email);
    Execute via SQL endpoint:
    DROP TABLE
    Removes a table and all its data.
    DROP TABLE IF EXISTS users;
    Execute via SQL endpoint:

    DML (Data Manipulation)

    ▼
    INSERT
    Adds new rows to a table.
    INSERT INTO users (id, name, email) VALUES (1, 'John Doe', 'john@example.com'), (2, 'Jane Smith', 'jane@example.com');
    Execute via SQL endpoint:
    SELECT
    Queries data with filtering, sorting, and pagination.
    SELECT id, name, email FROM users WHERE status = 'active' ORDER BY created_at DESC LIMIT 10;
    Execute via SQL endpoint:
    UPDATE
    Modifies existing records.
    UPDATE users SET email = 'new@example.com' WHERE id = 1;
    Execute via SQL endpoint:
    DELETE
    Removes records from a table.
    DELETE FROM users WHERE id = 1;
    Execute via SQL endpoint:

    Aggregations

    ▼
    COUNT / SUM / AVG
    SELECT COUNT(*) as total, SUM(price) as revenue, AVG(price) as avg_price FROM orders;
    GROUP BY / HAVING
    SELECT status, COUNT(*) as count FROM orders GROUP BY status HAVING COUNT(*) > 5;

    JOINs & Subqueries

    ▼
    JOIN
    SELECT u.name, o.product, o.price FROM users u INNER JOIN orders o ON u.id = o.user_id;
    Subquery
    SELECT * FROM users WHERE id IN ( SELECT DISTINCT user_id FROM orders WHERE price > 100 );

    Time-Travel Queries

    ▼
    AS OF TIMESTAMP
    SELECT * FROM users AS OF TIMESTAMP '2026-01-01 12:00:00';
    VERSIONS BETWEEN
    SELECT * FROM products VERSIONS BETWEEN TIMESTAMP '2026-01-01' AND '2026-01-02';

    Database Branching

    ▼
    CREATE BRANCH
    CREATE DATABASE BRANCH dev_branch AS OF NOW;
    USE / SHOW BRANCHES
    USE BRANCH dev_branch; SHOW BRANCHES; DROP DATABASE BRANCH dev_branch;

    Vector Operations

    ▼
    VECTOR Type & Search
    CREATE TABLE docs ( id INTEGER PRIMARY KEY, title TEXT, embedding VECTOR(1536) ); SELECT title, COSINE_SIMILARITY(embedding, query_vec) as score FROM docs ORDER BY score DESC LIMIT 5; CREATE INDEX docs_emb_idx ON docs(embedding) USING hnsw;

    Database Management API

    ▼
    List Databases
    Create Database
    Delete Database
    Copied to clipboard!