# hhyo/Archery

SQL 审核查询平台

Repository: https://github.com/hhyo/Archery
Canonical: https://ross.abutalabs.com/products/archery
Homepage: https://archerydms.com
Language: Python
License: Apache-2.0
License Family: permissive
Topics: sql-query, data-masking, archery, gh-ost, inception, binlog2sql, sql-audit, mysql, clickhouse, oracle, database-schema, ddl, dml
Last push: 2026-08-26T09:55:29+00:00

## Health v2 (maintenance only)
Score: 82/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 99, release rhythm 50, longevity 100
- inputs: {"age_days": 2896, "days_push": 7, "days_rel": 179, "gap_med": 163.5, "n_releases_24m": 3}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 7018, forks 1853 (observed 2026-08-28T04:09:54.891991+00:00)

## What it is
Archery is a self-hosted SQL audit and query platform built with Django. It provides SQL review, execution, querying, backup, session and account management, and data masking across many database engines including MySQL, Oracle, PostgreSQL, MongoDB, ClickHouse, and more.

## Use cases
- audit and approve SQL changes before execution
- run controlled SQL queries against production databases
- mask sensitive data in query results
- manage MySQL slow query logs and sessions
- generate data dictionaries for databases
- archive old data from MySQL tables
- manage database accounts and instance permissions

## When to choose
- you need a web-based SQL approval workflow with audit trails
- your team needs controlled, permissioned access to many database types
- you want data masking and query governance in one self-hosted tool
- you manage MySQL-heavy infrastructure and need backup, archiving, and slow-log analysis

## When to avoid
- you only need a lightweight ad-hoc SQL client without approval workflows
- you need full audit features for databases other than MySQL/MariaDB/Oracle
- you cannot operate a Django application with Docker or manual deployment

## Facets
- artifact type: application
- maturity: active
- function: database, search-engine, auth, security, monitoring, web-framework
- domain: databases, developer-tools, self-hosted, security, backend
- platform: self-hosted, python
- tags: sql-audit, sql-query, data-masking, database-management, mysql, clickhouse, oracle, ddl, dml, django, web-server, docker, linux

## Member repositories
- hhyo/Archery (main) score 82

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:09:54.891991+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T17:40:38.510720+00:00, confidence not recorded.
  - readme: https://github.com/hhyo/Archery (fetched 2026-08-28T04:09:54.891991+00:00, sha 8571a000a144)
- Data as of 2026-08-30T08:39:29.467469+00:00.