NineData vs Archery

NineData and Archery both support database DevOps workflows. Archery focuses on one-stop SQL audit, while NineData provides a broader database DevOps platform with more capabilities and database types.

NineData provides a permanently free SaaS edition of Database DevOps Professional Edition for up to 10 data sources. Teams can sign up and start using it without preparing application servers or database hardware.

Features Comparison

Category	Feature	Archery	NineData
Basic Abilities	Deployment Mode	On-premise	Cloud (SaaS), On-premise
	Open Source	Open source, Apache V2 license, advanced features charged	Not open source, free for up to 10 database instances (Cloud mode), charged for more than 10
	Supported Data Sources	9	100+
	Cloud Platform Adaptation	Alibaba Cloud RDS MySQL	Alibaba Cloud, Tencent Cloud, Huawei Cloud, Baidu Cloud, China Mobile Cloud, AWS, GCP
	Login Mode	Username/password, SSO(LDAP)	Username/password, SSO(LDAP), WeChat
	Supported Languages	Chinese	Chinese, English
Database DevOps	SQL Console	Supported	Supported
	Object Visualization Management	❌	Supported for tables, views, stored procedures, functions, triggers, events
	Query Result Set Operations	View	View, modify, search, filter, export
	Session Isolation	❌	Supported
SQL Audit and Deployment	SQL Change Release	Supported	Supported
	Change Automatic Backup	Supported	Supported
	Approval Process	Supported	Supported
	OnlineDDL	Supported	Supported
	OnlineDML	❌	Supported
	Built-in SQL Specifications	100+	100+
	Mobile Approval	❌	Supported
	Release Process Orchestration	❌	Supported
Data Security	Sensitive Data Protection	Supported but not rigorous, easily bypassed	Supported
	Permission Authorization Mode	Administrator authorization, user-initiated application	Administrator authorization, user-initiated application
	Permission Model	Users, roles, data sources, groups	Users, roles, data sources, environment groups
	Operation Audit	Supported	Supported
Advanced Data Processing	Data Import	❌	Supported
	Data Export	❌	Supported
	Data Archiving	Supported for MySQL (using pt-archiver plugin)	Supported
	Data Tracking	Supported for MySQL (using binlog2sql plugin)	Supported for MySQL
	Database Union Query	❌	Supported
Performance Diagnosis	Slow SQL Performance Analysis	Supported	Supported
Performance Diagnosis	Session Management	Supported for MySQL	Supported
Others	AI Big Model Integration	❌	Supported, providing Text2SQL, AI SQL diagnosis, ChatDBA

Difference 1: Product Installation and Deployment Mode

NineData: The default option is Cloud (SaaS). Users can register on the official website and start using NineData immediately. NineData also provides on-premise deployment for enterprises with stricter data compliance requirements. On-premise deployment requires prepared application and database servers.
Archery: Archery is an open-source product and is only available for local installation and deployment. It requires prepared application and database servers.

Difference 2: Open Source and Free

NineData: Code is not open source. The Cloud platform provides a permanent free version of the Professional Edition with support for up to 10 data sources. More than 10 data sources require payment.
Archery: Open source, licensed under Apache.

Difference 3: Supported Database Types

NineData: Supports more than 100 types of databases including MySQL, Oracle, PostgreSQL, SQLServer, MongoDB, Dameng, OceanBase, PolarDB, AWS Aurora, ClickHouse, and Doris.
Archery: Supports MySQL, PostgreSQL, Oracle, SQL Server, Redis, MongoDB, ClickHouse, Cassandra, and ODPS.

Difference 4: Cloud Platform Support

NineData: Supports mainstream cloud platforms such as Alibaba Cloud, Huawei Cloud, Tencent Cloud, Baidu Cloud, China Mobile Cloud, and AWS. NineData can retrieve cloud database information through cloud platform APIs and supports private network connectivity through VPC.
Archery: Supports Alibaba Cloud RDS.

Difference 5: SQL Console

The SQL Console is the primary workspace where developers operate databases, similar to a database client. Both products support this capability.

NineData: Provides an experience similar to Navicat or DBeaver, including object navigation and visual operations for tables, views, stored procedures, and other objects. SQL editing includes intelligent prompts, and result sets support editing, copying, searching, sorting, and exporting. Enterprises can reduce reliance on separate database client tools.
Archery: Provides basic capabilities for SQL editing, code prompting, and query result display.

Difference 6: SQL Audit and Deployment

Archery provides standard SQL task submission, review, execution, and change data backup features. MySQL databases support OnlineDDL.

In comparison to Archery, NineData has the following advantages:

OnlineDML: Valuable for large-scale data corrections because large-scale database corrections may affect business and require DBAs to convert them into batch executions. NineData provides built-in automated OnlineDML capabilities to improve operational efficiency and database stability.
SQL Task Pause: During the execution of SQL tasks, users can manually pause them.

Difference 7: SQL Development Specifications

SQL development specifications are an important part of enterprise database development standards, including primary keys, field types, and field naming conventions. Traditional database clients usually do not provide these capabilities, which makes them a core part of database DevOps products.

NineData: Supports over 100 audit specifications.
Archery: Supports over 100 audit specifications.

Difference 8: Sensitive Data Protection

Databases typically store business-sensitive data such as customer phone numbers and bank card numbers. Traditional client tools do not provide sensitive data desensitization protection, which can easily lead to sensitive data leakage. NineData and Archery both provide data desensitization capabilities.

NineData: Provides sensitive data identification and masking capabilities for complex SQL statements.
Archery: Although it has sensitive data field configuration, SQL-based access may bypass the protection. Evaluate this carefully before using it in production.

Difference 9: Permission Handling Modes

Both NineData and Archery provide the capability for administrators to grant permissions in the backend and for users to actively apply for permissions.

Difference 10: Multi-language Support

NineData: Chinese, English.
Archery: Chinese.

Advanced Features Supported by NineData but Not Archery

Data Import: Suitable for importing large amounts of data into databases. Each file supports up to 5 GB and supports SQL scripts or CSV file formats.
Data Export: Suitable for quickly exporting data, supports automatic data export desensitization, and allows selection of entire databases, multiple tables, or export via SQL statements.
Data Archiving: Suitable for archiving and cleaning historical data, with configurable cleaning rules and scheduled execution.
Data Tracking: Supports querying historical data change tracking, suitable for quickly rolling back operations after mistakes. Currently supports MySQL databases.
Session Management: Supports real-time query of database session status, killing sessions, and statistics grouping by client, login user, and session status.
Slow SQL Management: Supports automatic collection, analysis, and diagnosis of historical SQL executions in databases.
Development Process Orchestration: Provides database CI/CD capabilities, supporting enterprises to configure database release processes for development, testing, production, and other environments.
AI Big Model Integration: Based on large model AI technology, it provides innovative capabilities such as natural language generation of SQL, intelligent SQL optimization, and ChatDBA.