Support Tools

Support Tools

openGauss Support Tools Panorama

Mainly for developers and ISVs, it provides six categories of development tools: DataBase Client Tools, Data Import & Export Tool, Data Replication & Synchronization Tool, Monitoring Operation & Maintenance Interface and Tools, Backup & Recovery Interface and Tools, and Common Data Processing Framework.

Connectors

psycopg2

The openGauss Python Driver (Linux only)

py-og

The openGauss pure Python Driver (Multi-OS Support)

go-pq

The openGauss Go Driver

Middleware

ShardingSphere

Distributed database middleware

HAProxy

Database read/write load balancing

vip-manager

Automatic IP failover

Cluster Management

Kubernetes

An open source container management platform

Patroni

Automatic primary/standby switching to improve database availability

Migration Tools

Ora2Pg

Database migration tool from Oracle to PostgreSQL

pg_chameleon

Database migration tool from MySQL to PostgreSQL

pgloader

A data import tool that uses the COPY command to import data into PostgreSQL

Data Synchronization Tools

JdbcPgBackup

Java based multi-platform data import and export tool, similar to pg_dump/pg_restore

Database-Sync

A powerful and flexible database synchronization tool developed based on Java

Debezium

It provides a low latency streaming processing platform for change data capture (CDC)

Data Model

PowerDesigner

Flexible analysis and design features allow you to effectively create a database or data warehouse using a structured approach

Client Tools

DBeaver

Open source multi database client tool

Data Studio

openGauss official client tool

Monitor & DevOps System

Zabbix

It components and services for real-time monitoring, and the monitoring database needs additional adaptation

Prometheus

The open source monitoring system performs very well in recording pure digital time series

Kernel Extension

Yukon

Provide professional GIS (Geographic Information System) ability

Connectors title icon

psycopg2

The openGauss Python Driver (Linux only)

py-og

The openGauss pure Python Driver (Multi-OS Support)

go-pq

The openGauss Go Driver

Middleware title icon

ShardingSphere

Distributed database middleware

HAProxy

Database read/write load balancing

vip-manager

Automatic IP failover

Cluster Management title icon

Kubernetes

An open source container management platform

Patroni

Automatic primary/standby switching to improve database availability

Migration Tools title icon

Ora2Pg

Database migration tool from Oracle to PostgreSQL

pg_chameleon

Database migration tool from MySQL to PostgreSQL

pgloader

A data import tool that uses the COPY command to import data into PostgreSQL

Data Synchronization Tools title icon

JdbcPgBackup

Java based multi-platform data import and export tool, similar to pg_dump/pg_restore

Database-Sync

A powerful and flexible database synchronization tool developed based on Java

Debezium

It provides a low latency streaming processing platform for change data capture (CDC)

Data Model title icon

PowerDesigner

Flexible analysis and design features allow you to effectively create a database or data warehouse using a structured approach

Client Tools title icon

DBeaver

Open source multi database client tool

Data Studio

openGauss official client tool

Monitor & DevOps System title icon

Zabbix

It components and services for real-time monitoring, and the monitoring database needs additional adaptation

Prometheus

The open source monitoring system performs very well in recording pure digital time series

Kernel Extension title icon

Yukon

Provide professional GIS (Geographic Information System) ability