# IvorySQL/IvorySQL

Open Source Oracle Compatible PostgreSQL.

Repository: https://github.com/IvorySQL/IvorySQL
Canonical: https://ross.abutalabs.com/products/ivorysql
Homepage: https://ivorysql.org
Language: C
License: Apache-2.0
License Family: permissive
Topics: database, postgresql, ivorysql-database, oracle-compatible, apache-license-2
Last push: 2026-09-02T08:43:31+00:00

## Health v2 (maintenance only)
Score: 94/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 100, release rhythm 83, longevity 100
- inputs: {"age_days": 1765, "days_push": 0, "days_rel": 37, "gap_med": 56, "n_releases_24m": 14}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1053, forks 206 (observed 2026-09-03T02:15:06.238266+00:00)

## What it is
IvorySQL is an open-source, Oracle-compatible fork of PostgreSQL that remains a 100% drop-in replacement for the latest PostgreSQL. It adds an Oracle compatibility mode, PL/iSQL procedural language supporting Oracle PL/SQL syntax and packages, and Oracle built-in functions via the ivorysql_ora extension.

## Use cases
- migrate an Oracle database to open source without rewriting PL/SQL
- run Oracle-style packages and procedures on PostgreSQL
- switch between Oracle and PostgreSQL compatibility modes
- use NVL, DECODE, TO_DATE and other Oracle built-in functions
- self-host an enterprise relational database with Apache 2.0 license
- lift-and-shift Oracle workloads to containers or Kubernetes

## When to choose
- you are migrating from Oracle and want to keep PL/SQL code largely unchanged
- you need PostgreSQL compatibility plus Oracle syntax in one database
- you want an open-source, vendor-lock-in-free Oracle alternative

## When to avoid
- you need a pure vanilla PostgreSQL with no Oracle extensions
- you require full Oracle feature parity such as RAC or advanced Oracle-specific tooling
- you need a lightweight embedded database

## Facets
- artifact type: application
- maturity: active
- function: database
- domain: databases, backend, developer-tools
- platform: windows, self-hosted, cloud
- tags: postgresql, oracle-compatible, pl-sql, database-migration, drop-in-replacement, sql, linux, macos, docker, kubernetes

## Member repositories
- IvorySQL/IvorySQL (main) score 94

## Provenance
- Observed fields: from GitHub, fetched 2026-09-03T02:15:06.238266+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T06:59:19.098068+00:00, confidence not recorded.
  - readme: https://github.com/IvorySQL/IvorySQL (fetched 2026-09-03T02:15:06.238266+00:00, sha c21b633992a8)
  - homepage: https://ivorysql.org (fetched 2026-08-29T13:00:42.557379+00:00, sha 3aa7f77d0425)
  - site_page: https://www.ivorysql.org/docs-installation (fetched 2026-08-29T13:00:42.568631+00:00, sha e0b5ece3a229)
  - site_page: https://www.ivorysql.org/docs-ecosystem (fetched 2026-08-29T13:00:42.570316+00:00, sha c7c1beba9651)
  - site_page: https://docs.ivorysql.org (fetched 2026-08-29T13:00:42.571850+00:00, sha c7541e2a27f0)
  - site_page: https://www.ivorysql.org/releases-page (fetched 2026-08-29T13:00:42.566781+00:00, sha 3c2ee75bcb38)
- Data as of 2026-08-30T08:39:29.467469+00:00.