One Query to rule them all, One Language to bind them.

One syntax for every database. OmniQL is a Go library that translates universal queries into native PostgreSQL, MySQL, MongoDB, and Redis commands. No rewrites, no lock-in. Instantly. Free and open-source.

Core Philosophy

The OmniQL Philosophy

Your data layer is more than storage. It's the foundation your entire application builds on. OmniQL keeps your queries stable while everything underneath changes. Switch from MySQL to Postgres, add MongoDB for documents, Redis for caching. Same syntax, any backend. When your infrastructure evolves, your code doesn't have to. Migrations become config changes, not rewrites.

// You write OmniQL
:GET User WHERE id = 42

// PostgreSQL
SELECT * FROM "users" WHERE "id" = 42;

// MySQL
SELECT * FROM `users` WHERE `id` = 42;

// MongoDB
db.users.find({ id: 42 });

// Redis
HGETALL users:42

Universal Compiler

One language. Everywhere.

OmniQL is a compiler, not a wrapper. Every query becomes an AST, then instantly translates to native SQL for Postgres and MySQL, native commands for MongoDB, or native operations for Redis. You write once, the engine handles the rest.

Write Once

Multi-Database

One Syntax

Universal DDL

Define Once.

OmniQL handles more than queries. Define your tables once, the engine translates to native DDL for Postgres, MySQL, and MongoDB. AUTO becomes SERIAL or AUTO_INCREMENT. STRING becomes VARCHAR. Constraints like NOTNULL and UNIQUE just work.

Define Once

Portable

DB Agnostic

// You write OmniQL
:CREATE TABLE User WITH
  id:AUTO,
  name:STRING:NOTNULL,
  email:STRING:UNIQUE

// PostgreSQL
CREATE TABLE "users" (...)

// MySQL
CREATE TABLE `users` (...)

// MongoDB
db.createCollection("users")

Benefits

Why Developers Choose OmniQL

The power of four databases. The simplicity of one.

Polyglot Persistence

Modern apps need the right tool for the job. OmniQL lets you query relational data in Postgres, document stores in Mongo, and hot caches in Redis.

Polyglot Persistence

Modern apps need the right tool for the job. OmniQL lets you query relational data in Postgres, document stores in Mongo, and hot caches in Redis.

Polyglot Persistence

Modern apps need the right tool for the job. OmniQL lets you query relational data in Postgres, document stores in Mongo, and hot caches in Redis.

Zero Latency Overhead

OmniQL translates to native database commands instantly. Your queries run at native speed with no performance penalty.

Zero Latency Overhead

OmniQL translates to native database commands instantly. Your queries run at native speed with no performance penalty.

Zero Latency Overhead

OmniQL translates to native database commands instantly. Your queries run at native speed with no performance penalty.

100% Type-Safe

Catch syntax errors before execution. If your OmniQL query parses, it will translate correctly to any supported backend.

100% Type-Safe

Catch syntax errors before execution. If your OmniQL query parses, it will translate correctly to any supported backend.

100% Type-Safe

Catch syntax errors before execution. If your OmniQL query parses, it will translate correctly to any supported backend.

Zero Vendor Lock-in

Switch from MySQL to Postgres, or AWS to Azure, by changing one line of config. Your queries stay the same.

Zero Vendor Lock-in

Switch from MySQL to Postgres, or AWS to Azure, by changing one line of config. Your queries stay the same.

Zero Vendor Lock-in

Switch from MySQL to Postgres, or AWS to Azure, by changing one line of config. Your queries stay the same.

Standardized DDL

Write a single :CREATE TABLE command, and OmniQL translates it into the correct native structure for Postgres, MySQL, and MongoDB.

Standardized DDL

Write a single :CREATE TABLE command, and OmniQL translates it into the correct native structure for Postgres, MySQL, and MongoDB.

Standardized DDL

Write a single :CREATE TABLE command, and OmniQL translates it into the correct native structure for Postgres, MySQL, and MongoDB.

Instant Onboarding

New developers don't need to learn four different query languages. They learn one simple syntax and can immediately contribute to the full stack.

Instant Onboarding

New developers don't need to learn four different query languages. They learn one simple syntax and can immediately contribute to the full stack.

Instant Onboarding

New developers don't need to learn four different query languages. They learn one simple syntax and can immediately contribute to the full stack.

FAQs

Frequently Asked Questions

Common questions about OmniQL architecture, performance, and compatibility.

Is OmniQL just another ORM?

Does this work with my existing database?

What if I need to run a complex, database-specific query?

Is OmniQL hard to learn?

Is it free to use?

Is OmniQL just another ORM?

Does this work with my existing database?

What if I need to run a complex, database-specific query?

Is OmniQL hard to learn?

Is it free to use?