Skip to content

Releases: fuxing0910-hue/sqlite-audit-kit

Release list

v0.2.0 — Portable skill and multi-provider audit tools

v0.2.0 — Portable skill and multi-provider audit tools Latest
Latest

Choose a tag to compare

View all tags
@fuxing0910-hue fuxing0910-hue released this 08 Oct 13:09
v0.2.0
20a59d3

SQLite Audit Kit can now be installed as a portable Agent Skill or registered as function tools in a model API application. Explicit database paths and candidate keys route to read-only scans; before/after snapshots route to measured comparisons.

  • sqlite-migration-audit bundles its Python implementation and MIT license. No checkout, pip installation, API key or network is needed after skill installation.
  • sqlite_audit.agent_tools exports declarations for OpenAI Responses, DeepSeek Chat Completions, Claude Messages and Gemini Interactions, with validated local scan/compare dispatch.
  • English/Chinese READMEs now show a concrete regression result, actual screenshot and working demo. The integration guide explains registration, gate semantics and discovery limits.
  • Local tests cover real synthetic scans/comparisons, read-only behavior, invalid inputs and declaration formats. Portable skill isolation and source synchronization were checked. No live model calls or automatic selection rates were tested.

Requires Python 3.10+ with standard sqlite3. Use the wheel for Python/CLI integrations, or extract the complete skill folder into your application's supported skill location. The optional Skills CLI needs Node.js:

npx skills add fuxing0910-hue/sqlite-audit-kit --skill sqlite-migration-audit

中文：本次增加可独立安装的 Skill，以及 GPT、DeepSeek、Claude、Gemini API 工具声明和本地执行入口。安装或注册后，AI 才有机会选择调用；发布仓库不代表自动进入所有聊天应用。扫描只读，计数比较不保证迁移的业务语义正确；schema SQL、默认值与诊断元数据可能敏感。

Integration guide / AI 接入 · 中文说明 · Synthetic report

Assets 4
Loading

SQLite Audit Kit v0.1.0

SQLite Audit Kit v0.1.0

Choose a tag to compare

View all tags
@fuxing0910-hue fuxing0910-hue released this 08 Oct 12:16
v0.1.0
a00d0a7

Schema-only diffs can miss changes in SQLite data. SQLite Audit Kit collects consistent read-only snapshots and compares columns, indexes, row/NULL counts, storage types, foreign-key violations and explicitly selected candidate-key duplicates.

This first release exports versioned JSON and standalone offline HTML. Its optional regression gate distinguishes counted regressions from incomplete coverage. It uses full scans, exports no row payloads and does not execute migrations. Review included schema SQL and diagnostics before sharing a report.

Downloads:

  • sqlite-audit-demo.html: standalone report from generated synthetic SQLite databases.
  • sqlite_audit_kit-0.1.0-py3-none-any.whl: Python package; install with python -m pip install PATH_TO_WHEEL.

Validation: 21 regression tests including read-only behavior, WAL snapshot consistency, quoted identifiers, HTML escaping, hardlink protection and CLI gate behavior; Windows, Linux and macOS, Python 3.10/3.12/3.14; isolated wheel installation and complete demo workflow.

简体中文与在线演示

中文文档 · 中文项目页 · 直接查看合成数据报告

本版本只读比较 SQLite 更新前后的结构、精确行数、NULL、存储类型、外键违规与指定重复键，输出 JSON 和离线 HTML。可选回归退出码区分违规增加与检查范围不完整。工具执行完整扫描，不运行迁移；报告仍含结构 SQL 与诊断元数据。演示记录全部为虚构。

Loading