Skip to content
HeliosDB HeliosDB Full

Tutorial: Multi-Protocol Access

Tutorial: Multi-Protocol Access

Level: Intermediate | Time: 10 minutes | Version: 7.2.0

HeliosDB supports 14 protocol adapters — access the same data from any client.

Start with Multiple Protocols

Terminal window
heliosdb-full \
  --postgres-port 5432 \
  --enable-redis --redis-port 6379 \
  --enable-mysql --mysql-port 3306 \
  --enable-mongodb --mongodb-port 27017 \
  --enable-cassandra --cassandra-port 9042 \
  --enable-oracle

Protocol Status

-- From psql:
SHOW PROTOCOLS;
-- Returns all 14 protocols with status and ports


-- Detailed status for one protocol
SHOW PROTOCOL redis;
SHOW REDIS STATUS;
SHOW MONGODB STATUS;

Same Data, Different Clients

Terminal window
# Write via PostgreSQL
psql -c "CREATE TABLE users (id SERIAL, name TEXT, email TEXT);"
psql -c "INSERT INTO users (name, email) VALUES ('Alice', 'alice@example.com');"


# Read via Redis
redis-cli GET "users:1"


# Query via MySQL
mysql -h 127.0.0.1 -P 3306 -e "SELECT * FROM users;"

Protocol Auto-Detection

HeliosDB auto-detects the protocol from the first bytes of any connection:

  • PostgreSQL: startup message (0x00030000)
  • Redis: RESP2 markers (*, $, +, :, -)
  • MongoDB: OP_MSG wire protocol
  • MySQL: server-first handshake (fallback)
  • Cassandra: native protocol v4/v5
  • Oracle: TNS CONNECT (0x01)
  • SQL Server: TDS PRELOGIN (0x12)
  • DB2: DRDA EXCSAT (0xD0)
  • HTTP: GET/POST/PUT/DELETE

REST API

Terminal window
# Health check
curl http://localhost:8443/health


# Server status
curl http://localhost:8443/api/v1/status


# Admin endpoints
curl http://localhost:8443/api/v1/tables
curl http://localhost:8443/api/v1/dashboard
curl http://localhost:8443/api/v1/admin/storage
curl http://localhost:8443/api/v1/admin/protocols