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 и все inline findings одним review.
Требования
Python 3.12+, uv, Docker и доступный из shell migration command.
Установка
uv tool install ai-sql-reviewer==0.2.1
Конфигурация
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.1 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.1 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.1.tar.gz
(22.5 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.1.tar.gz.
File metadata
- Download URL: ai_sql_reviewer-0.2.1.tar.gz
- Upload date:
- Size: 22.5 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
6b81ad56441f4ca7501576c850179fc5b7cd98c044c7f7e6a2a1fdae0c4d9261
|
|
| MD5 |
d5cc0321dcceb7eec321b8af87ea951e
|
|
| BLAKE2b-256 |
293b384db23a0a0f91736252c2f921d5ef3046e2a47eb94cdb20b757ac6b412a
|
Provenance
The following attestation bundles were made for ai_sql_reviewer-0.2.1.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.1.tar.gz -
Subject digest:
6b81ad56441f4ca7501576c850179fc5b7cd98c044c7f7e6a2a1fdae0c4d9261 - Sigstore transparency entry: 2334878463
- Sigstore integration time:
-
Permalink:
not2exe/ai-sql-reviewer@f6af9d2dbb6c57643ecff14a46590b802cb57464 -
Branch / Tag:
refs/tags/v0.2.1 - Owner: https://github.com/not2exe
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
release.yml@f6af9d2dbb6c57643ecff14a46590b802cb57464 -
Trigger Event:
push
-
Statement type:
File details
Details for the file ai_sql_reviewer-0.2.1-py3-none-any.whl.
File metadata
- Download URL: ai_sql_reviewer-0.2.1-py3-none-any.whl
- Upload date:
- Size: 34.3 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 |
9b5706d1bf05a72c947f22282f9053ee12838cffe802bad4dcdcde47ee7edc9a
|
|
| MD5 |
d4a6195d629c31927d1f0de12f6b2c4e
|
|
| BLAKE2b-256 |
42c5e35f8f731e9d45eec390b7f13a788df9c0651cedbf01775a592bc3021854
|
Provenance
The following attestation bundles were made for ai_sql_reviewer-0.2.1-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.1-py3-none-any.whl -
Subject digest:
9b5706d1bf05a72c947f22282f9053ee12838cffe802bad4dcdcde47ee7edc9a - Sigstore transparency entry: 2334878468
- Sigstore integration time:
-
Permalink:
not2exe/ai-sql-reviewer@f6af9d2dbb6c57643ecff14a46590b802cb57464 -
Branch / Tag:
refs/tags/v0.2.1 - Owner: https://github.com/not2exe
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
release.yml@f6af9d2dbb6c57643ecff14a46590b802cb57464 -
Trigger Event:
push
-
Statement type:
