Skip to content
This repository was archived by the owner on Apr 16, 2026. It is now read-only.

v0.1.0

Choose a tag to compare

View all tags
@medhabasu medhabasu released this 20 Mar 13:28
· 83 commits to main since this release
v0.1.0
dcc2450

Features

Backend

This release brings significant enhancements to our data analysis and reporting capabilities:

  • Enhanced Report Generation with two major improvements:

    • Multi-agent Report Generation delivers higher quality reports through a three-phase process (data collection, evaluation, and synthesis), resulting in better organization, more comprehensive coverage, and improved logical flow.
    • Citations Functionality adds transparency to reports by clearly referencing information sources, allowing users to verify data origins and build greater confidence in analysis results.

  • Improved PDF and File Management:

    • PDF Search in Fast Analyses enables AI-powered searching through PDF documents with citations, expanding data exploration capabilities.
    • Complete PDF File Management allows uploading, viewing, downloading, and deleting PDF files within projects through an intuitive interface.
    • Streamlined File Upload Experience with a unified endpoint that handles multiple file types more efficiently and sends file binaries directly instead of using base64 encoding.

  • Enhanced Data Processing:

    • CSV and Excel File Cleaning automatically removes irrelevant elements, handles merged cells, standardizes null values, and converts data into SQL-friendly formats, making analysis more accurate.
    • Direct Database Export allows users to export CSV files directly to their selected database rather than always defaulting to the internal database.

  • Improved Administration and Integration:

    • Revamped User Management with new fields, statuses, and improved validation for more efficient user administration.
    • New API Endpoints including a combined tables/files endpoint that simplifies integration by providing a complete view of database resources in a single request.

  • AI Improvements:

    • OpenAI Agents Architecture introduces an experimental foundation for future AI-powered analysis capabilities with specialized analyst, evaluator, and report agents.
    • OpenAI as Default Web Search Tool replaces Gemini, providing significantly improved search results.

Frontend

This release delivers substantial improvements to the user interface and experience:

  • Enhanced Report and Citation Features:

    • Interactive Report Citations allow users to click on citations to automatically select and scroll to corresponding analyses, creating a more intuitive workflow.
    • Citation Support in Analysis Results displays source information for data used in query responses, enhancing transparency and credibility.
    • PDF and Markdown Export Options enable saving and sharing reports in multiple formats without requiring additional software.

  • Improved File Handling:

    • Multiple File Upload Support allows users to upload several files simultaneously instead of one at a time.
    • Real-time Upload Progress Tracking with progress bars and percentage indicators provides better visibility during uploads.
    • Built-in File Validation for extensions and MIME types simplifies implementation and provides specific feedback for invalid files.

  • Enhanced User Interface:

    • Unified Oracle Interface merges query-data functionality into Oracle's embed page, providing a comprehensive data analysis experience.
    • Improved Oracle Search Bar with smooth animations when switching between 'Fast Analysis' and 'Deep Research' modes and an intuitive toggle control.
    • Keyboard Shortcuts for improved navigation: '/' to focus the search bar, 'cmd + m' to toggle mode, and 'cmd + k' to start a new question.
    • Better Dark Mode Support across the application, including SQL editor and thinking step questions.

  • Resource Management Improvements:

    • Enhanced Resource Discovery with scrollable resource sections and automatic refresh after file uploads or project creation.
    • Oracle Sidebar Enhancements with hover functionality to display full report questions and color-coded status indicators.

These updates collectively deliver a more powerful, intuitive, and transparent data analysis platform with improved reporting capabilities and a more efficient user experience.

Bug Fixes

This release includes numerous bug fixes across our platforms, enhancing stability, improving user experience, and resolving key issues in data handling and interface interactions.

Backend

  • Enhanced Data Import and Processing

    • Improves Excel and CSV file parsing to correctly identify column headers and data types, ensuring proper data structure during import and preventing null column names in databases.
    • Fixes PDF upload functionality throughout the application, allowing users to upload documents without requiring accompanying Excel/CSV files or database connections.
    • Enhances table detection accuracy with improved header identification and pattern recognition, particularly beneficial for small datasets and complex table structures.

  • Database Management Improvements

    • Ensures proper deletion of old metadata when removing databases, preventing conflicts when reuploading the same database later.
    • Improves compatibility with non-PostgreSQL databases, particularly MySQL, with UI fixes and backend refactoring to support diverse database systems.
    • Fixes Redshift integration issues, ensuring correct schema display and improving the metadata extraction interface.

  • Citation and Query Functionality

    • Enhances citation functionality by making sources clearer and more meaningful, helping users better understand which specific references are being used in analyses.
    • Improves golden query management in the alignment model interface, ensuring queries can be properly added and updated.

  • Error Handling and System Reliability

    • Implements better error validation for report IDs, providing clear error messages when requested reports don't exist.
    • Improves error handling during file uploads by sending plain text error messages, making troubleshooting more straightforward.
    • Enhances installation reliability on Windows systems by properly handling line ending differences between operating systems.

Frontend

  • Search and Input Improvements

    • Fixes search bar functionality to allow typing slash characters without triggering unwanted menu focus.
    • Enhances text area animations with smooth height adjustments based on content and reasonable maximum height limits.
    • Improves the SingleSelect component with better dropdown behavior, custom value handling, and more intuitive focus management.

  • File Upload Enhancements

    • Resolves file upload issues across all search bars and modes in the Oracle embed.
    • Enables PDF file uploads in fast analysis mode, enhancing document analysis capabilities.
    • Fixes file extension handling to ensure proper processing of uploaded files.

  • Analysis and Navigation Fixes

    • Corrects auto-scrolling to newly created analyses and improves the display order in tree views.
    • Fixes an issue where original questions would be lost during deep research clarification prompts.
    • Improves project name handling when creating new fast analyses.

  • Visual and Layout Enhancements

    • Resolves CSS styling issues in Oracle question clarifications for proper display of search bars and file upload components.
    • Improves alert positioning to appear above search bars without disrupting layout.
    • Fixes multi-line question display in fast analysis mode to keep the submit button accessible on screen.

Documentation

This release brings significant improvements to our documentation across multiple repositories, enhancing both developer experience and AI assistant capabilities.

Backend

  • Enhanced Developer Guidance: A new dedicated CLAUDE.md file provides comprehensive test instructions and guidance specifically for AI assistants working with the codebase, complementing the updated README.md with improved developer documentation.
  • Docker Configuration Improvements: The docker-compose.yaml now includes named containers, making command execution and log access more intuitive during development and testing workflows.

Frontend

  • AI Assistant Integration: Introduces a new CLAUDE.md file with detailed guidance for AI assistants, establishing clear conventions and workflow documentation to ensure higher quality AI-generated code contributions.

These documentation improvements streamline the onboarding process for both human developers and AI assistants, establishing clearer conventions and providing more accessible guidance for working with our repositories.

Maintenance

This release includes significant infrastructure and code quality improvements across our repositories, enhancing performance, reliability, and maintainability.

Backend

  • Performance Optimization: The backend now uses uvloop instead of the default asyncio worker class, dramatically improving performance. File upload speeds are now significantly faster—large files that previously took over a minute now upload in seconds. Multiple workers have been added to prevent CPU-intensive tasks from blocking the service.

  • Database Improvements: We've implemented automated database schema migrations that allow the application to update smoothly when new data fields are added, without disrupting existing data. The internal 'DbCreds' component has been renamed to 'Project' for better clarity and organization.

  • Enhanced Error Handling: Detailed error messages have been added throughout the application, making it easier to identify and troubleshoot issues when SQL queries fail or database credentials are missing.

  • Improved User Interface: Report citations have been reformatted to make them more user-friendly in the interface, ensuring a more consistent and readable presentation of reference materials.

  • Strengthened Testing Infrastructure:

    • Backend route tests are now standalone, allowing developers to run tests individually or as a group without dependencies between tests
    • Test coverage for file upload functionality has been enhanced to ensure reliable handling of various file combinations including PDFs, CSVs, and Excel files
    • New tests have been added for upload files combinations to improve system stability

  • Code Reorganization: File upload utilities have been restructured into smaller, specialized modules for improved code organization and maintainability, making the codebase more robust and easier to maintain.

Frontend

  • Improved Component Architecture: The Oracle Report component has been refactored into smaller, more manageable components, improving code organization and maintainability without changing functionality for end users.

  • Enhanced Visual Presentation: Clarifications now have improved visual presentation with simplified code structure and enhanced legibility. An unintended blur effect caused by excessive nesting has been removed, resulting in a cleaner and more readable interface.

  • Code Quality Improvements:

    • Oracle utilities have been refactored into smaller, more maintainable files, splitting a large utility file into specialized modules for API services, editor functions, export capabilities, and more
    • AgentUtils has been converted to TypeScript JSX format
    • Small type issues in menu components, select dropdowns, and analysis results tables have been fixed

These maintenance improvements create a more sustainable codebase that will enable faster feature development and bug fixes in the future, while delivering immediate performance benefits to users.

Assets 2
Loading