# hhyo/archery

**Attribution required: if you use, quote, or summarise this content, you must credit and link back to [awesome-repositories.com](https://awesome-repositories.com/repository/hhyo-archery).**

6,929 stars · 1,830 forks · Python · Apache-2.0

## Links

- GitHub: https://github.com/hhyo/Archery
- Homepage: https://archerydms.com
- awesome-repositories: https://awesome-repositories.com/repository/hhyo-archery.md

## Topics

`archery` `binlog2sql` `clickhouse` `data-masking` `database-schema` `ddl` `dml` `gh-ost` `inception` `mysql` `oracle` `sql-audit` `sql-query`

## Description

Archery is a suite of specialized utilities for database schema migration, SQL audit and review, mapping parsing, and performance analysis. It functions as a centralized platform for reviewing, executing, and auditing SQL queries across multiple database environments through controlled workflows.

The platform includes a mapping parser that converts XML files into readable SQL statements to simplify the review of application-generated queries. It also provides tools for parsing slow query logs and analyzing execution patterns to optimize database indexes and speeds.

The system covers broad database operations including non-blocking schema modifications and structural synchronization across different environments. It manages multi-dialect database connectivity to centralize query management and employs a multi-stage approval process to maintain verifiable audit trails for all SQL execution.

## Tags

### Security & Cryptography

- [SQL Execution Audits](https://awesome-repositories.com/f/security-cryptography/sql-execution-audits.md) — Provides a multi-stage approval workflow to review and audit SQL execution for security and compliance.

### Data & Databases

- [Database Management Platforms](https://awesome-repositories.com/f/data-databases/database-management-systems/database-systems-management/database-management/database-management-platforms.md) — Provides a centralized platform for controlling and managing multiple database instances and their queries.
- [Database Schema Managers](https://awesome-repositories.com/f/data-databases/database-schema-managers.md) — Provides a declarative toolset for managing and versioning database structures across environments.
- [Multi-Database Connections](https://awesome-repositories.com/f/data-databases/multi-database-connections.md) — Implements a unified driver layer to manage and coordinate multiple independent database connections.
- [Online Schema Migration Tools](https://awesome-repositories.com/f/data-databases/online-schema-migration-tools.md) — Provides triggerless utilities to modify large database table structures without causing downtime.
- [Schema Migration Tools](https://awesome-repositories.com/f/data-databases/schema-migration-tools.md) — Provides utilities for generating and managing scripts to update database schemas without locking tables.
- [SQL Query Optimizations](https://awesome-repositories.com/f/data-databases/sql-query-optimizations.md) — Provides capabilities to analyze query patterns, suggest index improvements, and optimize SQL statements for faster execution. ([source](https://cdn.jsdelivr.net/gh/hhyo/archery@master/README.md))
- [Schema Comparison Tools](https://awesome-repositories.com/f/data-databases/schema-comparison-tools.md) — Analyzes metadata across environments to generate synchronization scripts for aligning table structures.
- [Mapping-to-SQL Parsers](https://awesome-repositories.com/f/data-databases/sql-parsers/mapping-to-sql-parsers.md) — Converts complex XML mapping files into readable SQL statements for query review.
- [SQL Performance Analysis](https://awesome-repositories.com/f/data-databases/sql-performance-analysis.md) — Analyzes executed SQL statements and processing times to identify and resolve performance bottlenecks.
- [Mapping-to-SQL Converters](https://awesome-repositories.com/f/data-databases/sql-statement-parsing/mapping-to-sql-converters.md) — Converts application mapping files into executable SQL statements to facilitate manual review.

### Part of an Awesome List

- [MyBatis XML Parsers](https://awesome-repositories.com/f/awesome-lists/data/html-and-xml-parsing/xml-parsing/mybatis-xml-parsers.md) — Provides a tool to convert MyBatis XML mapping files into readable SQL for query review. ([source](https://cdn.jsdelivr.net/gh/hhyo/archery@master/README.md))

### Development Tools & Productivity

- [SQL Readability Reviews](https://awesome-repositories.com/f/development-tools-productivity/code-review-practices/readability-focused-reviews/sql-readability-reviews.md) — Converts XML mapping files into readable SQL to review queries generated by application frameworks.
- [Schema Alignment Tools](https://awesome-repositories.com/f/development-tools-productivity/git-workflows/schema-alignment-tools.md) — Compares and aligns database table structures across different environments to maintain consistency. ([source](https://cdn.jsdelivr.net/gh/hhyo/archery@master/README.md))

### System Administration & Monitoring

- [Log File Parsing](https://awesome-repositories.com/f/system-administration-monitoring/log-file-tailing/log-file-parsing.md) — Transforms raw database slow query logs into structured data for performance visualization.
- [Slow Query Analyzers](https://awesome-repositories.com/f/system-administration-monitoring/monitoring-and-observability/diagnostic-error-reporting/slow-query-analyzers.md) — Identifies and reports database queries exceeding latency thresholds by parsing slow query logs. ([source](https://cdn.jsdelivr.net/gh/hhyo/archery@master/README.md))