A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All

BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All

PRODUCTS

OceanBase Cloud

OceanBase Database

Tools Connectors and Middleware

QUICK START

OceanBase Cloud OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

OceanBase Developer Center

V4.4.0

Topics Overview
Overview
- What is ODC?
- Features
- Architecture
- Limitations
- ODC console
Quick Start
- Client ODC
  - Overview
  - Install Client ODC
  - Use Client ODC
- Web ODC
  - Overview
  - Deploy Web ODC
  - Use Web ODC
Data Source Management
- Create a data source
- Data sources and project collaboration
- Database O&M
  - Session management
  - Global variable management
  - Recycle bin management
SQL Development
- Edit and execute SQL statements
- Perform PL compilation and debugging
- Use the command-line window
- Edit and export the result set of an SQL statement
- Execution analysis
- Generate test data
- System settings
- Database objects
  - Table objects
    - Overview
    - Create a table
  - View objects
    - Overview
    - Create a view
    - Manage views
  - Materialized view objects
    - Overview
    - Create a materialized view
    - Manage materialized views
  - Function objects
    - Overview
    - Create a function
    - Manage functions
  - Stored procedure objects
    - Overview
    - Create a stored procedure
    - Manage stored procedures
  - Sequence objects
    - Overview
    - Create a sequence
    - Manage sequences
  - Package objects
    - Overview
    - Create a program package
    - Manage program packages
  - Trigger objects
    - Overview
    - Create a trigger
    - Manage triggers
  - Type objects
    - Overview
    - Create a type
    - Manage types
  - Synonym objects
    - Overview
    - Create a synonym
    - Manage synonyms
Import and Export
- Import schemas and data
- Export schemas and data
Database Change Management
- Manage user permissions
  - Users and roles
  - Automatic authorization
  - User permission management
- Project collaboration management
- Risk levels, risk identification rules, and approval processes
- SQL check specifications
- SQL window specification
- Database change management
- Manage changes to logical databases
- Batch database change management
- Online schema changes
- Synchronize shadow tables
- Schema comparison
Data Lifecycle Management
- Data archiving
- Data cleanup
- Manage partitioning plans
  - Manage partitioning plans
  - Set partitioning strategies
  - Examples of partitioning strategies
- SQL plan task
Data Masking and Auditing
- Desensitize data
- Operation records
Notification Management
- Overview
- View notification records
- Manage notification channels
  - Create a notification channel
  - View, edit, and delete a notification channel
  - Configure a custom channel
- Manage notification rules
System Integration
- Login integration
- Approval integration
- SQL approval integration
- Bastion host integration
Deployment Guide
- Deployment overview
- Preparations before deployment
- Deploy ODC in single-node mode
- Deploy ODC in high-availability mode
- Deployment verification
Upgrade Guide
- Upgrade Overview
- Preparations before upgrade
- Update single-node ODC
- Update high-avaliability ODC
- Upgrade verification
- Rollback after upgrade failed
Best Practices
- Tips for SQL development
- Explore ODC team workspaces
- Understanding real-time SQL diagnostics for OceanBase AP
- OceanBase historical database solutions
- ODC SQL check for automatic identification of high-risk operations
- Integration with ODC enterprise-level account system
- Manage and modify sharded databases and tables via ODC
- Data masking and control practices
- Enterprise-level control and collaboration: Safeguard every database change
Troubleshooting
- ODC troubleshooting process
- Collect message
  - View the runtime environment and version information
  - View web ODC logs
  - View client ODC logs
  - View end-to-end ODC-related logs
  - View ODC MetaDB data
  - Query the index status in OceanBase Database V4.x
  - Query the index status in OceanBase Database V1.4.x to V3.2.x
  - Collect JVM runtime information
  - Use tcpdump to capture packets
- FAQ
  - Installation of client ODC
  - Web ODC deployment and startup
  - Connection Information
  - Command-line window
  - DDL statement display
Common features
Release Notes
- V4.4
  - ODC V4.4.0
- V4.3
  - ODC V4.3.4
  - ODC V4.3.3
  - ODC V4.3.2
  - ODC V4.3.1
  - ODC V4.3.0
- V4.2
  - ODC V4.2.4
  - ODC V4.2.3
  - ODC V4.2.2
  - ODC V4.2.1
  - ODC V4.2.0
- V4.1
  - ODC V4.1.3
  - ODC V4.1.2
  - ODC V4.1.1
  - ODC V4.1.0
- V4.0
  - ODC V4.0.2
  - ODC V4.0.0
- V3.4
  - ODC V3.4.0
- V3.3
  - ODC V3.3.3
  - ODC V3.3.2
  - ODC V3.3.1
  - ODC V3.3.0
- V3.2
  - ODC V3.2.3
  - ODC V3.2.2
  - ODC V3.2.1
  - ODC V3.2.0

Download PDF

Document Feedback

Topics Overview

Last Updated：2026-04-08 06:00:33 Updated

OceanBase Developer Center (ODC) is a graphical database development tool and a collaborative platform for data development and production change management. ODC is available in two editions: client ODC and web ODC. Client ODC is a lightweight and easy-to-deploy database development tool that supports Windows, macOS, and Linux. Web ODC provides the tool capabilities of client ODC and also provides management and collaboration capabilities. Web ODC focuses on the security, compliance, and efficiency of database changes.

Client ODC

Note

Client ODC does not support project collaboration management, data lifecycle management, and data desensitization and audit features.

Quick start	Common operations	Common issues
Overview	Manage data sources SQL development Import and export Database change management Synchronize shadow tables	General troubleshooting Collect information Common issues

Web ODC

Quick start	Common operations	Common issues
Overview	Manage data sources SQL development Import and export Risk management Data lifecycle management Data desensitization System integration Deployment guide Upgrade guide	General troubleshooting Collect information Common issues

Next topic

What is ODC?