Home / Subagents / database-optimizer

database-optimizer

CronusL-1141/AI-companySubagent

数据层专项:慢查询定位、索引与 schema 调优、迁移。API 与服务层设计用 backend-architect。

ScannedSubagentSource: GitHub
372 stars Updated 24d ago License MIT Context ≈20 tokens in your chat
59popular

Why this score

Stars7/35
Usage (forks)2/15
Upkeep25/25
License15/15
Owner history10/10

This repo hosts 40 subagents, so its 372 stars are split between them (about 9 each) for scoring.

Popularity score: 59/100 from public GitHub signals only. It shows how widely used and maintained this is, not how well it works. Not included yet: the fake-star check. The security scan is shown separately and doesn't change the score. How we rank

What it can use

  • Every tool, because it sets no tools list (it inherits all of yours, including shell and MCP tools)

Model: opus

This agent can act outside your files. Read it before installing, and narrow its tools: line if it needs less.

The agent file

---
name: database-optimizer
description: 数据层专项:慢查询定位、索引与 schema 调优、迁移。API 与服务层设计用 backend-architect。
model: opus
color: teal
isolation: worktree
---

你是数据库优化专家,负责查询性能、索引与数据建模。

- 迁移、DDL 与写入只在本地库上跑,测试库也不算安全区。
- 索引变更附上 EXPLAIN 前后对比,没有对比就说不清改动是否生效。
- 审查由派工方另行安排,不必自己再派审查者复核产出。超出任务范围的发现写进汇报的后续项,不顺手改:顺手的改动落在派工方的审查范围之外。

## 本仓库(AI Team OS)

- 存储是 SQLite 单文件库,不是 PostgreSQL。`pg_stat_statements`、`VACUUM FULL`、连接池调参在这里没有对象。
- 加列须同步 `src/aiteam/storage/connection.py` 的 `COLUMNS_TO_ENSURE`,`create_all` 不补列。

MIT license, from CronusL-1141/AI-company at commit 01ae582d0d38.

Security

Scanned Oct 21, 2026 at commit 01ae582d0d38, with Cisco's open-source skill-scanner.

None of the patterns we list turned up: shell commands, network requests, reading environment variables, downloading and running code, or installing packages.

A scan lists patterns in the code. It can't prove an add-on is harmless, and it can miss things, so read what you install. How we scan

Alternatives

Other makers' add-ons that do the same job, next to this one.

NameScoreStarsContextUpdated
This onedatabase-optimizer CronusL-1141/AI-company · Subagent 59★ 372≈20 in chat24d ago
build-optimizer CharlesWiltgen/Axiom · Subagent Both about optimizer 63★ 1.2k≈28 in chat17d ago
database-expert irahardianto/awesome-agv · Subagent Same job: databases 58★ 156≈21 in chat21d ago
sql-optimizer luanmorenommaciel/agentspec · Subagent Same job: databases 59★ 253≈29 in chat24d ago
context-optimizer athola/claude-night-market · Subagent Both about optimizer 58★ 342≈22 in chat19d ago
harness-optimizer affaan-m/ECC · Subagent Both about optimizer 90★ 284k≈29 in chat16d ago