Skip to main content

IvorySQL

An open source PostgreSQL with Oracle compatibility

Oracle compatibilityApache 2.0 open sourceBuilt on PostgreSQL kernel

IvorySQL is an advanced open source Oracle-compatible PostgreSQL distribution built for strong compatibility and smooth replacement of the latest PostgreSQL. The compatible_mode switch lets you move between Oracle and PostgreSQL modes, while PL/iSQL supports Oracle PL/SQL syntax and package-style development.

Latest VersionIvorySQL 5.1

Core Advantages

From kernel compatibility to ecosystem integration, built for production workloads.

Open Source Core

Apache 2.0 licensed with no vendor lock-in, transparent code, and easy customization.

Deep Oracle Compatibility

PL/iSQL and the ivorysql_ora extension provide strong PL/SQL compatibility for Oracle migrations.

Full-Platform Compatibility

Compatible with mainstream hardware and operating systems, including domestic chip architectures.

Cloud-Native Support

Container-ready support across Docker Compose/Swarm, K8S Operator, and cloud platforms.

Enterprise Support

Backed by HighGo and validated in production-grade enterprise deployments.

Ecosystem Integration

Inherits PostgreSQL SQL completeness, reliability, and ecosystem extensibility.

Broad Scenario Coverage

Covers enterprise workloads, LBS, data warehousing, web/app development, and migrations.

Easy to Use

Reduces management overhead with developer-friendly interfaces and third-party integration.

Application Scenarios

Supports mainstream database workloads from OLTP systems to analytical platforms.

Enterprise Databases

Fits ERP, transaction systems, and finance systems requiring high availability and complex logic.

LBS Applications

Supports geospatial workloads such as O2O and game maps through PostGIS.

Data Warehouse / Big Data

Build analytical platforms with rich data types and robust processing capabilities.

Websites / App Development

Improves website and application efficiency with high-performance database capabilities.

Database Migration

Enables direct migration paths from Oracle databases to IvorySQL.

IvorySQL Installation & Deployment

Based on official docs and release resources, choose package installation, source build, or container deployment to match your environment.

Quick Installation (Recommended)

Follow the official installation guide to prepare dependencies, initialize clusters, and start services quickly.

Installation Guide

Packages & Releases

Use the Releases page to check stable/historical versions and pick proper installation packages for your platform.

View Releases

Container Deployment

Use the official Docker repository for fast setup in development, CI/CD pipelines, and cloud-native environments.

Docker Repository

IvorySQL Ecosystem & Tools

The community provides a rich ecosystem of tools, including client tools, high availability tools, cloud-native tools, monitoring and operations tools, backup and recovery tools, and geospatial tools.

Data Access Middleware

pgpool-IIpgBouncerodysseyHAProxyShardingSphereCitusvip-manager

ORM

GoNodeJSMyBatisHibernate

Standard SQL & Drivers

libpqJDBCODBCNodeJSpsycopg2GoPythonRustRubyADO.NETlib/pqpgx

Client Tools

DBeaverpgAdminNavicatNavicat Premium

Core Extensions

Oracle CompatibilityPG Compatibility & Upstream Tracking

High Availability

pg_rmanWAL-Gpg_probackuppgBackRest

Cluster Management Tools

PatronirepmgrPacemaker Corosync

Monitoring & Operations

PrometheusAlertmanagerpgMonitorGrafanaPoWA

Heterogeneous Access Tools

Debeziumpglogicalmysql_fdworacle_fdw

Multi-Model Database

TimescaleDBDocumentDBPostgreSQL AGEFerretDB

Geospatial

PostGISpgRouting

Machine Learning & AI

pgvectorMADlibpg_ai_query

DDL & Data Loading Tools

pg_bulkloadddlx

Online Demo Platform

postgres-wasmIVYOnlineTrial

Job Scheduling Tools

pg_cronpgAgentpg_jobs

Ecosystem Partnerships

YukonStackGresDatabeneWhaleOps

Migration & Assessment Tools

Ora2PgivyMigrationivyEvaluation

Cloud Ecosystem

Docker ComposePodmanDocker SwarmIvorySQL CloudIvorySQL OperatorIvorySQL Serverless

Operating System (windows / CentOS / Redhat / ubuntu / openEuler / kylin OS / UnionTech OS)

x86 / Kunpeng / LoongArch / Zhaoxin / Sunway / Hygon / Phytium / MIPS / RISC-V

SupportedSupport In ProgressSupport PlannedProprietary Software

IvorySQL Compatibility Certificates

See more compatibility certificates and ecosystem partnerships on the partners page.