v0.1.9

Release Notes - sql-agent v0.1.9

Overview

We are pleased to announce the release of sql-agent v0.1.9, introducing a fully implemented CLI interface and an updated licensing model. This version enhances usability and provides clearer legal terms for both open-source and commercial use.

Key Changes

• CLI Implementation

  • Description: The sql-agent-tool command-line interface is now fully functional, supporting interactive database management with PostgreSQL. Key commands include:
    • init: Initialize database schemas.
    • query: Execute natural language queries.
    • shell: Start an interactive SQL shell.
    • update: Manage database updates (disabled in read-only mode by default).
  • Configuration: Loads config.yaml from the current working directory by default, with support for custom paths via the --config option.
  • Impact: Offers a powerful alternative to script-based usage, improving accessibility for users.

• New Licensing Model

  • Description: Transitioned from the MIT license to Apache 2.0 for open-source use, complemented by a dual-licensing approach with a commercial license defined in COMMERCIAL.md.
  • Details:
    • Apache 2.0 provides enhanced patent protection and redistribution terms, suitable for community development.
    • The commercial license (COMMERCIAL.md) supports proprietary applications.
    • Deprecated EULA.md has been removed to streamline licensing documentation.
  • Impact: Ensures robust open-source terms while enabling commercial flexibility.

Installation

To get started with v0.1.9:

pip install sql-agent-tool

Explore available options:

sql-agent-tool --help

Resources

• Source Code: https://github.com/Dadiya-Harsh/sql-agent
• Commercial License: https://github.com/Dadiya-Harsh/sql-tool/blob/main/COMMERCIAL.md

Feedback

We welcome your input on this release. Report issues or suggest improvements via the repository.

---

Full Changelog: v0.1.8...v0.1.9