openLooKeng vs QoreDB

openLooKeng is a free, open-source data virtualization engine that lets teams query disparate systems through one SQL interface. It analyzes data where it resides, adding sources through connectors without requiring migration. Listed examples span relational databases, NoSQL systems, Hive, MPP warehouses, MySQL, Oracle, HBase, Elasticsearch, and Kafka. Queries can involve data centers, hybrid clouds, and geographically remote clusters using hierarchical deployment and cross-region plan optimization. Huawei describes interactive, batch, and streaming workloads, while noting that the first version supported interactive queries. Features include front scheduling, cross-source indexing, dynamic filtering, cross-source collaboration, horizontal scaling, and Coordinator active-active availability. The project is based on the open-source Presto SQL engine and uses Apache License 2.0. It is self-hosted, with Linux scripts for single-node, multi-node, and offline installation. Windows clients can connect through an ODBC driver supporting Windows 10 64-bit and Windows Server 2016 64-bit.

QoreDB is a desktop client for exploring, querying, and editing SQL and NoSQL databases on Linux, macOS, and Windows. It supports 34 database engines, including PostgreSQL, MySQL, MongoDB, Redis, Snowflake, BigQuery, and Cassandra. Its SQL and Mongo editors provide autocomplete, linting, and query history; a data grid supports bulk editing and advanced filters. Schema tools include interactive ER diagrams, Table Insights, and DDL management for tables, foreign keys, and indexes. Core includes an Argon2-encrypted credential vault, SSH tunneling, production safety rules, and a basic audit log with redaction. A read-only MCP server can be enabled for selected connections and is compatible with Claude Desktop, Claude Code, and Cursor. Pro adds an AI assistant using your own OpenAI, Anthropic, or Ollama key, plus sandbox mode, Time Travel, visual data diff, advanced audit logging, and exports. Core is free. Pro costs €49.00 EUR as a one-time payment; Team costs €99 per seat per year. Enterprise pricing is by custom quote.