OnChain Software Data Catalog
Overview
This data catalog serves as the central information hub for OnChain Software's blockchain data infrastructure. Designed specifically for our internal team, it provides comprehensive documentation for our node architecture, data schemas, and integration patterns used across all OnChain Software products and services.
Our infrastructure is built around a high-performance Erigon client that synchronizes blockchain data into a ClickHouse database, supporting our trading algorithms, analytics platforms, and customer-facing products with reliable real-time data access.
Quick Navigation
🏗️ Architecture & Infrastructure
- Infrastructure: Technical architecture, data pipeline, and supported networks
- Data Access: Integration patterns, authentication, and query optimization
🚀 Applications & Use Cases
- Applications: How OnChain Software products use this data infrastructure
- Getting Started: Team onboarding and development workflow
� Data Reference
- Table Schemas: Complete documentation for all database tables
- Glossary: Technical terminology and definitions
- Architecture Diagrams: System visualization
Current Status
Infrastructure
- Production Ready: Single high-performance node with Erigon + ClickHouse
- Real-time Sync: ~12 second blockchain data updates
- Coverage: Complete Ethereum mainnet history from genesis
Data Access (In Development)
- Internal: Direct ClickHouse connections available
- External: API layer under development for customer access
- Integration: MCP server for AI/ML workflows
Available Data
Core Blockchain Data
- Blocks: Block headers and metadata
- Transactions: Transaction details and execution results
- Logs: Smart contract events and logs
DeFi & Trading Data
- DEX Swaps: Decentralized exchange trading data
- Token Prices: Hourly price aggregations
- Uniswap Analytics: AMM trading metrics
Team Resources
For Developers
- Getting Started Guide: Complete onboarding process
- Query Examples: SQL patterns for common use cases
- Performance Guidelines: Optimization best practices
For Product Teams
- Application Integration: How products leverage this infrastructure
- Data Capabilities: Available datasets and update frequencies
Support & Collaboration
This catalog is maintained by the OnChain Software data team. For assistance: - Schema Changes: Coordinate with data team before modifications - Integration Support: Infrastructure team for connection guidance - Performance Issues: Report optimization opportunities - Documentation: Submit pull requests for updates
Last updated: August 2025 | Version controlled via Git