Connect your data, see it work,
pass the value on
CKN ACE is a data platform that puts database connections, cross-system queries, ETL, live monitoring and REST APIs in one place.
Your platform. Every heartbeat.
Live Monitor shows data moving from sources through pipelines and views to REST endpoints.
One SQL statement across three databases
Ask sales, stock and customer data together, then save the answer as a view.
One question should not need three systems
Sales, stock and customer data usually sit in different databases. CKN ACE connects them all in one place and answers with a single SQL statement.
The old way: open each system, export files and combine them by hand
| Product | Sold | Stock | Status |
|---|---|---|---|
| Insulated tumbler | 2,501 | 48 | Ready to sell |
| Arabica coffee | 2,501 | 7 | Restock |
| Coffee maker | 2,498 | 3 | Restock |
Real output from the demo dataset
CKN ACE in 90 seconds
Which data sources it supports
Nine kinds connect directly. Each connection can be read-only or read-write.
SQL databases
- PostgreSQLReadWriteQuery
- MySQLReadWriteQuery
- OracleReadWriteQuery
- Microsoft SQL ServerReadWriteQuery
Document database
- MongoDBReadWriteQuery
Files
- ExcelReadWrite
- CSVReadWrite
- JSONReadWrite
- NDJSONReadWrite
Business systems
- SAPThrough export files
Bring SAP data in as Excel or CSV files and use it in queries and pipelines at once. Ask our team about a direct SAP connection.
Write = usable as a pipeline target · Query = can be queried directly with SQL or a Mongo filter
Everything from connecting data to delivering it
Connect every source
- Set each connection to read-only or read-write
- Catalog: column search, data profiles, ER diagrams and schema-drift detection
- Connection passwords encrypted with AES-256-GCM
Ask across databases in one statement
- Federated SQL on DuckDB, pushing filters down to each source
- Native mode runs read-only on a single database
- Save queries, schedule them, run in the background, export CSV, Parquet or JSON
Extract, transform and load in one place
- A guided wizard: source → target → column mapping → preview
- A drag-and-drop canvas for complex jobs, with 17 transform operators
- Readiness checks and previews before any real write, cron schedules and incremental loads
- Every version kept and restorable
See every job live, trust every dataset
- 5 dashboards: Flow map, Data pulse, Control room, Freshness & quality, Query & API
- Refreshes every 2 seconds, and running jobs can be cancelled
- Rows that fail a rule are quarantined, then replayed once fixed
- Alerts in the product and over webhooks
Deliver as a REST API
- Views served live, cached or materialised
- GET endpoints with limit, offset, select, filters and orderBy, plus an OpenAPI 3.1 file
- A trigger API to start pipelines from other systems, and signed webhooks to receive data
- An MCP server for AI agents
One SQL statement across PostgreSQL, MongoDB and a CSV file
Write ordinary SQL and refer to each source by name. CKN ACE handles the rest.
-- orders: PostgreSQL, customers: MongoDB, rates: CSV file
-- one statement, filters are pushed down to each source
SELECT o.id, c.name, sum(o.total) AS total
FROM business_sales.public.orders AS o
JOIN crm.customers AS c ON c.id = o.customer_id
LEFT JOIN files."samples/rates.csv" AS r ON r.currency = o.currency
WHERE o.created_at >= $since AND c.country = 'TH' AND (o.total > 100 OR o.status = 'vip') AND o.status IN ('paid', 'shipped')
GROUP BY 1, 2 ORDER BY total DESC LIMIT 50Control over every access
Your business data stays in your source databases. CKN ACE keeps only its configuration and run history, in PostgreSQL.
OAuth 2.1 built in
Authorization code + PKCE, refresh tokens, client credentials and RS256 tokens
Fine-grained access
Scopes dp:read, dp:write and dp:admin, with read/write rights per connection
Request protection
CSRF, idempotency, rate limits, security headers and an audit log
Secrets kept safe
Credentials encrypted with AES-256-GCM, passwords hashed with scrypt
Read-only queries
Native queries on PostgreSQL, MySQL and Oracle run in read-only transactions
Run it yourself
Node.js 24 and PostgreSQL, with a Docker image and a separate worker for scheduled jobs
Download the product details
Frequently asked questions
What is CKN ACE?
Which data sources does CKN ACE support?
How does it query across several databases?
Does CKN ACE move my business data into itself?
Can it expose data as an API for other systems?
How is CKN ACE deployed?
See CKN ACE work on your own data
We will connect a sample of your sources, build the first pipeline and expose it as an API, all in one meeting.