v0.0.1a6

🎯 Multi-Database Support for Database Migrations

This release introduces a comprehensive database migration system with support for multiple SQL databases (PostgreSQL, MySQL, SQLite), providing developers with maximum flexibility and safety when managing schema changes.

✨ Major Features

Database-Specific Migration Chains

• Multi-Database Support: Separate migration chains for PostgreSQL, MySQL, and SQLite to avoid compatibility issues
• Optimized Migrations: Each database type maintains migrations optimized for its specific SQL dialect
• Auto-Generation: Automatically generates initial migrations if none exist for the database type

Interactive Safety System

• Migration Plans: Rich-formatted display of pending migrations before application
• Confirmation Required: Interactive confirmation (y/n) before applying any schema changes
• TTY Detection: Automatically disables interactive mode in CI/CD environments (GitHub Actions, GitLab CI, etc.)

Flexible Configuration

• CORTEX_AUTO_APPLY_DB_MIGRATIONS - Enable/disable automatic migrations on startup
• CORTEX_DB_MIGRATIONS_IS_INTERACTIVE - Control interactive confirmation behavior
• CORTEX_MIGRATIONS_VERSIONS_DIRECTORY - Custom migration directory support
• CORTEX_ENV_FILE_PATH - Custom environment file path for flexible deployments

Auto load Environment Variables

• python-dotenv Integration: Automatic loading of .env files on startup
• Custom .env Paths: Support for custom environment files via CORTEX_ENV_FILE_PATH
• Debug Output: Improved environment variable diagnostics (excluding secrets)

📦 How to Update

# Using pip
pip install --upgrade "telescope-cortex[api]"

# Using poetry
poetry add telescope-cortex[api]@^0.0.1a6

# Using uv
uv add "telescope-cortex[api]"

Full Changelog: v0.0.1a5...v0.0.1a6