Database (PostgreSQL + Prisma)

Core tables and what they store.

Core entities

routes

Stores every candidate route returned by the engines.

Common fields:

• chains, tokens, input/output

• total fee (structured JSON)

• estimated time

• slippage tolerance + slippage risk

• reliability + liquidity scores

• steps (JSON)

• raw engine payload (JSON)

executions

Tracks each execution attempt.

• route_id, user_wallet, transaction_hash

• expected vs actual output/time/fee

• failure reason

• failover attempted + retry count

engine_reliability

Reliability metrics used by scoring.

• totals, success rate

• average execution time

• uptime

• consecutive failures

• health flags

quote_cache

Caches recent quote results to reduce engine load.

user_preferences

Per-wallet defaults:

• default strategy

• custom weights

• max slippage

• chain allow/deny lists

api_keys / api_usages

Developer keys and per-request usage logs.