Architecting enterprise data pipelines, robust DWHs, and *AI*-native data infrastructure.
I am a Data Engineer & AI Data Platform Architect specializing in building reliable enterprise data warehouses (Google BigQuery, ClickHouse, PostgreSQL, MS SQL, SAP HANA), production ETL/ELT pipelines orchestrated with Apache Airflow, algorithmic scoring engines (Lead Heat Scoring), and AI-native data tooling.
My work bridges traditional data engineering with modern AI agent ecosystems — building zero-hallucination AI analytics runtimes, Model Context Protocol (MCP) integrations, and AI-driven automation workflows.
- 🔭 Currently building: OctaSQL, ClawMux & pg_mcp_qauth
- ⚡ Core focus: Enterprise DWH Architecture, Apache Airflow DAG Factories, AI-Native Data Platforms, Causal & Shapley Factor Attribution, Model Context Protocol (MCP)
- 💬 Ask me about: BigQuery & ClickHouse Data Pipelines, Airflow Orchestration, AI Text-to-SQL without hallucinations, Omni-Channel AI Messaging Integration
|
Deterministic Deductive Analytics Engine for Enterprise DWH A next-generation enterprise platform that completely eliminates *AI* Text-to-SQL hallucinations by isolating reasoning in a closed mathematical perimeter.
|
Omni-Channel *AI* Router & Control Plane for OpenClaw A lightweight multi-user control plane and omni-channel *AI* router that dispatches corporate chat traffic to per-user isolated OpenClaw instances over persistent WebSockets.
|
|
OAuth 2.1-Secured Postgres MCP Server with Role & Row-Level Isolation A Model Context Protocol resource server that lets *AI* agents (Claude Code, VS Code) query PostgreSQL safely: JWTs from your own Keycloak/Authentik broker Google, Microsoft, GitHub and AD logins, while access is enforced by real Postgres mechanics.
|
|
┌─────────────────────────────────────────┐
│ User Business Query │
│ "Why did revenue in Siberia drop 14%?" │
└────────────────────┬────────────────────┘
│
▼
┌────────────────────────────────────────────────────────────────────────────────────────┐
│ OCTASQL CORE │
│ │
│ [ 1. Hybrid BM25 Index ] ──► [ 2. DuckDB State Fabric ] ──► [ 3. Deductive Planner ] │
│ (Schemas + Synonyms) (Local State Layer) (Hypothesis Gen) │
│ │ │
│ ▼ │
│ [ 6. Shapley Attribution ] ◄── [ 5. Exec in Engine ] ◄── [ 4. AST Security Sandbox ] │
│ (Delta Decomposition) (Postgres / ClickHouse) (Read-Only Guarantees) │
└──────────────────────────────────────────┬─────────────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────┐
│ Deterministic Factor Report │
│ • Logistics: -68.4% (-$2.34M) │
│ • Discount: -21.1% (-$0.72M) │
└────────────────────┴────────────────────┘
💡 Explore live evidence graphs, factor drill-downs, and counterfactual What-If scenarios in real time at martystev.github.io/octasql-landing.
Corporate Messengers (Mattermost, Telegram, Bitrix24, Slack, VK Teams, MS Teams)
│
▼
ClawMux Router (Multi-Channel Dispatcher)
├─ ProviderRegistry (Chat Adapters Layer)
├─ MappingStorage & Workspace Auto-Provisioner
└─ Persistent WebSocket Connections & Task Triggers
│
▼
Isolated Per-User OpenClaw Workspaces (Workspace #101, Workspace #102, ...)
- LentaBox — Telegram userbot that deduplicates news across your channels and posts each story once (Python)
- NoteObs — seven quick Markdown notes in the macOS menu bar, stored in any folder (Swift)
- MotionSentinel — Android motion alarm for bikes and cars with Telegram alerts and GPS (Kotlin)
- SmsPigeon — Android app that forwards SMS to Telegram via your own bot (Kotlin)
- Keid — free open-source SSTP VPN client for the macOS menu bar with pf kill-switch; works with Keenetic, MikroTik, Windows RRAS, SoftEther (Swift)
Data Warehousing & DBs : Google BigQuery, ClickHouse, PostgreSQL, SAP HANA, Redis
Orchestration & ETL : Apache Airflow (Declarative DAG Factories), Python, Pandas, SQL
AI & Data Platforms : Model Context Protocol (MCP), AI Agent Architecture, Shapley Factor Attribution, AST SQL Parsing
Backend & APIs : FastAPI, Django, AsyncIO, WebSockets, REST API, Webhooks
DevOps & Infrastructure: Docker, Docker Compose, GitHub Actions (CI/CD), Linux, NGINX, VPN / Proxy
- 💬 Telegram: tg.stigione.netcraze.link
- 🌐 OctaSQL Landing Page: martystev.github.io/octasql-landing
- 🐙 GitHub Profile: github.com/MartyStev