Enterprise Databases
Fits ERP, transaction systems, and finance systems requiring high availability and complex logic.
Oracle CompatibilityApache 2.0 Open-SourceBuilt on PostgreSQL
IvorySQL
The Open-Source PostgreSQL for Seamless Oracle Compatibility.
Latest Version: IvorySQL 5.4
Trusted by enterprises worldwide
PostgreSQL 18Kernel Base
Apache 2.0Open Source
55+Ecosystem Tools
Oracle SQLNatively Compatible
Oracle Compatibility
Run Oracle Code. No Rewrite.
- PL/iSQL supports Oracle PL/SQL procedural syntax natively
- ivorysql_ora plugin provides Oracle built-in functions
- compatible_mode switch toggles compatibility on the fly
- Oracle-style Package structures supported out of the box
Oracle syntax → IvorySQL
-- Oracle Package syntax
CREATE OR REPLACE PACKAGE hr_pkg AS
FUNCTION get_salary(emp_id NUMBER)
RETURN NUMBER;
END;
/
-- Oracle built-in functions
SELECT NVL(salary, 0),
TO_DATE('2024-01-01', 'YYYY-MM-DD'),
DECODE(dept_id, 10, 'HR', 'Other')
FROM employees;
✓ 100% Oracle syntax compatible
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.
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 GuidePackages & Releases
Use the Releases page to check stable/historical versions and pick proper installation packages for your platform.
View ReleasesContainer Deployment
Use the official Docker repository for fast setup in development, CI/CD pipelines, and cloud-native environments.
Docker RepositoryIvorySQL 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.
Connectivity & Pooling
Connection pooling, load balancing & horizontal sharding
pgpool-IIMiddleware proxy for PostgreSQL: connection pooling, load balancing, and automatic failover.Visit homepage →pgBouncerUltra-lightweight connection pooler for PostgreSQL, minimizing connection overhead.Visit homepage →odysseyAdvanced multi-threaded PostgreSQL connection pooler by Yandex, designed for high concurrency.Visit homepage →HAProxyHigh-performance TCP/HTTP load balancer widely used for PostgreSQL read/write splitting.Visit homepage →ShardingSphereApache distributed database ecosystem providing sharding, scaling, and encryption for PostgreSQL.Visit homepage →CitusDistributed PostgreSQL extension that horizontally scales your database across multiple nodes.Visit homepage →vip-managerManages virtual IP addresses for PostgreSQL HA clusters, ensuring seamless failover.Visit homepage →
High Availability & Backup
Cluster management, automatic failover & point-in-time recovery
PatroniHA template for PostgreSQL using DCS (etcd/Consul/ZooKeeper) for automatic failover.Visit homepage →repmgrReplication manager for PostgreSQL: manages streaming replication and switchover.Visit homepage →Pacemaker CorosyncOpen-source cluster resource manager providing HA for PostgreSQL and other services.Visit homepage →StackGresProduction-grade PostgreSQL on Kubernetes with automated ops, monitoring, and backups.Visit homepage →pg_rmanOnline backup and recovery manager for PostgreSQL with PITR support.Visit homepage →WAL-GFast cloud-native backup tool using cloud storage (S3, GCS, Azure) with delta compression.Visit homepage →pg_probackupBackup and recovery solution for PostgreSQL with parallel processing and incremental backups.Visit homepage →pgBackRestReliable, feature-rich backup solution with parallel restore and cloud storage support.Visit homepage →Docker ComposeDefine and run multi-container applications; official IvorySQL Docker images available.Visit homepage →PodmanDaemonless, rootless container engine fully compatible with Docker images and compose files.Visit homepage →Docker SwarmNative Docker clustering for deploying IvorySQL in a replicated, highly available setup.Visit homepage →
Developer Tools & Drivers
GUI clients, ORM frameworks & multi-language database drivers
DBeaverUniversal multi-database GUI management tool with ERD, SQL editor, and data export.Visit homepage →pgAdminOfficial open-source PostgreSQL administration and management web application.Visit homepage →NavicatProfessional GUI tool for PostgreSQL with visual query builder and data modeling.Visit homepage →Navicat PremiumMulti-connection GUI tool supporting PostgreSQL, MySQL, Oracle, and more simultaneously.Visit homepage →MyBatisJava SQL mapping framework that eliminates boilerplate JDBC code with flexible SQL control.Visit homepage →HibernatePowerful Java ORM framework with full PostgreSQL and JPQL support.Visit homepage →libpqOfficial C client library for PostgreSQL, the foundation for most language drivers.Visit homepage →JDBCOfficial Java Database Connectivity driver for PostgreSQL (pgjdbc).Visit homepage →ODBCpsqlODBC — official PostgreSQL ODBC driver for Windows and Linux applications.Visit homepage →psycopg2Most popular PostgreSQL adapter for Python, featuring full async support.Visit homepage →pgxHigh-performance PostgreSQL driver for Go with low-level protocol access.Visit homepage →ADO.NETNpgsql — high-performance .NET data provider for PostgreSQL with EF Core support.Visit homepage →lib/pqPure Go PostgreSQL driver (legacy), compatible with database/sql standard interface.Visit homepage →Rubypg gem — the official Ruby interface to PostgreSQL.Visit homepage →Rustrust-postgres — native PostgreSQL driver for Rust, with tokio async support.Visit homepage →GoNodeJSPython
Monitoring & Operations
Metrics collection, dashboards & query performance analysis
PrometheusOpen-source monitoring and alerting toolkit; pairs with pg_exporter for PostgreSQL metrics.Visit homepage →AlertmanagerHandles alerts from Prometheus, routing notifications to email, Slack, PagerDuty, etc.Visit homepage →pgMonitorPre-configured PostgreSQL monitoring stack by Crunchy Data using Prometheus and Grafana.Visit homepage →GrafanaObservability and data visualization platform for dashboards and alerting.Visit homepage →PoWAPostgreSQL Workload Analyzer — query performance insights with historical data.Visit homepage →pg_cronCron-based job scheduler for PostgreSQL, running SQL commands on a schedule inside the DB.Visit homepage →pgAgentJob scheduling agent for PostgreSQL integrated with pgAdmin for scheduled tasks.Visit homepage →pg_jobs
Data Integration & Migration
CDC, heterogeneous access & Oracle-to-PostgreSQL migration
DebeziumCDC platform for capturing row-level database change events in real time.Visit homepage →pglogicalLogical replication extension for PostgreSQL supporting selective table replication.Visit homepage →mysql_fdwPostgreSQL Foreign Data Wrapper for accessing MySQL tables directly from PostgreSQL.Visit homepage →oracle_fdwPostgreSQL Foreign Data Wrapper for querying Oracle databases transparently.Visit homepage →Ora2PgFree open-source tool for migrating Oracle database schemas and data to PostgreSQL.Visit homepage →ivyMigrationivyEvaluationpg_bulkloadHigh-speed data loading tool for PostgreSQL, bypassing WAL for maximum throughput.Visit homepage →ddlxPostgreSQL extension to extract clean, executable DDL scripts from database objects.Visit homepage →YukonDatabeneDatabase testing and synthetic data generation framework for regression and performance tests.Visit homepage →WhaleOps
AI, Geo & Multi-Model
Vector search, time-series, geospatial & graph extensions
pgvectorOpen-source vector similarity search for PostgreSQL, ideal for AI embeddings and RAG.Visit homepage →MADlibApache MADlib — in-database machine learning library for scalable analytics.Visit homepage →pg_ai_queryPostGISAdds spatial and geographic object support to PostgreSQL, the gold standard for GIS.Visit homepage →pgRoutingGeospatial routing extension extending PostGIS for path-finding and network analysis.Visit homepage →TimescaleDBTime-series database built on PostgreSQL with automatic partitioning and compression.Visit homepage →DocumentDBOpen-source document database compatible with MongoDB wire protocol, built on PostgreSQL.Visit homepage →PostgreSQL AGEApache AGE — graph database extension for PostgreSQL supporting openCypher queries.Visit homepage →FerretDBMongoDB-compatible backend using PostgreSQL for storage, enabling Mongo drivers to work.Visit homepage →
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.
Ready to Start Your Migration?
Free, open-source, production-ready. Try IvorySQL today.