Datacentric gives your relational database columnar-speed analytics and a single governed endpoint for your AI agents. Take heavy analytics off your primary database and add AI in minutes — no migration, no app rewrite. Your app keeps running exactly as it does today — now enhanced with lightning-fast analytics and AI for what’s next.
Your apps, your dashboards, and now your AI agents all hit the same data. The old answer was a separate system for each — a warehouse, an ETL pipeline, a bespoke AI integration. Datacentric puts ClickHouse behind the relational databases you already run and serves them through one governed interface — no migration and no app changes, so you go from your existing database to live analytics and AI in minutes, not a multi-month project.
Every house lands your data in ClickHouse and serves it — plus your AI agents — through one endpoint, with no migration. The only thing that changes is the on-ramp: Oracle offloads read-only to escape per-core analytics licensing; PostgreSQL and MySQL add write-through, so the gateway is your one endpoint for writes too.
For teams paying for Oracle.
For teams running PostgreSQL.
For teams running MySQL.
The gateway sits between your application and both databases, routing queries to the right engine and keeping data in sync. Two on-ramps get your data into ClickHouse: write-through for PostgreSQL/MySQL (the gateway is your write endpoint), or read-only offload + CDC for Oracle (nothing about how you use Oracle changes). Everything downstream — query, BI, AI — is identical.
Declare tables with ENGINE = columnar (ClickHouse-backed) or ENGINE = relational (local DB only) — or, for Oracle, register_oracle_table to offload an existing table. The hybrid catalog tracks everything.
Your application writes to PostgreSQL or MySQL as usual; rows destined for ClickHouse are enqueued in a transactional outbox — same ACID guarantees. With Oracle, you write nothing here — orahouse reads.
A background worker claims outbox rows, batches them, and applies to ClickHouse via HTTP, with retry and dead-letter handling. For Oracle, an incremental CDC refresh pulls only what changed — cost scales with changes, not table size.
Run SQL against your relational DB, ClickHouse, or both through a single wire-protocol connection or the HTTP API. Cross-engine joins are handled transparently.
Point Claude, opencode, or any MCP client at the gateway. The agent queries relational and columnar data through one endpoint — governed and metered like every other client.
Outgrow background sync? Stream from Kafka or Solace with parallel per-table pipelines. Prometheus metrics, health checks, and dead-letter recovery are built in.
Step-by-step guides for every feature, with copy-pasteable SQL — for Orahouse, Posthouse, and Myhouse.
Point orahouse at the Oracle you already run, offload a table into ClickHouse, and query it from psql, Superset, or an AI agent — in about a minute, no migration.
PosthouseRun Postgres + ClickHouse from one SQL surface, then onboard a table you already have (no migration), dashboard it, and put an AI agent on it — in 5 minutes.
MyhouseRun MySQL + ClickHouse from one SQL surface, then onboard a table you already have (no migration), dashboard it, and put an AI agent on it — in 5 minutes.
Orahouse is read-only to your Oracle, so it offloads rather than enriches — incremental CDC keeps the ClickHouse copy live (watermark, MV-log, or LogMiner). See the Offload Guide.
PosthouseKeep ClickHouse live: enrich Kafka or Solace events through PostgreSQL JOINs into ClickHouse in real time — no ETL to write. Ships with a prebuilt Superset dashboard.
MyhouseKeep ClickHouse live: enrich Kafka or Solace events through MySQL JOINs into ClickHouse in real time — no ETL to write. Ships with a prebuilt Superset dashboard.
Point Claude — or a free local model via opencode — at one endpoint. The agent discovers offloaded Oracle tables by meaning with semantic catalog search, then queries the copy. Any MCP client.
PosthousePoint Claude — or a free local model via opencode — at one endpoint that spans both engines, with semantic catalog search to find tables by meaning. Any MCP client.
MyhousePoint Claude — or a free local model via opencode — at one endpoint that spans MySQL and ClickHouse, with semantic catalog search to find tables by meaning. Any MCP client.
Register Oracle tables, pick a CDC tier (watermark, MV-log, or LogMiner), and read the always-fresh copy — the Oracle—ClickHouse type map and the columnar front door, end to end.
PosthouseHow the gateway keeps two engines in sync: engine modes, the outbox replication pipeline, backfill/join-export, and direct dual-writes.
MyhouseHow the gateway keeps two engines in sync: engine modes, the outbox replication pipeline, backfill/join-export, and direct dual-writes.
OrahousePoint psql, psycopg2, or Superset at the columnar front door — every read hits the ClickHouse copy, never Oracle. Plus a streaming API for large exports.
PosthouseYour existing tools just work — point psql, psycopg2, or Superset at the gateway, no new client to learn. Plus a streaming API for large exports.
MyhouseYour existing tools just work — point the mysql CLI, mysql-connector-python, PyMySQL, or Superset at the gateway, no new client to learn. Plus a streaming API for exports.
All plans include every gateway — Orahouse, Posthouse, and Myhouse. Start standalone — analytics behind your database with no broker — and move up to streaming Kafka/Solace pipelines when you need to let it fly. Evaluating? The free Dev tier is one click away.
Standalone · production workloads
Streaming · your first pipelines
Streaming · let it fly
Streaming · custom scale and support
Prices shown are fixed monthly rates. Online checkout is coming soon — for now, pick a plan, hit Talk to us, and we’ll have your license keys issued within one working day.
A real reply within one working day from one of the people building it — not a sales-floor bounce.
Email contact@datacentric.online for paid-tier inquiries, on-prem deployments, or just to talk through whether this is the right fit. The free Dev tier doesn't need to go through us — click the button to the right and your license keys land in your inbox in seconds.
No credit card. No call required.