onnx2oracle 0.1.0

Load ONNX embedding models into Oracle AI Database with one command

onnx2oracle

Load ONNX embedding models into Oracle AI Database with one command.

pip install onnx2oracle
onnx2oracle docker up
onnx2oracle load all-MiniLM-L6-v2 --target local
onnx2oracle verify --target local

Embeddings run entirely in-database via Oracle's VECTOR_EMBEDDING — no external API calls, no network round-trips, no serving layer.

How it works

onnx2oracle downloads a sentence-transformer model from HuggingFace, wraps its tokenizer as ONNX ops, merges it with the transformer body, and appends pooling + L2 normalization. The resulting single-graph ONNX is uploaded to Oracle via DBMS_VECTOR.LOAD_ONNX_MODEL, after which you can query it with:

SELECT VECTOR_EMBEDDING(ALL_MINILM_L6_V2 USING 'hello world' AS DATA) FROM dual;

Presets

Preset	Dims	Size	Pooling
all-MiniLM-L6-v2	384	90 MB	mean
all-MiniLM-L12-v2	384	130 MB	mean
all-mpnet-base-v2	768	420 MB	mean
multilingual-e5-small	384	470 MB	mean
bge-small-en-v1.5	384	130 MB	cls
nomic-embed-text-v1	768	540 MB	mean

Any sentence-transformer-style HuggingFace model also works via --from-huggingface.

Common tasks

# List all presets
onnx2oracle presets

# Load into a cloud ADB
onnx2oracle load all-mpnet-base-v2 --dsn 'app/[e-mail]:1522/xxx_high'

# Load a non-preset model
onnx2oracle load --from-huggingface BAAI/bge-base-en-v1.5 \
  --pooling cls --normalize --dims 768 --name BGE_BASE_EN_V1_5

# End-to-end verification
onnx2oracle verify --target local

Requirements

• Python 3.10+
• Docker (for the local Oracle 26ai Free path) or any Oracle 23ai/26ai instance
• ~2 GB free RAM during model augmentation
• ~1 GB DB storage per preset

Documentation

Full guide at jasperan.github.io/onnx2oracle.

Development

git clone https://github.com/jasperan/onnx2oracle
cd onnx2oracle
conda create -n onnx2oracle python=3.12 -y
conda activate onnx2oracle
pip install -e ".[dev]"
pytest tests/ -v -m "not slow and not integration"

License

MIT.