hhyo/Archery
Archery
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.
Features
- SQL Execution Audits - Provides a multi-stage approval workflow to review and audit SQL execution for security and compliance.
- Database Management Platforms - Provides a centralized platform for controlling and managing multiple database instances and their queries.
- Database Schema Managers - Provides a declarative toolset for managing and versioning database structures across environments.
- Multi-Database Connections - Implements a unified driver layer to manage and coordinate multiple independent database connections.
- Online Schema Migration Tools - Provides triggerless utilities to modify large database table structures without causing downtime.
- Schema Migration Tools - Provides utilities for generating and managing scripts to update database schemas without locking tables.
- SQL Query Optimizations - Provides capabilities to analyze query patterns, suggest index improvements, and optimize SQL statements for faster execution.
- MyBatis XML Parsers - Provides a tool to convert MyBatis XML mapping files into readable SQL for query review.
- Schema Comparison Tools - Analyzes metadata across environments to generate synchronization scripts for aligning table structures.
- Mapping-to-SQL Parsers - Converts complex XML mapping files into readable SQL statements for query review.
- SQL Performance Analysis - Analyzes executed SQL statements and processing times to identify and resolve performance bottlenecks.
- Mapping-to-SQL Converters - Converts application mapping files into executable SQL statements to facilitate manual review.
- SQL Readability Reviews - Converts XML mapping files into readable SQL to review queries generated by application frameworks.
- Schema Alignment Tools - Compares and aligns database table structures across different environments to maintain consistency.
- Log File Parsing - Transforms raw database slow query logs into structured data for performance visualization.
- Slow Query Analyzers - Identifies and reports database queries exceeding latency thresholds by parsing slow query logs.
