Announcing fixSQL v1.0: General Availability

Today we're announcing the first General Availability release of fixSQL.

fixSQL was built to make FIX data accessible using standard SQL workflows, without requiring complex data engineering or proprietary infrastructure. The initial release focuses on local-first analytics powered by DuckDB, enabling teams to ingest, normalize, index, and query FIX data directly on their own machines.

Version 1.0 introduces a command-line workflow for ingesting FIX log files from any source, automatically building schemas and indexes through intelligent data sampling. The platform normalizes FIX data into encoding-agnostic semantic names, making datasets easier to query and analyze across different FIX dialects and versions.

The release also adds lifecycle management capabilities for datasets and indexes, including incremental updates, update tracking, and dataset maintenance operations.

fixSQL is designed to support a wide range of operational and analytical workflows, including onboarding and testing acceleration, masking production datasets, compliance reporting, reconciliations, ad-hoc investigations, and reconstructing order lifecycle audit trails.

Key capabilities in v1.0 include:

• Local-first analytics with DuckDB
• Ingestion of FIX log files from any source
• Automatic schema and index generation
• Incremental dataset updates and lifecycle management
• Semantic normalization of FIX data
• SQL-based querying over large FIX datasets
• Support for all FIX versions and custom dialects