back to home
hhyo / Archery
SQL 审核查询平台
6,807 stars
1,814 forks
273 issues
PythonShellMustache
AI Architecture Analysis
This repository is indexed by RepoMind. By analyzing hhyo/Archery in our AI interface, you can instantly generate complete architecture diagrams, visualize control flows, and perform automated security audits across the entire codebase.
Our Agentic Context Augmented Generation (Agentic CAG) engine loads full source files into context, avoiding the fragmentation of traditional RAG systems. Ask questions about the architecture, dependencies, or specific features to see it in action.
Repository Summary (README)
Preview<div align="center">
<a href="https://archerydms.com/" target="_blank" rel="noopener noreferrer">Archery</a>
<h4> SQL 审核查询平台<h4>
功能清单
| 数据库 | 查询 | 审核 | 执行 | 备份 | 数据字典 | 慢日志 | 会话管理 | 账号管理 | 参数管理 | 数据归档 |
|---|---|---|---|---|---|---|---|---|---|---|
| MySQL | √ | √ | √ | √ | √ | √ | √ | √ | √ | √ |
| MsSQL | √ | × | √ | × | √ | × | × | × | × | × |
| Redis | √ | × | √ | × | × | × | × | × | × | × |
| PgSQL | √ | × | √ | × | × | × | × | × | × | × |
| Oracle | √ | √ | √ | √ | √ | × | √ | × | × | × |
| MongoDB | √ | √ | √ | × | × | × | √ | √ | × | × |
| Phoenix | √ | × | √ | × | × | × | × | × | × | × |
| ODPS | √ | × | × | × | × | × | × | × | × | × |
| ClickHouse | √ | √ | √ | × | × | × | × | × | × | × |
| Cassandra | √ | × | √ | × | × | × | × | × | × | × |
| Doris | √ | × | √ | × | × | × | √ | × | × | × |
快速开始
系统体验
| 账号 | 密码 |
|---|---|
| archer | archer |
Docker
参考 https://github.com/hhyo/archery/wiki/docker
手动安装
运行测试
python manage.py test -v 3
依赖清单
框架
前端组件
- 菜单栏 metisMenu
- 主题 sb-admin-2
- 编辑器 ace
- SQL美化 sql-formatter
- 表格 bootstrap-table
- 表格编辑 bootstrap-editable
- 下拉菜单 bootstrap-select
- 文件上传 bootstrap-fileinput
- 时间选择 bootstrap-datetimepicker
- 日期选择 daterangepicker
- 开关 bootstrap-switch
- Markdown展示 marked
服务端
- 队列任务 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解析/切分/类型判断 sqlparse
- MySQL Binlog解析/回滚 python-mysql-replication
- LDAP django-auth-ldap
- 序列化 simplejson
- 时间处理 python-dateutil
功能依赖
- 可视化 pyecharts
- MySQL审核/执行/备份 goInception|inception
- MySQL索引优化 SQLAdvisor
- SQL优化/压缩 SOAR
- My2SQL my2sql
- 表结构同步 SchemaSync
- 慢日志解析展示 pt-query-digest|aquila_v2
- 大表DDL gh-ost|pt-online-schema-change
- MyBatis XML解析 mybatis-mapper2sql
- RDS管理 aliyun-openapi-python-sdk
- 数据加密 django-mirage-field
贡献代码
可查阅主页的开发计划以及依赖清单,在对应Issues中回复认领,或者直接提交PR,感谢你对Archery的贡献
贡献包括但不限于以下方式:
- Wiki文档(开放编辑)
- Bug修复
- 新功能提交
- 代码优化
- 测试用例完善
交流反馈
- 使用咨询、需求沟通:Discussions
- Bug提交:Issues
致谢
- archer Archery 项目是基于 archer 二次开发而来
- goInception 一个集审核、执行、备份及生成回滚语句于一身的MySQL运维工具
- JetBrains Open Source 为项目提供免费的 IDE 授权
<img src="https://resources.jetbrains.com/storage/products/company/brand/logos/jb_beam.png" width="200"/>