1. Project Overview

Archery is positioned as a SQL audit query platform, aiming to improve the work efficiency of DBA, supporting multiple database SQL online and query, and supporting rich MySQL operation functions

2. Open Source License

Licensed under Apache-2.0

3. Screenshots

4. Feature Overview

Function List

Database

Query

Audit

Execute

Backup

Data dictionary

Slow Log

Session management

Account management

Parameter management

Data Archiving

MySQL

√

√

√

√

√

√

√

√

√

√

MsSQL

√

×

√

×

√

×

×

×

×

×

Redis

√

×

√

×

×

×

×

×

×

×

PgSQL

√

×

√

×

×

×

×

×

×

×

Oracle

√

√

√

√

√

×

×

×

×

×

MongoDB

√

√

√

×

×

×

×

×

×

×

Phoenix

√

×

√

×

×

×

×

×

×

×

ODPS

√

×

×

×

×

×

×

×

×

×

ClickHouse

√

√

√

×

×

×

×

×

×

×

5. Tech Stack

Docker

Prepare running configuration

Specifically, refer to: README.md document

Start

Download Releases file, decompress and enter docker-compose file directory

# Start
docker-compose -f docker-compose.yml up -d

# Table structure initialization
docker exec -ti archery /bin/bash
cd /opt/archery
source /opt/venv4archery/bin/activate
python3 manage.py makemigrations sql
python3 manage.py migrate

# Data initialization
python3 manage.py dbshell < sql/fixtures/auth_group.sql
python3 manage.py dbshell < src/init_sql/mysql_slow_query_review.sql

# Create administrator user
python3 manage.py createsuperuser

# Restart service
docker restart archery

# Log viewing and problem troubleshooting
docker logs archery -f --tail=10
logs/archery.log

Access

http://127.0.0.1:9123/

Manual installation

Deployment Instructions

Run Test

python manage.py test -v 3

Dependency List

Framework

• Django
• Bootstrap
• jQuery

Front-end Component

• Menu Bar metisMenu
• Theme sb-admin-2
• Editor ace
• SQL Beautification sql-formatter
• Table bootstrap-table
• Table Editing bootstrap-editable
• Drop-down Menu bootstrap-select
• File Upload bootstrap-fileinput
• Time Selection bootstrap-datetimepicker
• Date Selection daterangepicker
• Switch bootstrap-switch
• Markdown Display marked

Server-side

• Queue Task django-q
• MySQL Connector mysqlclient-python
• MsSQL Connector pyodbc
• Redis Connector redis-py
• PostgreSQL Connector psycopg2
• Oracle Connector cx_Oracle
• MongoDB Connector pymongo
• Phoenix Connector phoenixdb
• ODPS Connector pyodps
• ClickHouse Connector clickhouse-driver
• SQL Parsing/Split/Type Judgment sqlparse
• MySQL Binlog Parsing/Rollback python-mysql-replication
• LDAP django-auth-ldap
• Serialization simplejson
• Time Processing python-dateutil

Functional Dependency

• Visualization pyecharts
• MySQL Audit/Execution/Backup goInception|inception
• MySQL Index Optimization SQLAdvisor
• SQL Optimization/Compression SOAR
• My2SQL my2sql
• Table Structure Synchronization SchemaSync
• Slow Log Parsing Display pt-query-digest|aquila_v2
• Large Table DDL gh-ost|pt-online-schema-change
• MyBatis XML Parsing mybatis-mapper2sql
• RDS Management aliyun-openapi-python-sdk
• Data Encryption django-mirage-field