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.
Star history
How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.
