IvorySQL

Open Source Oracle compatible PostgreSQL

A creative and powerful database based on PostgreSQL with Oracle compatibility, built for reliability and performance.

The Complete Enterprise Database

PostgreSQL reliability, Oracle compatibility, a rich ecosystem, and cloud-native deployment — everything your enterprise needs, in one database.

IvorySQL closely tracks PostgreSQL kernel development and ships new releases in step with each upstream version. The current release is built on the PostgreSQL 18 kernel, introducing Asynchronous I/O and Skip Scan for significant performance gains.

Full SQL compliance & ACID transactions
Native streaming replication & PITR
Asynchronous I/O for higher storage throughput
Skip Scan for faster multi-column index queries

View Documentation

-- Window functions & analytics
SELECT
  dept,
  name,
  salary,
  RANK() OVER (
    PARTITION BY dept
    ORDER BY salary DESC
  ) AS dept_rank,
  AVG(salary) OVER (
    PARTITION BY dept
  ) AS dept_avg
FROM employees
WHERE active = TRUE;

Get Started in Minutes

Choose your preferred way to start using IvorySQL — from local install to instant browser trial.

Quick Install

Install IvorySQL locally with your package manager in minutes

Try it now

Container Deploy

Run IvorySQL in Docker or Kubernetes with official images

Try it now

Online Trial

Try IvorySQL right in your browser — zero setup required

Try it now

Sandboxes

Try IvorySQL in a sandbox environment on PGNexus.ai

Try it now

Why IvorySQL

IvorySQL combines the power of PostgreSQL with Oracle compatibility, open-source freedom, and enterprise-grade reliability.

Open Source

No Vendor Lock-In. Apache 2.0 licensed with full freedom to use, modify, and distribute.

Based on PostgreSQL, with full SQL, rock-solid reliability, and a massive ecosystem.

Oracle Compatible

Migrate your Oracle DB to IvorySQL with built-in compatibility and seamless transition.

Customization

Just download the code and make it as you like. Full source access for any need.

Backed by OpenAtom Foundation

Supported by the OpenAtom Foundation, a non-profit organization dedicated to open-source software development and innovation.

Community Driven

A creative, collaborative community working together to build more possibilities.

Built for Real Business Challenges

From startups to enterprises, IvorySQL powers mission-critical workloads across industries — and solves the pain points database teams face every day.

Trusted across industries & every stage of growth

Finance

Telecom

Government

Energy

Manufacturing

Internet

Startup MVPSMB ProductionEnterprise CoreMission-CriticalMulti-RegionHigh-Concurrency

Challenges we solve

Challenge

Commercial database licensing costs keep climbing

Solution

Apache 2.0 licensed with no per-core fees, no enterprise tiers, and no hidden costs. Run production workloads at any scale — completely free.

Challenge

Oracle migration is risky, expensive, and slow

Solution

Native PL/SQL, packages, cursors, and Oracle-style data types let you lift-and-shift with minimal refactoring — cut migration time and cost dramatically.

Challenge

Juggling separate databases for transactions and analytics

Solution

A unified HTAP engine handles OLTP and real-time analytics in one place — no data pipelines, no sync lag, no duplicated infrastructure.

Challenge

Need domestic OS and CPU compliance for regulated workloads

Solution

Certified on Kylin, UOS, openEuler and x86_64, ARM64, MIPS, LoongArch — ready for Xinchuang and regulated-industry deployments out of the box.

Have a specific use case in mind?

Read customer stories →

Application Scenarios

IvorySQL is designed for diverse enterprise and modern data workloads, from mission-critical systems to AI-powered intelligence.

Enterprise Database

Suitable for ERP systems, transaction platforms, financial systems, and other scenarios requiring high availability and complex business logic.

LBS Applications

Supports geospatial queries (e.g. O2O services, game maps) through PostGIS for location-based applications.

Unified Data Platform

Supports hybrid workloads of OLTP and real-time analytics, meeting enterprise demands for both real-time data services and agile analysis.

AI-Empowered Database

Supports natural language queries (NL2SQL) and AI Agent collaborative reasoning, building a flexible, scalable intelligent database platform.

Database Migration

Direct migration from Oracle Database to IvorySQL, leveraging built-in Oracle compatibility to minimize refactoring effort.

100% Free & Open Source

Apache 2.0 License

IvorySQL is released under the permissive Apache 2.0 License — use it freely for personal, startup, or enterprise workloads. No cost. No paywall. No feature gating.

Join the community→

Free Forever

Apache 2.0 License

Commercial Use