Skip to main content

Introduction to Database DevOps

NineData's Database DevOps is a cloud-native SQL development toolset that offers comprehensive and efficient enterprise-grade functionalities along with high-level security support. It serves as a perfect replacement for similar products, empowering enterprises with enhanced core database management and maintenance capabilities.

Features Overview

Database DevOps offers robust features such as data asset management, data querying, SQL execution, data editing, data import/export, SQL approval workflows, SQL specification prechecks, approval processes, sensitive data protection, and more. These capabilities enable users to efficiently complete data management tasks across different environments, contributing to enterprise digital transformation.

  • Powerful SQL Editor: Supports AI collaboration, intelligent SQL, comprehensive syntax highlighting, auto-completion, object type recognition, error prompts, and more.
  • Comprehensive Access Control: Supports role-based access control (RBAC) for managing permissions at various organizational levels and provides customization for individual user permissions.
  • All-encompassing Toolset: SQL tasks, development processes, data import/export, data tracking, SQL review, batch database changes, slow query analysis, DSQL federated queries, data archiving, and other capabilities provide end-to-end lifecycle management for databases, making database operations and maintenance more efficient and secure.
  • SQL Development Standards: Defines enterprise SQL writing standards with over 200 rules, improving SQL quality, preventing slow SQL queries, and maintaining consistent coding styles to reduce potential errors and performance issues.
  • Approval Workflows: Simplifies complex request, decision, and approval steps with standardized approval processes, enhancing overall efficiency while reducing errors and risks. Configurable workflows cater to various customization needs.
  • SSO Single Sign-On: Centralizes identity management for enterprise members, streamlining user access and enhancing data security by reducing the risk of password leaks.
  • Audit Logs: NineData offers centralized user activity logs and monitoring, allowing enterprises to easily audit user activities, track security events, and take necessary actions.

Version Description

NineData Database DevOps features provide multiple versions aimed at meeting the diverse needs of different user groups, offering a broader range of service options and functionalities.


  • : Free for individual users, it provides powerful database management services including AI services, database development tools, visual table structure design, data import/export, etc.
  • : Provides advanced database management and development tools for professional users to meet more complex requirements and business scenarios. In addition to all the features of the Personal Edition, the Professional Edition further provides enterprise collaboration features such as SQL specification pre-checks, approval processes, user management, role management, and permission control. Additionally, new features such as OnlineDML, data tracking, development pipeline, data archiving, slow SQL analysis, SQL auditing, and DSQL cross-database querying are also added.
  • : Designed for enterprise users, this version offers a comprehensive set of powerful enterprise-level capabilities to meet the demands of enterprise users. Building upon the features of the professional edition, the enterprise edition provides enterprise-level capabilities such as audit logs, SSO (Single Sign-On) login, and more. Additionally, the enterprise edition offers flexible subscription plans to cater to diverse choices for different enterprise scales and needs.
Click to Expand Version Differences Overview

Icon Legend:

  • ✔️: Supported
  • ❌: Not Supported
  • ⭕: Limited Time Support
CategoryFunction NameSubfunctionPersonal EditionProfessional EditionEnterprise Edition
Database DevOpsSQL ConsoleAI Services✔️✔️✔️
Database Development Tool✔️✔️✔️
Execution History✔️✔️✔️
Visual Result Set Editing✔️✔️✔️
Visual Table Structure Design✔️✔️✔️
SQL Standard Checking✔️✔️
Sensitive Columns✔️✔️
SQL TaskSQL Task Submission and Execution✔️✔️✔️
Task Approval Workflow✔️✔️
Standard Checking✔️✔️
Online DDL✔️✔️
Online DML✔️✔️
Development Pipeline✔️✔️
Data ExportExport Task Submission and Execution✔️✔️✔️
Task Approval Workflow✔️✔️
Data ImportImport Task Submission and Execution✔️✔️✔️
Task Approval Workflow✔️✔️
Slow Query-✔️✔️
Batch Data Change in Multiple Instances-✔️✔️
SQL Review-✔️✔️
Data Archiving-✔️✔️
Data Tracking-✔️✔️
Backup and RestoreData BackupLogical Backup
Physical Backup
Data RestoreRestore Logical Backup Data
Restore Physical Backup Data
Backup Set Data Query-
Data ReplicationSame/Heterogeneous Data ReplicationStructure Replication
Full Replication
Incremental Replication
Database ComparisonData Comparison-
Structure Comparison-
Operation and MonitoringConfigure Alert Receivers-✔️✔️✔️
Configure Alert Policies-✔️✔️✔️
View Alert History-✔️✔️✔️
Basic ServicesData Source ManagementAdd Self-built Data Source✔️✔️✔️
Add Cloud Vendor Data Source✔️✔️✔️
Special Data Sources (Oracle, DB2)✔️
Environment Customization51000
Gateway ManagementCreate Gateway✔️✔️✔️
Create Proxy Gateway✔️✔️✔️
Cloud Vendor Access Credentials-✔️✔️✔️
Private Network Connection-✔️✔️✔️
Manage Sensitive Data-3 Data SourcesUnlimited
Standards and ProcessesSQL Development Standards✔️✔️
Approval Processes✔️✔️
Add New Standard✔️
Add New Process✔️
Account ManagementManage OrganizationsCreate Organization✔️✔️✔️
Switch to Organization✔️✔️✔️
View or Edit Organization Information✔️✔️
Data Watermark✔️
Single Sign-On (SSO)✔️
Manage UsersInvite Users✔️✔️
Add New SSO User✔️
Edit Users✔️✔️
Remove Users✔️✔️
Configure User PermissionsUnlimitedUnlimited
Manage RolesAdd New Role✔️✔️
Edit Roles✔️✔️
Delete Roles✔️✔️
Bind Roles✔️✔️
Configure Role PermissionsUnlimitedUnlimited
Permission Application and ApprovalApply for Data Source Permissions✔️✔️
Apply for Database Permissions✔️✔️
Apply for Sensitive Column Permissions✔️✔️
My PermissionsManage My Permissions✔️✔️
Audit LogView Audit Log90 Days3 Years
Message CenterIn-site MessagesReceive In-site Messages✔️✔️
Subscription ManagementConfigure Message Delivery Preferences✔️✔️

Product Advantages

Multi-Data Source Cross-Platform Support
  • Supported Data Sources: MySQL, SQL Server, PostgreSQL, Oracle, Redis, Clickhouse, MongoDB, Elasticsearch, Doris, SelectDB, and more.
  • Supported Environments: Alibaba Cloud, AWS, Huawei Cloud, Tencent Cloud, Mobile Cloud, Baidu Cloud, Self-hosted databases, and more.
Convenient OperationsData source development tools integrate AI services (natural language to SQL, SQL intelligent optimization, heterogeneous database language conversion, AI assistance, etc.), SQL intelligent suggestions, visual table structure design, visual result set editing, and more, simplifying tedious database management tasks and improving work efficiency.
Data Security and PrivacyProvides enterprise-level data security and privacy protection. Common data sources use TLS/SSL transport encryption by default to prevent data leaks. It also includes comprehensive audit logs, role and resource authorization systems, SSO single sign-on, and more to ensure data security, prevent data leaks, and unauthorized access.
Team Collaboration CapabilityFeatures like specification prechecks and approval workflows enhance teamwork and improve data management standards, providing powerful collaboration capabilities to your team.
Rich FunctionalityZero-hassle database management service that allows database object management through a web browser. Supports features such as syntax completion, highlighting, automatic query window saving and recovery, and commonly used SQL saving, enabling developers to perform SQL operations efficiently and accurately.
Professional Technical SupportNineData provides timely technical support responses, resolving various technical challenges and questions encountered during the SQL development process.

Typical Use Cases

Edition Use Cases Description
Database DevOps Personal Edition Individual Developers Designed for individual developers, the free edition provides a user-friendly interface and support for multiple data sources, helping users get started quickly and manage data sources effortlessly. AI conversational queries assist novice developers in writing SQL, lowering the barrier to database use.
Scheduled SQL Execution Needs For users with scheduled SQL execution requirements, SQL tasks can be submitted to execute specific SQL statements automatically at designated times. This is useful for tasks like regularly updating data, generating reports, or executing routine operations.
Database DevOps Professional Edition Small and Medium-sized Enterprise Projects Small to medium-sized enterprise projects require collaboration between developers and database administrators for tasks like database design, complex query writing, and performance optimization.
Unified Database Management Platform Enterprise projects often need access to and management of various databases in different environments and types. Database DevOps supports multiple cloud providers (Alibaba Cloud, Tencent Cloud, Huawei Cloud, Baidu Cloud, AWS, Azure, etc.) and various database products (MySQL, SQL Server, ClickHouse, and more).
Secure Changes For scenarios where SQL data changes submitted by enterprise members require pre-approval to ensure data input compliance and security. Additionally, SQL tasks are supported to manage user-submitted SQL changes, enhancing data management efficiency and security.
Database DevOps Enterprise Edition Large-scale Application Development The Enterprise Edition is suitable for large-scale projects and application development, supporting high-performance queries and large-scale data processing with enterprise-level databases (Oracle, DB2).
Compliance Requirements and Security Event Tracing The Enterprise Edition provides a 3-year audit log retention period, facilitating future audits and regulatory reviews, while also extending the timeliness of security event tracing for enterprises.
Unlimited Sensitive Data Protection Across Data Sources The Enterprise Edition offers unlimited protection for sensitive data across data sources, allowing you to extend sensitive data protection measures to all your business operations.
Custom Specifications and Workflow Requirements Large enterprises often have diverse business scenarios. The Enterprise Edition provides customizable SQL development standards and approval workflows to meet the diverse needs of various business teams.
SSO Single Sign-On Requirements The Enterprise Edition introduces SSO single sign-on functionality, supporting LDAP/OpenLDAP systems. This enables enterprises to easily synchronize enterprise personnel information with the NineData platform, simplifying member login methods, enhancing security, and improving efficiency.
Application Integration Provides console integration entry points, allowing the NineData console to be integrated into other tools, platforms, or applications to meet business customization needs.