# jly8866/archer

基于inception的自动化SQL操作平台，支持SQL执行、LDAP认证、发邮件、OSC、SQL查询、SQL优化建议、权限管理等功能，支持docker镜像

Repository: https://github.com/jly8866/archer
Canonical: https://ross.abutalabs.com/products/archer
Language: JavaScript
License: Apache-2.0
License Family: permissive
Topics: sql, inception, mysql, devops, python, django, web
Last push: 2023-07-25T21:51:06+00:00

## Health v2 (maintenance only)
Score: 23/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 0, release rhythm 8, longevity 100
- inputs: {"age_days": 3561, "days_push": 1135, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1566, forks 630 (observed 2026-08-28T04:05:04.422871+00:00)

## What it is
Archer is a self-hosted web platform for automated SQL operations on MySQL, built on Django and the Inception SQL audit engine. It provides ticket-based SQL review and execution, query permissions, dynamic data masking, slow query management, and email notifications.

## Use cases
- submit SQL changes for automated and manual review before executing on production MySQL
- manage database query permissions down to the table level with approval workflows
- mask sensitive data in query results dynamically
- analyze and browse slow query logs from a web UI
- schedule SQL executions and roll back changes with one click
- run and monitor pt-osc schema changes online

## When to choose
- your team needs a DBA approval workflow for MySQL schema and data changes
- you want centralized, audited SQL execution with rollback support
- you need fine-grained MySQL query permissions and data masking in a self-hosted tool

## When to avoid
- you use databases other than MySQL
- you need a lightweight CLI tool rather than a full web platform
- you require actively developed software with modern framework versions (it uses old Django and depends on the unmaintained Inception fork)

## Facets
- artifact type: application
- maturity: maintenance
- function: database, auth, authorization, web-framework, monitoring, email, workflow-automation, developer-tools
- domain: databases, self-hosted, developer-tools, backend
- platform: python, self-hosted
- tags: sql-audit, mysql, inception, sql-review, django, database-operations, slow-query-analysis, data-masking, ticket-workflow, devops, linux, docker, web-server

## Member repositories
- jly8866/archer (main) score 23

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:04.422871+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-30T04:00:09.232190+00:00, confidence not recorded.
  - readme: https://github.com/jly8866/archer (fetched 2026-08-28T04:05:04.422871+00:00, sha 37bcde262049)
- Data as of 2026-08-30T08:39:29.467469+00:00.