Runevault API - Ethereum Data Warehouse

Overview

Runevault is a FastAPI service that exposes read-only endpoints over a dimensional data warehouse for the Ethereum blockchain. Use it to look up addresses, tokens, blocks, transactions, and decoded logs to build portfolio analytics, token dashboards, and on-chain research tools.

Stack: FastAPI SQLAlchemy PostgreSQL Redis
Design: Star schema with dim_* and fact_* tables.
Security: Optional X-API-Key header (see restapi.py), CORS enabled for GET/POST.

Notes

Case: Addresses should be stored and queried in lowercase.
Safety: The /execute endpoint rejects non-SELECT statements and enforces an upper LIMIT.
Models: Responses map to Pydantic classes declared in models.py.