Archer

Overview

Archer is an innovative automation SQL operation platform based on Inception, offering a range of functionalities tailored for both database management and operational efficiency. It supports various features such as work orders, auditing, scheduled tasks, and email notifications, making it a versatile choice for teams handling MySQL queries, slow query management, and session management. Designed with an understanding of the operational workflow in mind, Archer fosters more secure and efficient SQL operations through its integrated checks and balances.

This platform not only simplifies complex database interactions but ensures that processes align with best practices in the industry. It combines automation with essential oversight, allowing engineers and DBAs to manage SQL operations confidently while adhering to necessary review protocols.

Features

• Automated SQL Review: Automatically verifies SQL submissions through Inception, ensuring an initial check before human assessment, enhancing safety in deployments.

• Manual Oversight Required: After the automated review, a secondary manual audit by an engineer or manager ensures that operational knowledge is applied to the SQL being executed.

• Rollback Management: Provides an easy one-click rollback option through the work order system, allowing for quick recovery from errors in SQL execution.

• Scheduled Executions: Allows DBAs to configure and modify timings for executing audited SQL statements, providing flexibility for task management.

• Dynamic Data Masking: Incorporates features for on-the-fly data masking to protect sensitive information during queries based on predefined rules.

• Slow Query Analysis: Features tools for analyzing slow logs using Percona Toolkit’s pt_query_digest, enabling efficient identification and management of performance bottlenecks.

• Permission Control: Fine-grained access management at the table level to ensure that users only access data they are authorized to see, enhancing security protocols.

• Email Notifications: Configurable email alerts for various operational stages such as SQL application, permissions requests, and review outcomes, helping maintain communication throughout the workflow.