ai-sql-reviewer
CLI-инструмент для schema-aware ревью изменённых PostgreSQL-запросов в CI.
Возможности
- Извлекает изменённые statements из Git diff и сохраняет номера строк.
- Проверяет синтаксис через SQLGlot до любых модельных вызовов.
- Восстанавливает схему миграциями во временном PostgreSQL-контейнере.
- Запускает независимые performance, architecture и correctness reviews, critic и final reviewer.
- Валидирует все ответы Pydantic-моделями и показывает безопасные предложения как diff.
- Поддерживает console, Markdown и JSON; исходные SQL-файлы не изменяет.
- Публикует краткий GitHub PR summary и findings как inline-комментарии.
Требования
Python 3.12+, uv, Docker и доступный из shell migration command.
Установка
uv tool install ai-sql-reviewer==0.2.0
Конфигурация
dialect: postgres
migrations:
command: ./scripts/migrate.sh
postgres_version: "17"
timeout_seconds: 120
llm:
model: openai/example-model
api_key_env: OPENAI_API_KEY
api_base: null
temperature: 0
timeout_seconds: 60
max_retries: 2
review:
agents: [performance, architecture, correctness]
minimum_confidence: 0.65
max_findings: 10
output:
format: markdown
Секрет хранится только в environment variable, имя которой задаёт api_key_env.
CLI
ai-sql-review review-diff --base origin/main --head HEAD --format markdown
ai-sql-review review-file path/to/query.sql --format console
ai-sql-review review-sql "SELECT * FROM users" --format json
--debug включает технические сообщения orchestration и parser без публикации внутренних model responses.
GitHub Actions
- uses: astral-sh/setup-uv@v9.0.0
- id: review
continue-on-error: true
env:
OPENAI_API_KEY: ${{ secrets.OPENAI_API_KEY }}
run: uvx --from ai-sql-reviewer==0.2.0 ai-sql-review review-diff --base "${{ github.event.pull_request.base.sha }}" --head "${{ github.event.pull_request.head.sha }}" --format json > sql-review.json
- if: always()
env:
GITHUB_TOKEN: ${{ github.token }}
run: uvx --from ai-sql-reviewer==0.2.0 ai-sql-review publish-github sql-review.json --base "${{ github.event.pull_request.base.sha }}" --head "${{ github.event.pull_request.head.sha }}" --repository "${{ github.repository }}" --pull-request "${{ github.event.pull_request.number }}"
Полный пример: examples/github-actions/sql-review.yml.
Ограничения MVP
- Поддерживается только PostgreSQL и миграции, запускаемые одной shell-командой.
- Нет GitHub App, query-plan execution и автоматического применения fixes.
- Качество выводов зависит от выбранной через LiteLLM модели и предоставленной схемы.
Разработка
uv sync
uv run ruff check .
uv run mypy src
uv build
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
ai_sql_reviewer-0.2.0.tar.gz
(22.2 kB
view details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file ai_sql_reviewer-0.2.0.tar.gz.
File metadata
- Download URL: ai_sql_reviewer-0.2.0.tar.gz
- Upload date:
- Size: 22.2 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
8564845222fb5789a93f1eb1df0da3c9c8090fa06e95cf027904c7803dd947ac
|
|
| MD5 |
6d96d8eeea895b9fbe2cc5511173dad5
|
|
| BLAKE2b-256 |
8aa0f9fc12fde2fb466ba62d21be9a67598a3537a9db2ee151af539c88ecb797
|
Provenance
The following attestation bundles were made for ai_sql_reviewer-0.2.0.tar.gz:
Publisher:
release.yml on not2exe/ai-sql-reviewer
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
ai_sql_reviewer-0.2.0.tar.gz -
Subject digest:
8564845222fb5789a93f1eb1df0da3c9c8090fa06e95cf027904c7803dd947ac - Sigstore transparency entry: 2334864755
- Sigstore integration time:
-
Permalink:
not2exe/ai-sql-reviewer@088208d639b0b55d4cc1ad64e654b2d6c52acee9 -
Branch / Tag:
refs/tags/v0.2.0 - Owner: https://github.com/not2exe
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
release.yml@088208d639b0b55d4cc1ad64e654b2d6c52acee9 -
Trigger Event:
push
-
Statement type:
File details
Details for the file ai_sql_reviewer-0.2.0-py3-none-any.whl.
File metadata
- Download URL: ai_sql_reviewer-0.2.0-py3-none-any.whl
- Upload date:
- Size: 34.1 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
1cb2aeeb78198a041b662444c96beb950ff70953117b7a8cbfdba7557b82f626
|
|
| MD5 |
f5083c7eda334d4fdcc92a89783dfff3
|
|
| BLAKE2b-256 |
9ba6a2ea0cf6acce594de820ac868688a016e0f0da7d7a66be9b4753039ded3b
|
Provenance
The following attestation bundles were made for ai_sql_reviewer-0.2.0-py3-none-any.whl:
Publisher:
release.yml on not2exe/ai-sql-reviewer
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
ai_sql_reviewer-0.2.0-py3-none-any.whl -
Subject digest:
1cb2aeeb78198a041b662444c96beb950ff70953117b7a8cbfdba7557b82f626 - Sigstore transparency entry: 2334864764
- Sigstore integration time:
-
Permalink:
not2exe/ai-sql-reviewer@088208d639b0b55d4cc1ad64e654b2d6c52acee9 -
Branch / Tag:
refs/tags/v0.2.0 - Owner: https://github.com/not2exe
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
release.yml@088208d639b0b55d4cc1ad64e654b2d6c52acee9 -
Trigger Event:
push
-
Statement type:
