Edge + Proxy Database — production-ready with HeliosProxy, multi-tier caching, and intelligent routing.
Production-ready edge database with HeliosProxy — the flagship connection router with multi-tier caching, GraphQL gateway, and intelligent routing. Everything in Nano, plus a complete suite of production tools for SaaS platforms, edge computing, and AI agent infrastructure.
Lite is the most popular HeliosDB tier, designed for teams that need production-grade features without the complexity of a full distributed system.
# /etc/heliosdb/heliosdb.toml
[server]
bind = "0.0.0.0:5432"
max_connections = 500
[proxy]
enabled = true
[proxy.cache]
l1_size = "256MB"
l2_size = "1GB"
l3_backend = "redis"
[proxy.graphql]
enabled = true
port = 4000
[storage]
engine = "helioscore"
direct_io = trueHeliosDB Lite includes all Nano features — vector search, branching, time-travel, encryption, PostgreSQL compatibility — and adds production-grade capabilities on top.
HNSW + PQ compression with 1K-5K QPS.
Git-like branching at the storage layer.
AS OF syntax for point-in-time access.
TDE, ZKE, FIPS 140-3, Row-Level Security.
HeliosProxy is the flagship connection router exclusive to Lite and Full. It provides intelligent connection pooling, multi-tier caching, a GraphQL gateway, WASM plugin support, and workload-aware routing — all in a single integrated component.
# /etc/heliosdb/proxy.toml
[cache]
l1_size = "256MB"
l2_size = "1GB"
l3_backend = "redis"
[graphql]
enabled = true
[routing]
mode = "workload_aware"
read_preference = "nearest"
# Load a WASM plugin
[[plugins]]
name = "rate_limiter"
path = "plugins/rate_limiter.wasm"HeliosDB Lite supports stored procedures in four SQL dialects, making enterprise migration seamless. Write procedures in PL/pgSQL, PL/SQL, T-SQL, or DB2 SQL PL — the engine handles translation transparently.
-- PL/pgSQL stored procedure
CREATE FUNCTION get_similar_docs(
query_vec VECTOR(768),
limit_n INT
) RETURNS TABLE (
id INT, title TEXT, score FLOAT
) AS $$
BEGIN
RETURN QUERY
SELECT d.id, d.title,
1 - (d.embedding <=> query_vec)
FROM documents d
ORDER BY d.embedding <=> query_vec
LIMIT limit_n;
END;
$$ LANGUAGE plpgsql;
-- PL/SQL (Oracle) syntax also works
CREATE OR REPLACE PROCEDURE
update_inventory(p_id IN NUMBER)
IS
BEGIN
UPDATE products
SET stock = stock - 1
WHERE id = p_id;
END;HeliosDB Lite exposes native gRPC and REST API interfaces built on Axum, enabling direct HTTP-based database access without traditional database drivers. Ideal for microservices, serverless functions, and web applications.
# REST API - Query via HTTP
curl -X POST https://localhost:8080/v1/query \
-H "Authorization: Bearer $TOKEN" \
-d '{
"sql": "SELECT * FROM users LIMIT 10",
"params": []
}'
# REST API - Vector search
curl -X POST https://localhost:8080/v1/search \
-d '{
"table": "documents",
"vector": [0.1, 0.2, ...],
"limit": 5,
"metric": "cosine"
}'
# gRPC - High-performance access
grpcurl -d '{
"query": "SELECT * FROM orders",
"database": "myapp"
}' localhost:50051 \
heliosdb.v1.QueryService/ExecuteHeliosDB Lite includes a built-in Model Context Protocol (MCP) server, enabling seamless integration with AI agents, development tools, and autonomous systems. AI agents can query, modify, and manage databases using natural language through the MCP interface.
The MCP server powers HeliosDB's AI add-ons: AI Support for instant expert answers and AI-DBA Agent for autonomous database administration.
// MCP tool definition
{
"name": "heliosdb_query",
"description": "Query HeliosDB",
"parameters": {
"sql": {
"type": "string",
"description": "SQL query"
},
"database": {
"type": "string",
"default": "default"
}
}
}
// AI agent can call:
{
"tool": "heliosdb_query",
"arguments": {
"sql": "SELECT * FROM users
WHERE role = 'admin'"
}
}Lite upgrades Nano's vector search with SIMD acceleration using AVX-512, AVX2, and NEON instruction sets. This delivers up to 4x faster similarity computations compared to scalar operations, pushing throughput beyond 5K QPS.
-- SIMD auto-detected at startup
-- AVX2/AVX-512/NEON enabled by default
-- Hybrid BM25 + vector search
SELECT title, content,
(0.7 * vector_score +
0.3 * bm25_score) AS rank
FROM (
SELECT *,
1 - (embedding <=> $query_vec)
AS vector_score,
ts_rank(tsv, to_tsquery($query_text))
AS bm25_score
FROM documents
WHERE tsv @@ to_tsquery($query_text)
) ranked
ORDER BY rank DESC
LIMIT 20;HeliosDB Lite includes HeliosCore, a custom storage backend built from the ground up in Rust. It bypasses the filesystem cache with O_DIRECT I/O, providing predictable latency and maximum throughput for database workloads.
use heliosdb::{HeliosDB, StorageConfig};
// Configure HeliosCore storage
let config = StorageConfig::builder()
.engine("helioscore")
.direct_io(true)
.io_backend("io_uring")
.wal_sync_mode("fsync")
.compaction_strategy("leveled")
.max_memtable_size("64MB")
.bloom_filter_bits(10)
.build()?;
let db = HeliosDB::builder()
.storage(config)
.data_dir("/data/helios")
.build()?;
// HeliosCore handles the rest
db.execute("INSERT INTO events
SELECT generate_series(1, 1000000)")?;Let AI agents and developers auto-generate production-ready DDL from JSON samples. The Schema Generation API analyzes your data, detects types (including vectors), infers constraints, suggests indexes, and returns confidence scores — all via a single REST call.
_agent_hints with readiness flags, suggested indexes, and potential issues for LLM consumption.# Infer schema from JSON samples
POST /api/v1/schema/infer
{
"samples": [
{"id": 1, "name": "Widget",
"price": 29.99,
"embedding": [0.1, 0.2, 0.3]}
],
"table_name": "products"
}
# Response: production-ready DDL
{
"ddl": "CREATE TABLE products (
id INTEGER NOT NULL,
name VARCHAR(12) NOT NULL,
price NUMERIC NOT NULL,
embedding VECTOR(3) NOT NULL,
PRIMARY KEY (id)
);",
"confidence": 0.95,
"_agent_hints": {
"ready_to_execute": true
}
}HeliosDB Lite exposes a full REST/CRUD API that follows the Supabase PostgREST conventions. Use familiar filter operators, pagination, ordering, and embedded relations — no SQL required for basic operations.
eq, neq, gt, gte, lt, lte, like, ilike, in, is.null operators.?select=*,author:users(name,email)Prefer: resolution=merge-duplicates header for insert-or-update semantics.# Select with filters
GET /rest/v1/users?select=id,name,email
&age=gt.21&name=ilike.*alice*
&order=created_at.desc&limit=10
# Insert
POST /rest/v1/users
{"name": "Alice", "email": "alice@ex.com"}
# Upsert (merge duplicates)
POST /rest/v1/users
Prefer: resolution=merge-duplicates
{"id": 1, "email": "new@ex.com"}
# Embedded relations
GET /rest/v1/posts
?select=*,author:users(name,email)
# Agent Memory
POST /api/v1/agents/sessions
{"agent_id": "assistant-v1"}
POST /api/v1/agents/sessions/:id/messages
{"role": "user", "content": "..."}One binary replaces four managed services. Cut infrastructure costs by 70-80%.
| Service | Traditional Stack | HeliosDB Lite |
|---|---|---|
| PostgreSQL (RDS) | $50/mo | $0Self-hostedSingle binary |
| Vector DB (Pinecone) | $70/mo | |
| Cache (Redis) | $25/mo | |
| Object Storage (S3) | $10/mo | |
| Total | $155/mo | $0/mo |
Reduce infrastructure complexity. Single service instead of 4-5. Simpler security posture, easier compliance (SOC 2, GDPR), and 70-80% lower total cost of ownership vs. managed services.
Faster time-to-market. No infrastructure setup meetings. Developers productive in minutes. Built-in features eliminate build-or-buy decisions for vector search, caching, and auth.
Focus on product, not plumbing. One connection string, one query language, one mental model. PostgreSQL compatibility means your existing skills and tools work immediately.
First-class vector support. HNSW with tunable parameters, Product Quantization reduces storage 8-16x, hybrid queries combine vectors + SQL filters, and Schema Inference generates DDL from JSON.
HeliosDB Lite is designed for production teams that need a powerful, feature-rich database with modern API capabilities and intelligent caching.
Multi-tenant SaaS with Row-Level Security, connection pooling via HeliosProxy, and stored procedures in four SQL dialects for seamless enterprise migration.
Deploy at the edge with a compact 60 MB binary. HeliosCore's O_DIRECT I/O and SIMD vector search deliver consistent performance on edge hardware.
95%+ SQL compatibility, wire protocol support, and multi-dialect stored procedures make migrating from PostgreSQL, Oracle, or SQL Server straightforward.
Built-in MCP server, gRPC/REST APIs, and SIMD-optimized vector search create the ideal foundation for AI agent memory and autonomous systems.
The most popular HeliosDB tier. Download free and start building production-grade applications.